Suppose you are given the following requirements for a simple database

Question

Suppose you are given the following requirements for a simple database for the National Football League (NFL):

• the NFL 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 player position (such as Centre Forward, left midfield, center midfield, right midfield, left fullback, centre back etc..), 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, 2000) and a score (such as 4 to 2).

Construct an ER diagram for the NFL database using the Chen notation with all conventions. List your assumptions and clearly indicate the cardinality mappings as well as any role indicators in your ER diagram

15 Sep 2022

Answer :

Word Count : 1669

Here is an ER diagram for the NFL database using the Chen notation:

+-----------------+
| Team |
+-----------------+
| Name |
| City |
| Coach |
| Team_Captain_Id |
+-----------------+
|
|
+-----------------+
| Player |
+-----------------+
| Id |
| Name |
| Position |
| Skill_Level |
| Team_Id ___ _____ ________ ___ _____ _______ __________ __________ _________ _____.
______ ___ ________ ______ _____ ______ _____ ____.
_________ ___ _______ _______ ____ _____ ___ ________ __________.
____ ___ _________ __________ _____ ___ ________.
________ __________ _________ ___ _____.
____ _______ ___ __________ ___ _____ _________ ________ ________ ___ ___.
_______ ________ ___ _________ _________ __________ _______ __________ ________ ____ ____.
___ _______ _________ _______ _________ ______ _________ ____ _______ _____.
__________ _______ ___ ______ _________.
________ _________ ___ _____ _______ ___ ______ ________ _______ _______ _________ __________.
____ ___ _________ ________ _____ _______ ______ _______ ____ _______ _________ __________.
_______ __________ __________ _________ __________ _____ _______.
__________ ____ __________ _________ __________ _________ ________ _______ _________.
____ ___ __________ ___ _________ ____ _______.
______ __________ __________ __________ __________ ________ _________.
________ ___ _____ ________ ________ ______.
___ ______ __________ ____ _______ __________.
______ ______ ______ _______ __________.
________ _________ ____ ___ __________ ______ _______ ___.
____ ______ __________ _____ _____ ____ _______ _____.
__________ ____ ___ ______ _____ ____ ______ _________ _____ ____ ___.
______ ____ ________ ________ ____ ______ ________ _________ ________.
__________ ________ _______ ________ ___ _________.
__________ _____ _______ ________ _________.
________ ________ _____ ____ _____ __________ ________ _____ ______ _______ _____ _____.
___ _________ ____ __________ _____ _______ _______ ________ ___ __________.
___ ______ _________ _________ _______ ____.
_____ _____ ________ _____ _____ ___ ____ __________ ____ _______ ______.
_______ __________ ___ _________ _______ ________ _________ ______ ________.
_________ ____ ________ _____ _________ ______ ________ _________ ___ _______.
___ ________ _________ _______ _____ ______ _________ _____ ______ ________ _____ ____.
____ ____ ______ ___ _______ __________ _____ _______ ____ _____.
_______ ___ __________ _________ ________ ___ ____ _________ ____ _____ _________.
______ _______ ______ _____ _______ ______ ________ ____ ______ ______ ____.
____ ___ ______ _____ __________ ________ _____ _______ ________.
_________ ________ __________ ____ ________ ___ ____ ________.
_________ ____ ________ ________ _____ ___ __________ _______ __________ _____ ___.
__________ ________ __________ ______ ____ ______ __________ _____ _____ ___.
_________ _____ ________ __________ _________ ____ ______ ______ ______ ________ __________.
___ _________ ________ ______ _______ ____ ______ __________ ______.
___ _______ ________ _______ _______ ______.
________ ________ _______ __________ _______ _____ ____ ____ _____.
________ ___ __________ ___ ________.
_______ _____ ______ _________ ______ ____.
_________ ____ ________ ___ __________ ___ _______.
_____ _______ ______ ____ _______ ________ _________ _______ ______ __________ ________ ___.
____ ____ _______ ________ __________ _______ _________ ________.
_______ ________ _______ ________ __________ __________ ___ _________ __________ _____ ____.
___ ___ ______ ____ ________ __________ ___ ___.
__________ _____ __________ ________ _________ _____.
___ __________ ___ _________ __________ ___ ________ ______ _______ ______ __________ _____.
___ _________ ____ _____ _________ ________ __________ ____.
__________ ____ _______ ______ _________ _______ ___ ____ _____ ______ _________.
_________ ___ ______ _______ __________ _____ ______ ________.
_________ __________ ___ __________ ____ ___ _______.
_______ _____ _______ _____ _______ __________ ___ ________ __________ _________ ____ ________.
_____ _________ __________ _______ _________ __________ _____ ____ _______ _____.
__________ _____ ___ __________ ________ ______ ______ ______ __________ ______ _____.
____ ________ ________ _____ _______ __________ ____ ___.
__________ ____ _________ _______ ______ _________ ______ ______ __________ _______ ____.
______ _________ __________ ________ __________ ______ __________ __________ _______ _______.
___ ____ ____ ________ ____.
__________ ___ ______ _____ ________ ____ __________.
______ __________ _______ ________ _________ __________ _______ _____ _____.
___ __________ _____ ______ _______ ______ ______ _______ _________.
_____ ______ _______ _____ _________.
_____ ________ ____ ________ ______ ____ ______ ______.
___ _____ ______ ___ ___.
________ ____ _______ ____ ____.
______ ____ _________ ____ _________.
__________ _______ _______ _________ _____ ___ ____ ___ __________.
__________ ______ ___ ______ _______ ____ _______ ______.
________ ______ _______ ____ ____ ____ _______ ________ ________ _________ ____ _______.
_____ _______ _______ _________ ________ ___ _______ ________ ______ ______ ____ _____.
____ ____ _________ ________ _____ ___ ______ _______ __________ _________ ____ _________.
_____ ___ ____ ___ ____ ______ ________.
___ ______ ______ ____ ______ ________ _________.
__________ _____ __________ _________ ___ _________ ______ ___ ________ _________ ___.
__________ ____ ________ __________ _____ ______ ______ ________ ________ ___ ________ ___.
_____ ____ ___ _______ _________ _____ ______ __________ _______.
______ ____ ______ __________ __________.
___ __________ ______ __________ ____ ____ ____ _______ _____ ______.
__________ _____ _______ ____ ___ _________.
____ ________ ________ ___ _________ __________ _____ _______ __________ ____.
______ ________ ______ __________ _____ ______.
________ _________ _______ ____ ________ ______ _______ ___ _____ __________.
_____ ________ __________ _____ _______ __________ __________ ______.
________ ____ _____ ________ _________ __________ _____ ______ _____ ______.
_____ ___ _____ __________ ____ _____ ________ _________ ________ ___ ____ ______.
___ ________ __________ ______ ___ __________ _______ _______ __________.
_____ ____ _______ ___ ______ ____ ___ ___ __________ ____ __________ ___.
______ ____ ________ ____ ____.
____ ________ ______ ______ ______ ___ ____ ______ _______ _________ ____.
______ ____ ____ ______ ________ ______ _____.
__________ _________ _______ __________ ______ _____ _______ _____ _______ ______ __________ ___.
__________ __________ _______ _______ ____ ___ _____ ___ _______ ________.
_____ __________ ________ ________ ________ ____ __________ ________.
_____ _____ _________ ______ ________ ________ __________ _______ _____ _________.
_______ ____ ________ _____ ________ ______ ___.
____ ________ _______ ___ __________ ____ _____ _________ __________ ___ ___.
__________ __________ _____ __________ _____.
________ _______ _____ _________ ________ _____ _______ ________ __________ ____ ___.
__________ _______ __________ ___ ______ ___ _________ _______ ______ ______.
______ __________ _______ __________ _______ __________.
_________ ________ _________ ______ _________ __________ _______ ________.
_________ _____ _________ _________ _________ __________ ______ ____ ___ _________.
_____ _______ ___ ____ ____ _______ _______ __________ __________.
______ ______ _______ ______ ______ _______ ______ _____ __________.
____ _______ ________ _________ _________ ______ ____ ___ _______.
_______ ________ ____ _________ _______ _______ ________ ______ ______ _________ _____.
______ ______ _________ _________ _______ ________ __________ _________.
___ __________ ____ ______ _______ ______ ______ _________.
____ ______ _______ __________ _________ __________ _______.
____ _________ ___ ___ ___ ____ ________.
________ _______ __________ ______ ____ ____ _________ ___ ________ _____.
_________ _________ ____ ___ ___ _______.
_____ _________ ____ ____ _____ ___ ______ _________ _________.
_______ _________ __________ ___ ___ _____ ________ ________ ___ ______.
_________ ______ _________ ______ _________ ___.
__________ __________ _______ __________ __________ __________ _______ ___ ______.
______ __________ ____ __________ _________ _________ _________ ________ ____ __________ _________.
_______ _______ __________ ________ _______ _________ _____ _______ ________ ______ _______.
_________ _______ ______ ________ _________ ____ _________ ________ _______ ________.
__________ ________ ________ ___ _____ ___ ____ _____ _________ __________ ________ ____.
____ _____ ___ _______ _________ ______ ____ ________ __________.
________ ______ ______ ________ __________ _______ _____ ___ ______ ______ ___ _____.
___ _________ _________ _________ _____ ________ ______ __________ __________ ______ ___ __________.
___ _____ _______ _____ ________ _________ ________ _____.
_____ ___ _____ _______ ____.
_________ ____ ______ ________ __________ _________.
________ _____ ________ __________ _______.
_________ _________ _______ _______ ________ __________ ________ ______ ___ ___.
____ ___ _____ _______ ______ ________ _____ ___ ______ __________ ___ _____.
___ __________ _______ ___ _________ ____ ______ ________.
__________ ________ _____ __________ _____ _______.
_____ __________ _______ __________ ________ ________ ______ ______.
___ _______ _____ ________ _________ ______ ___.
____ _____ _________ ___ _______.
_____ _____ _____ _______ ______ _____ __________ _____ _________ _____ _______.
_____ _______ _____ ______ _________ ___ _____ ______ ____ ________ ____.
________ _____ _________ ______ _______ ____ ______ _______ _____ _______ ___ ______.
__________ _________ ___ __________ _________.
_________ _______ __________ ___ _____ __________ _______ ______ ________.
_______ ___ _________ ________ __________ ____ _____.
_____ __________ ____ _______ ________ ________ _____ ________ ______ _________ ______ ______.
______ ____ ___ ____ ________ _________ ___ _____ ____ ______ ___ ___.
_______ ____ ___ ________ ______.
______ _______ ____ _____ ____ ________ _____.
______ ______ ________ ________ ________.
____ ____ ________ __________ ____.
_______ _________ ___ ____ ____ ____ ______ ______ _______ ____ ____ ___.
_____ _________ ____ ______ _________ ________.
_____ _____ _______ _________ __________ _____ ________ ________ ______ ______ ___.
__________ ____ __________ _________ ________.
Get Full Answer on WhatsApp

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★