Certified Data Management Professional – Fundamentals (CDMP) — Question 23

A relationship that allows an address to be used by multiple people, and each person can have multiple addresses, can be resolved:

Answer options

• A. With an additional relationship describing the address usage
• B. By changing the primary keys on Person and Address to ensure referential integrity
• C. With an associative entity called Person Address Usage and two, 'one to many' relationships
• D. With a partnership entity called Person Address Usage and two, 'one to many' relationships
• E. By changing the role names of the foreign keys on Person and Address to ensure referential integrity

Correct answer: C

Explanation

The correct answer is C because an associative entity called Person Address Usage effectively manages the many-to-many relationship between people and addresses through two 'one to many' relationships. Options A, B, D, and E do not properly address the need for an associative entity to facilitate the multiple associations between individuals and addresses.