ExamTopics Logo
Mail Us[email protected]
Menu
Cdmp Discussions
exam questions

Exam DMF All Questions

View all questions & answers for the DMF exam
Go to Exam

Exam DMF topic 1 question 15 discussion

Actual exam question from CDMP's DMF
Question #: 15
Topic #: 1
[All DMF Questions]

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

  • 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
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by MrWood47 at Jan. 18, 2025, 7:07 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Hosna2023
3 weeks, 2 days ago
Selected Answer: C
he scenario describes a many-to-many (M:N) relationship between Persons and Addresses, where: A Person can have multiple Addresses. An Address can be used by multiple Persons. To properly model this, we need an associative entity (junction table) to break the many-to-many relationship into two one-to-many (1:M) relationships
upvoted 1 times
...
MrWood47
2 months, 1 week ago
Selected Answer: C
C is correct. Tied to first NF page 149 DMBOK2
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago