For a binary many-to-many relationship existing between entity types A and B:
A) a separate relation C is created; the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship.
B) the primary keys of relation A and relation B become foreign keys in a new relation C.
C) secondary keys are used to establish the relationship.
D) place the primary key of either entity in the relation for the other entity or do this for both entities.
E) none of the above.
Correct Answer:
Verified
Q81: Each regular entity type in an E-R
Q85: An attribute that appears as a nonkey
Q88: When each nonprimary key attribute is identified
Q91: If an associative entity exists, then:
A) a
Q93: The integrity constraint that specifies that the
Q97: The dependence of nonprimary key attributes on
Q98: The transformation of an E-R diagram into
Q99: For a unary one-to-one relationship between two
Q100: A binary one-to-many relationship in an E-R
Q101: Which of the following best describes a
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents