ER Modeling Suppose you are given the following requirements for a simple database for the National Hockey League (NHL):The NHL has many teamsEach team has a name, a city, a coach, a captain, and a set of playersEach player belongs to only one teamEach player has a name, a position (such as left wing or goalie), a skill level, and a set of injury recordsA team captain is also a playerA 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). Draw the ER diagram to represent the above scenario

Database: Each and every organization contains a certain amount of data, all these need to be…

Answered: ER Modeling Suppose you are given…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

ER Modeling

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).

Draw the ER diagram to represent the above scenario

Expert Solution