Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The organizers of National Football League (NFL) have decided to store information about their teams, players and games (as well as other information) in a

image text in transcribed
The organizers of National Football League (NFL) have decided to store information about their teams, players and games (as well as other information) in a database. You have been assigned to design and develop a database to serve that purpose. As the first step, you need to listen to their requirements and create a conceptual design. Following are their requirements: O NFL has number of teams. Each team has a unique name and their city, coach's name are also recorded. o Each player is a member of only one team. Such player has a name(first name, last name), ays at (ex: center, guard, tackle), expert class a value in scale 1-5) and uniquely identified by player id assigned by NFL. o Each player has a set of injury records where each record associates with a record id (a unique number across the records of single player) and a description of the injury. o Each team has a captain who is also a player o One game is played between two teams (called as host team and guest team) and also the date and the result for each game are recorded. Construct an ER diagram for NFL. Indicate all key and cardinality constraints and any assumptions that you make

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

Probabilistic Databases

Authors: Dan Suciu, Dan Olteanu, Christopher Re, Christoph Koch

1st Edition

3031007514, 978-3031007514

More Books

Students also viewed these Databases questions