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.

Import into your Project

Posted by: Carol Sandusky

Turn every software project into a successful one.

Try Visual Paradigm for Free! Or learn more about our features.

5 1 vote
Article Rating
Inline Feedbacks
View all comments