Consider relations X and Y, each representing one of two entities in a many-to-many binary relationship. Relation Z is the additional relation created to store the many-to-many relationship. Intersection data ____.
A) is stored in relation X or in relation Y, but not in both
B) must be stored in both relations X and Y
C) is stored in relation Z
D) is stored in all three relations X, Y, and Z
E) cannot be stored in any of relations X, Y, or Z

Question

Quizplus · Accepted Answer

Intersection data for a many-to-many relationship is stored in a separate relation, which is relation Z in this context. This relation typically contains foreign keys that reference the primary keys of the two entities involved in the relationship.

Consider Relations X and Y, Each Representing One of Two