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 are designated as functionally dependent attributes
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

Question

Quizplus · Accepted Answer

In a binary many-to-many relationship, a separate relation C must be created, and its primary key is a composite key consisting of the primary key for each of the two entities in the relationship. This is known as the associative entity approach, and it helps to resolve the many-to-many relationship by introducing a third entity to represent the relationship between the two entities. This approach also ensures that the relationship between the two entities is properly maintained and can be queried efficiently. Therefore, option A is the best choice. Option B is incorrect because it implies that the many-to-many relationship can be resolved by designating the primary keys of relation A and relation B as functionally dependent attributes, which is not a valid solution. Option C is incorrect because it suggests that secondary keys can be used to establish the relationship, which would not provide a unique reference to each of the entities in the relationship. Option D is incorrect because it does not create a separate relation for the many-to-many relationship, which is necessary to maintain the integrity of the relationship.

For a Binary Many-To-Many Relationship Existing Between Entity Types a and B