E E4810 Pages: 4

MEMBERS(MEMBERID, MEMBERNAME, MEMBERTYPE)
ISSUEDTO(ACC-NO, MEMBERID, DATE OF ISSUE)

Write relational algebra expressions for the following queries:
a) Accession Number(s) and Name(s) of third edition books published in (2)

2018.
b) Names and dates of issue of books taken by amember with name ‘PRIYA’. (3)
c) Names of books not taken by any member. (4)

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

album_name

b) What is meant by referential integrity? How is it implemented using (5)
foreign key? Illustrate using a real example.
PART C
Answer all questions, each carries 3 marks.
8 Consider two tables STUDENT(ROLLNO,NAME,CLASS) and (3)

ENROLLMENT(ROLLNO,COURSENAME) where ROLLNO in
ENROLLMENT is a foreign key referring to STUDENT. It is required that
every time aSTUDENT tuple is deleted, all the ENROLLMENT tuples referring

Page 2 of 4