Multiple Choice
For a unary M:N relationship:
A) the entity type is modeled as one relation; a separate relation is created to represent the M:N relationship; the new relation has a composite key that consists of two attributes that both take their values from the same primary key.
B) the entity type and the M:N relationship are modeled as one relation; a composite key consisting of two attributes that both take their values from the same primary key is used as the primary key for the relation.
C) separate relations for the class and for each subclass are created; primary and foreign keys are established for each class.
D) the primary key of the entity on the one side of the relationship serves as a foreign key in the relation on the many side of the relationship.
E) none of the above is true.
Correct Answer:

Verified
Correct Answer:
Verified
Q25: Indexes should be used judiciously for databases
Q38: One property of a relation is that
Q42: Match each of the following file organizations
Q89: Normalization helps build a data model that
Q98: The primary deliverable from logical database design
Q104: During physical design, you consider:<br>A) the definitions
Q124: File restoration can be achieved through backup
Q168: Match each of the following E-R structures
Q229: Which of the following properties of a
Q240: Referential integrity specifies that the value of