Question
1. Draw an E-R diagram for a database recording information about teams, players, and their fans, including - For each team, its name, its players,
1. Draw an E-R diagram for a database recording information about teams, players, and their fans, including
- For each team, its name, its players, its team captain (one of its players), and the colors of its uniform. Remember that a set of colors is not a suitable attribute type for teams
- For each player, his/her name, and the history of teams on which she/he has played on, including the start date and ending date (if she/he was traded) for such team
- For each fan, his/her name, address (only one address for each fan), teams she/he likes, players she/he admires, and favorite color
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