Question: help solve this Draw an E - R diagram for the following situation ( underline Primary Keys ) : This is a simplified model for

help solve this
Draw an E-R diagram for the following situation (underline Primary Keys):
This is a simplified model for reserving baseball tickets.
There are teams, which are identified by the team name. Teams are also located in a city.
Teams play each other in games, which occur on a particular date at a particular time. Games are
identified by a game ID, and each game has exactly two teams that play in it.
A game is played in exactly one stadium.
A stadium is identified by its name, and is also located in a city.
Stadiums have seats, which have a section number, a row number, and a seat number.
Ticket holders reserve seats for a game. Ticket holders are identified by their name.
Some ticket holders are students (students get discounts, but we are not including that in the model).
help solve this Draw an E - R diagram for the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!