Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Introduction to Database Systems I apologize for 2 questions, but both questions are connected to each other. Give an E/R diagram for a database recording
Introduction to Database Systems I apologize for 2 questions, but both questions are connected to each other.
Give an E/R diagram for a database recording information about teams, players, and their fans who are season ticket holders including: 1. For each team, its name, its players, its team captain (one of its players), and the colons 1. of its uniform 2. For each player, his name 3. For each fan, his/her name, favorite teams, and favorite players 4. Assume each fan has a unique season ticket number. 5. Assume each player has a unique name for this exercise 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 arrows. 2. Suppose we want to add to the schema of problem 1 a relationship Led-by among two players and a team. The intention is that this relationship set consists of triples (playerl, player2 team) such that player 1 played on the team at a time when some other player 2 was the team captain (a) Draw the modification to the E/R diagram. (b) Replace your ternary relationship with a new entity set and binary relationshipsStep 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