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

Guidelines For Ideal Business Objectives

Guidelines For Ideal Business Objectives

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

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

Limited Liability Companies

Limited Liability Companies

California State University, Northridge BUS 104 | Introduction to Business

Lecture Note

Understanding Marketing

Understanding Marketing

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

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