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

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, intersection table or a composite entity. This table contains foreign keys referencing the primary keys of the original entities to establish the relationship among them.

If a Relationship Exists Among Three or More Entities,then