Draw an ER Diagram, or EER Diagram as appropriate, for each of these scenarios.
Draw an ER Diagram, or EER Diagram as appropriate, for each of these scenarios.
A soccer league has a set of teams, each of which has a team ID number, name, stadium name, and location (city). Each team has many players, and each player belongs to only one team. Each player has a player ID number, name, date of birth, start year, and a jersey number.
Teams play matches. In each match there is a host team and a guest team. Information about a given match includes the date on which the game is played, and the score (one value for the guest team and one value for the host team).
The league has referees, each of which as a referee ID number, a name, date of birth, and start year. Each match is assigned three referees, one of which is designated as the main referee (the other two are assistant referees). Note that a referee may be the main referee for some matches and an assistant referee on others.
[Hint: Make Match its own entity type. Include two relationships between Team and Match, one to indicate a team hosts a match and the other to indicate a team is a guest.]
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
