Figuer:
-Assuming that we do not use the rule(s)that avoid null values in tables,the table VOLUME obtained in converting the ERD diagram to a relational database will have the following primary key:
A) Volume#
B) Title
C) Combination Volume#, Title
D) Combination Volume#, Title, #-of-pages

Question

Figuer: 
-Assuming that we do not use the rule(s)that avoid null values in tables,the table VOLUME obtained in converting the ERD diagram to a relational database will have the following primary key:
A) Volume# 
B) Title 
C) Combination Volume#, Title 
D) Combination Volume#, Title, #-of-pages

Quizplus · Accepted Answer

The primary key for the VOLUME table, when converting from an ERD diagram without rules to avoid null values, would likely be a combination of Volume# and Title. This is because Volume# alone might not uniquely identify a record if the same volume number can be used across different titles, and Title alone might not be unique if a title can have multiple volumes. Combining Volume# and Title ensures each record is uniquely identified. Option D adds an unnecessary attribute (#-of-pages) to the primary key, which is not needed for uniqueness in this context.

Figuer: -Assuming That We Do Not Use the Rule(s)that Avoid Null