I am working on designing an entity-relationship diagram (ERD) for a football system, I stopped in the relationship between the Player and Team entity types, as we know a player plays for only one team and a team have many players, so the relationship will be:
Team 1…* Player
But, how can I represent this relation when a player can play in more than one team? In real life, a player has a contract with a team, when that contract ends, the player may continue with the same team or with other team, so the relation will be
Team *…* Player, or
Team 1…* Contract *…1 Player
- Is my understanding is well?
- Do you have any suggestions about the two scenarios?