A N:M relationship is represented with a(n)
A)composite table.
B)linking field.
C)intersection table.
D)entity.
E)index field.

Question

Quizplus · Accepted Answer

A N:M relationship requires a separate table to represent the intersection of the two entities. This table is called the intersection table, as it intersects the two entities involved in the relationship. Therefore, option C is the correct answer.

Option A (composite table) is related to creating multiple-attribute tables that are created by combining existing tables.

Option B (linking field) is used to connect two tables, but it does not represent a N:M relationship.

Option D (entity) is a term used for a person, place, thing, or event, that is represented by a set of attributes or properties.

Option E (index field) is used to sort or order records for faster retrieval, but it is not related to N:M relationships.

A N:M Relationship Is Represented with A(n)