Practice ER Diagram Question – A Sample Solution - Edubirdie

University:
California State University, Northridge
Course:
BUS 104 | Introduction to Business
Academic year:

2022
Views:

0

Pages:

1
Author:

Devender Mahlawat

Practice ER Diagram Question – A Sample Solution 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). Construct a clean and concise ER diagram for the NHL database using the Chen notation as in your textbook. List your assumptions and clearly indicate the cardinality mappings as well as any role indicators in your ER diagram. Here is one sample solution. Note that other diagrams are possible depending on assumptions. score date game host skill level guest captain player team injury record log belongs to t-name description coach city p-name position id

Related Documents

Practice ER Diagram Question – A Sample Solution

Practice ER Diagram Question – A Sample Solution - Page 1

of 1

Recommended Documents

Characteristics And Dynamics Of Modern Business

Characteristics And Dynamics Of Modern Business

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

Sources Of Technological Dynamics For Firms

Sources Of Technological Dynamics For Firms

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

Changing Concept And Objectives Of Business

Changing Concept And Objectives Of Business

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

Pricing Policy In Public Enterprises

Pricing Policy In Public Enterprises

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

Types Of Industrial Finance

Types Of Industrial Finance

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

Punnett Square Practice Worksheet

Punnett Square Practice Worksheet

California State University, Northridge BUS 104 | Introduction to Business

Assignment

Use-Based Classification Of Industries

Use-Based Classification Of Industries

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

Joint Sector And Cooperative Sector In Business

Joint Sector And Cooperative Sector In Business

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

TOP DOCUMENT

Marketing in Rural Mkts: Segmentation & Positioning

Marketing in Rural Mkts: Segmentation & Positioning

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

Final Project CMA

Final Project CMA

California State University, Northridge BUS 104 | Introduction to Business

Answer Key

Pathways Exploration Template

Pathways Exploration Template

California State University, Northridge BUS 104 | Introduction to Business

Other

Activity-motives For Imperialism Homework

Activity-motives For Imperialism Homework

California State University, Northridge BUS 104 | Introduction to Business

Answer Key

New Documents from this Course

Objectives Of Price And Distribution Controls

Objectives Of Price And Distribution Controls

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

Government and Controls Over Public Enterprises

Government and Controls Over Public Enterprises

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

Falling Birth Rates And Changing Age Structure

Falling Birth Rates And Changing Age Structure

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

Trends In Political,Economic Philosophies And Outlook

Trends In Political,Economic Philosophies And Outlook

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

The Technological Environment & Innovations

The Technological Environment & Innovations

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

The State, Institutions, And Economic Outcomes

The State, Institutions, And Economic Outcomes

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

Scenario Development

Scenario Development

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

Forecasting for Business Environment & Strategy

Forecasting for Business Environment & Strategy

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

The Business Environment

The Business Environment

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

Competitive Structure Of Industries. Cheat Sheet

Competitive Structure Of Industries. Cheat Sheet

California State University, Northridge BUS 104 | Introduction to Business

Cheat Sheet

Competitor Analysis

Competitor Analysis

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

Benefits Of Industry Analysis

Benefits Of Industry Analysis

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note