Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A question about conformance of instances to ER schemas. Assume an ER schema with entity types Reader and Book, and relationship type Borrow between Reader
A question about conformance of instances to ER schemas. 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. Which of the following statements is correct?
In an instance conforming to this schema, it is allowed that some Book entities have values for author and title, but not for ISBN.
There are instances conforming to this schema where the same Book is involved in multiple relationships.
There are instances conforming to this schema where the same Reader is involved in multiple relationships.
There are instances conforming to this schema that have no Borrow relationships.
In an instance conforming to this schema, every Borrow relationship must have a value for the date attribute.
There are instances conforming to this schema that have no Reader entities.
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