Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Visual C# And Databases

Authors: Philip Conrod, Lou Tylee

16th Edition

1951077083, 978-1951077082

More Books

Students also viewed these Databases questions

Question

3.4 Define HRIS and describe its main components.

Answered: 1 week ago