0

I am wondering if this can be modeled accurately with an ERD:

Each Medal is awarded to only one Player of each winning Team.

vahid
  • 1,118
  • 9
  • 13

1 Answers1

0

In other words:

  • Each Medal is won by one Team and one Player.
  • Each Player plays for one Team and is awarded zero to many Medals.
  • Each Team wins zero to many Medals, each Medal going to one player.

Entity relationship diagram

thegeko
  • 1,382
  • 1
  • 13
  • 18
  • thanks for your quick response. This does not to seem to cover that the player receiving the award should be a member of the team receiving it (plus, teams do not receive a medal, only players do, according to the statement.) Am I missing something? – vahid Dec 16 '15 at 20:42
  • Sorry, I forgot to respond and then it got off my radar. In my model, the player intentionally does not need to be a (current) member of the team receiving the medal. I was assuming players can switch teams. The fact that a player is a member of a team can be tracked in a different association table. It is true that player receives the medal, but you might want to track which team the player played for when he won the medal. – thegeko May 21 '17 at 20:07