Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

policy number, owner name, insured amount, and name of the verencialy. (25 pts.) Design an ER diagram for a simple database for the National Hockey

image text in transcribed
policy number, owner name, insured amount, and name of the verencialy. (25 pts.) Design an ER diagram 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 (each has an id and the injury description) 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 July 4th, 2016) and a score (such as 4 to 2) (Hint: Include a weak entity set in your design]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Successful Keyword Searching Initiating Research On Popular Topics Using Electronic Databases

Authors: Randall MacDonald, Susan MacDonald

1st Edition

0313306761, 978-0313306761

More Books

Students also viewed these Databases questions