Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started