E$-$R Design

Let us assume that you are being hired by a local movie theater company. This is a multiplex movie theater complex with multiple screens within a single complex. They want you to design a database for their company. They need to store information about their auditoriums, movies they will project in their auditoriums, ticket sales, concession inventory, employee data and payroll.

For each auditorium, your database needs to keep track of number of seats, total area, and availability of handicap seats.

For each movie, you need the title, company that produced the film, duration, dates will be available and which auditoriums will show such film.

For ticket sales, you need to keep a record of each sale transaction that will include date of purchase, number of tickets sold, movie, date, time and auditorium of the movie show, payment type $($cash or credit$),$ type of tickets $($child$,$ adult, senior or handicap$),$ price per ticket.

For the concession inventory, the database needs to store information about items for sale in the concession stand which include candy, bottles of water, per pound amount for corn, salt, butter and sugar as well as utensils such as napkins, cups, straws, etc.

For each employee, you need name, address, birthday, phone number, email, job classification and pay rate per hour.

The payroll needs hours and dates worked during the week for each employee to print their paychecks.

You must add at least two more requirements to the information listed above, then design an E$-$R diagram that captures all the expectations $($including yours$).$