$2088 Pages: 4

all the artists have sung songs.

7 2) Use the standard synthesis procedure to generate the set of relations corresponding (4)
to the ER diagram below. Identify primary and foreign keys of the relations

തില്‍
ത്ത
ட பட்டப்‌

‎ர்வ‏ سے

‎|
‎(^ (णा 2५

‎Airplane
‎0 ४

‎DepartureDate

‎ttureTime‏ ) کس تی

‎b) In the relational schema for a library given below, foreign keys have the same (5)
name as primary keys. Draw an ER diagram for the schema, clearly marking keys
and cardinality constraints.
BOOKS(ACC-NO, TITLE, EDITION, YEAR)
MEMBERS(MEMBERID, MEMBERNAME, MEMBERTYPE)
ISSUEDTO(ACC-NO,MEMBERID, DATEOFISSUE)

‎PART C
Answer all questions, each carries 3 marks.
8 Illustrate DELETE and UPDATE clauses using typical examples. (3)
9 Given two tables STUDENT(ROLLNO,NAME,CLASS) and (3)

‎ENROLLMENT(ROLLNO,COURSENAME) where ROLLNO in ENROLLMENT
refers to STUDENT, what does the following SQL statement return?
SELECT COURSENAME FROM ENROLLMENT WHERE ROLLNO = ALL
(SELECT ROLLNO FROM STUDENT)
10 Define super key and minimal super key and illustrate using good examples. (3)

‎11 Given a relation R(A,B,C,D,E,F) with functional dependencies ൧-8, B—D, DEF, (3)
F—A, compute {D}+ and {EF}+.

‎Page 2 of 4