Suppose you are given the following requirements for a simple database for the National Hockey League...

  

Transcribed Image Text:

Suppose you are given the following requirements for a simple database for the National Hockey League (NHL): The NHL has many teams Each team has a name, a city, a coach, a captain, and a set of players • Each player belongs to only one team Each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records • A team captain is also a player • A game is played between two teams (referred to as host_team and guest_team) and has a date (such as May 11th, 1999) and a score (such as 4 to 2). Construct a clean and concise ER diagram for the NHL database. Suppose you are given the following requirements for a simple database for the National Hockey League (NHL): The NHL has many teams Each team has a name, a city, a coach, a captain, and a set of players • Each player belongs to only one team Each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records • A team captain is also a player • A game is played between two teams (referred to as host_team and guest_team) and has a date (such as May 11th, 1999) and a score (such as 4 to 2). Construct a clean and concise ER diagram for the NHL database.

Answer rating: 100% (QA)

Note ER diagram b... View the full answer