A performance venue hosts many concert series a year


1. A performance venue hosts many concert series a year. Performers have a name and perform several times in a concert series (each constituting a performance with a different date). Con- cert series have one or more performers and have a name and a specified seating arrange- ment. A concert series is held in one (and only one) of several concert halls, each of which has a room number. Represent this situation of con- certs and performers with an E-R diagram.

2. A restaurant chain has several store locations in a city (with a name and zip code stored for each), and each is managed by one manager. Managers manage only one store. Each restaurant location has its own unique set of menus. Most have more than one menu (e.g., lunch and dinner menus). Each menu has many menu items, and items can appear on multiple menus, and with different prices on different menus. Represent this situation of restaurants with an E-R diagram.

Request for Solution File

Ask an Expert for Answer!!
Accounting Basics: A performance venue hosts many concert series a year
Reference No:- TGS01353335

Expected delivery within 24 Hours