What type of ternary relationship CANNOT be depicted as two binary relationships?
A)One-to-one-to-one
B)Many-to-many-to-many
C)One-to-one-to-many
D)One-to-many-to-many

Question

Quizplus · Accepted Answer

A many-to-many-to-many ternary relationship cannot be depicted as two binary relationships because it would result in four tables and lose some of the original relationship attributes. For example, if we have three entities A, B, and C with many-to-many-to-many relationship among them, then we would need a table for each pair of entities as follows:

- A-B: containing information about the relationship between A and B
- A-C: containing information about the relationship between A and C
- B-C: containing information about the relationship between B and C

But this approach would lose the information about the relationship between A, B, and C together. Therefore, a ternary relationship is needed to represent the complete information.

What Type of Ternary Relationship CANNOT Be Depicted as Two