Attribute relationships
Out of all relationships, Many to Many is the trickiest one. If not modeled carefully, M;N can lead to double-counting and other unhappy consequences.
Practical ways of dealing with M;N relationships:
- Create a relationship table
- Create a compound key
- Not advisable, but sometimes necessary