Q: What are some issues when working with a many-to-many relationship? Provide some examples.
A: Many-to-Many relationships in an entity relationship diagram tend to conceal areas of poor understanding, and in fact some databases will not allow you to create such relationships. Almost always, a Many-to-Many relationship conceals a hidden entity. [ For this reason, identifying and adding the hidden entity to the model eliminates Many-to-Many relationships. This usually ends up with an extra
entity being added, which then has a One-to-Many relationship with the existing entity.
]
Rating
There are no new answers.