Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started