Question: Consider an ER schema about library loans. There are entity types Reader and Book, and a relationship type Borrows between Reader and Book. Which of
Consider an ER schema about library loans. There are entity types Reader and Book, and a relationship type Borrows between Reader and Book. Which of the following statements are correct?
Books who nobody ever borrowed, could not be stored in a database conforming to this schema.
Defining an attribute date for relationship type Borrows allows us to store the date when the Reader took the Book with them.
Defining an attribute date for relationship type Borrows allows us to store the borrowing history of a book.
Because a book can only be borrowed to one reader at a time, we better make the edge from Borrows to Reader functional.
If we made the edge from Borrows to Book functional, a reader could only borrow one book at a time.
Relationship type Borrows is suitable for keeping track of who is currently borrowing some book.
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
