Question #6: ERD (15%) 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).

Question #6: ERD (15%) 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).