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 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.
Posted by: Carol Sandusky