Hockey League

Suppose you are given the following requirements for a simple database for the National Hockey League (NHL):

1. The NHL has many teams, each team has a name, a city, a coach, a captain, and a set of players,
2. 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,
3. A team captain is also a player,
4. A game is played between two teams (referred to as HostTeam and GuestTeam) and has a date (such as Jun 12th, 2017) and a score (such as 4 to 2)

This ERD example shows a clean and concise ER diagram for the NHL database.