A separate relation must be created to store the attributes of a ____ relationship among two other classes.
A)one-to-one
B)one-to-many
C)many-to-many
D)not any (not necessary)

Question

​A separate relation must be created to store the attributes of a ____ relationship among two other classes.
A)one-to-one
B)​one-to-many
C)many-to-many
D)​not any (not necessary)

Quizplus · Accepted Answer

A separate relation must be created to store the attributes of a many-to-many relationship among two other classes. This is because, in a many-to-many relationship, there can be multiple instances of each class relating to multiple instances of the other class, and storing the attributes directly in either of the original classes would result in redundancy and data inconsistency. Therefore, a separate table is created to store the attributes, with foreign keys from both original classes referencing the new table.

​A Separate Relation Must Be Created to Store the Attributes

A Separate Relation Must Be Created to Store the Attributes