10
11

a)
b)

02000CS208052002

Covert the following ER Model to Relational Model (9)

CreditPoints

course_id

CreditPaints

YearCommenced

Differentiate Natural join, Equi-join and Left outer join (3)
Consider the schema given below. (6)
employee (person-name, street, city)

works (person-name, company-name, salary)

company (company-name, city)

manages (person-name, manager-name)

Write relational algebra queries for the following questions

a. Find the names and cities of residence of all employees who work for First

Bank Corporation.

b. Find the names, street address, and cities of residence of all employees who

work for First Bank Corporation and earn more than $10,000 per annum.

c. Find the names of all employees in this database who live in the same city as

the company for which they work.

PART C
Answer all questions, each carries 3 marks.
With suitable example, list aggregate functions in sql (3)
What is the importance of views in sql? Explain with suitable example. (3)
Illustrate different anomalies in designing a database. (3)
How can we conclude two FDs are equivalent? (3)

Page 2 of 4