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
Borrowmemberid includedin Readermemberid is an inclusion dependency that is generated.
author title is a key generated for the relation scheme for Book.
BookISBN incudedin BorrowISBN 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
