Consider Relations X and Y, Each Representing One of Two

Multiple Choice

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