Looking for an ERD for this three-way relationship

4k Views Asked by At

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

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

1

There are 1 best solutions below

2
On

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