If a relationship exists among three or more entities, then:
A) recursive relationships must be established through the use of recursive foreign keys.
B) a separate relation with a primary key that is the composite of the primary keys of each of the participating entities is created.
C) separate relations are established for each class and for each of the subclasses.
D) use the primary key of relation A as a foreign key in relations B and C.
E) none of the above is done.

Question

Quizplus · Accepted Answer

When a relationship exists among three or more entities, a separate relation with a primary key that is the composite of the primary keys of each of the participating entities is created. This is known as a junction table or intersection table. This table serves as a bridge or connector between the other tables and allows for an efficient way to represent the relationship among multiple entities. The other options listed are not typically used in this scenario.

If a Relationship Exists Among Three or More Entities, Then