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 ER 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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
