Question: Assume an ER schema with entity types Reader and Book, and relationship type Borrow between Reader and Book. Reader has two attributes memberid and name,

Assume an ER schema with entity types Reader and Book, and relationship type Borrow between Reader and Book. Reader has two attributes memberid and name, where memberid is the key. Book has two attributes ISBN, author, and title, where ISBN is the key. The edge from Borrow to Reader is functional. Borrow has one attribute date. We want to convert this ER schema to a relational schema with keys and inclusion dependencies. Which of the following statements are correct?
The default key generated for the relation scheme for Borrows is {memberid, ISBN}.
{ISBN} is a key generated for the relation scheme for Borrows.
The relation scheme generated for Book has attributes {ISBN, athor, title, memberid, date}.
Borrow[memberid] included-in Reader[memberid] is an inclusion dependency that is generated.
{author, title} is a key generated for the relation scheme for Book.
Book[ISBN] incuded-in Borrow[ISBN] is an inclusion dependency that is generated.
The relation scheme generated for Reader has attributes {memberid, name, ISBN, date}.
The relation scheme generated for Borrow has attributes {memberid, ISBN, date}.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!