Depending on the attributes and circumstances present, the unique identifier of an associative entity could be any of the following, except _____.
A) the combination of the unique identifiers of the entities in the many-to-many relationship consisting of exactly one field from each entity
B) the combination of the unique identifiers of the entities in the many-to-many relationship consisting of several fields
C) the combination of the unique identifiers of the entities in the many-to-many relationship plus one or more additional fields that express times or dates
D) a single field that is associated with the associative entity and provides unique values
E) a unique combination of fields from one of the two entities in the many-to-many relationship

Question

Quizplus · Accepted Answer

All the other options given are valid ways to identify an associative entity, but E is the exception. A unique identifier for an associative entity must include fields from both entities in the many-to-many relationship, not just one.

Depending on the Attributes and Circumstances Present, the Unique Identifier