Figuer:
-The table WRITTEN-BY obtained in converting the ERD diagram to a relational database will have the following primary key:
A) Title
B) Combination Title, Aname
C) Aname
D) Combination Title, Aname, author-rank-in-book

Question

Figuer: 
-The table WRITTEN-BY obtained in converting the ERD diagram to a relational database will have the following primary key:
A) Title 
B) Combination Title, Aname 
C) Aname 
D) Combination Title, Aname, author-rank-in-book

Quizplus · Accepted Answer

The WRITTEN-BY table will have a composite primary key consisting of both Title and Aname columns. This is because a book can have multiple authors, and an author can contribute to multiple books. Therefore, a combination of both columns is needed to uniquely identify each entry in the table. Including author-rank-in-book as part of the primary key would not be appropriate since multiple authors can have the same rank in a book.

Figuer: -The Table WRITTEN-BY Obtained in Converting the ERD Diagram to Diagram