Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A football fan club wants to start a database to track information about teams, players, and the fan club members. Draw an E/R diagram for

A football fan club wants to start a database to track information about teams, players, and the fan club members. Draw an E/R diagram for a database recording information about teams, players, and their fans which includes:

1. For each team, its name, its players, its team captain (one of its players), and the colors of the team uniform.

2. For each player, his name.

3. For each fan, his/her name, email addrress, favorite teams, and favorite players

4. Assume each fan has a unique season ticket number.

5. Assume each player has a unique name (first name, last name) for this exercise.

You may assume that the club is not too large so that each member has a unique name (first name and last name). Remember that a set of colors is not a suitable attribute type for teams and you have to get around this restriction. Underline the primary keys in your E/R diagram and indicate any many-one or one-one relationships by using the appropriate arrows.

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

Databases Illuminated

Authors: Catherine Ricardo

2nd Edition

1449606008, 978-1449606008

More Books

Students also viewed these Databases questions