The BA learns that an Owner may prefer certain Maintenance Providers and that the business domain takes the Owner’s preferences into account when responding to maintenance needs. Which of the following best describes the change(s) the BA should make to the ERD?
- New relationship between Maintenance Provider and Owner
- New associative entity between Maintenance Provider and Owner
- New attributive entity for Owner called Provider Preference
- New attributes for Owner and Maintenance Provider
- No changes to ERD required for this discovery
You Answered: B
Correct Answer: B
Correct! This new discovery reveals a new relationship: “Each Owner prefers zero to many Maintenance Providers; each Maintenance Provider is preferred by zero to many Owners.” Because the relationship is many-to-many, an associative entity is required to resolve the many-to-many relationship.