To convert a conceptual model with a maximum Multiplicities relationship of "many to many" into relationship database tables,one must:
A)Create a foreign key in one of the tables to link the two tables.
B)Create a relation with no attributes of its own.
C)Create a relationship table to handle the many-to-many relationship.
D)Many-to-many relationship cannot be represented in Access.

Question

Quizplus · Accepted Answer

A many-to-many relationship cannot be directly represented in a relational database. Instead, a bridge entity, also known as a junction table or intersection table, should be created to link the two related entities. This table should contain the primary keys of both tables as foreign keys, as well as any additional attributes necessary to describe the relationship between them.

To Convert a Conceptual Model with a Maximum Multiplicities Relationship