CENTRAL SCHOOL LIBRARY
Observe the ER diagram for the CENTRAL SCHOOL LIBRARY

-How many tables in the relational schema mapped from the Central School Library ER diagram will have composite primary keys?
A)0
B)1
C)2

Question

CENTRAL SCHOOL LIBRARY
Observe the ER diagram for the CENTRAL SCHOOL LIBRARY
 
-How many tables in the relational schema mapped from the Central School Library ER diagram will have composite primary keys?
A)0 
B)1 
C)2

Quizplus · Accepted Answer

In a typical Central School Library ER diagram, entities like "Borrow" or "Loan" that represent many-to-many relationships between "Books" and "Students" or "Books" and "Members" would require composite primary keys. These keys are composed of the primary keys from the entities they connect, leading to at least two tables with composite primary keys.

CENTRAL SCHOOL LIBRARY Observe the ER Diagram for the CENTRAL SCHOOL LIBRARY