Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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 relationships

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

Knowledge Discovery In Databases

Authors: Gregory Piatetsky-Shapiro, William Frawley

1st Edition

0262660709, 978-0262660709

More Books

Students also viewed these Databases questions