Directions: Develop an E-R (or EER depending upon need) Diagram. List all assumptions. Show the version 1 (entities and data only) and version 3 (entities, attributes and relationships with cardinalities and participation constraints). 20 points of the grade will be based on evaluating your assumptions you must give a detailed list of your assumptions identifying anchor concepts, data associated with the anchor and data that has more than one anchor participating in it. Remember, we are not talking out this problem like we did in class, so you should have a lot of assumptions (think of it as listing out what you know of the problem). ______________________________________________________________________________________

You are to model a database for a movie theatre company. The company has regional corporate offices, regional locations, staff in the corporate offices theatres, contracts with production companies. Each theatre has a location, unique identification number, staff, a number of auditorium, seating capacity for each theatre, movies they are currently offering rewards program, previews that are associated with each movie, concessions with concessions vendors.

For the corporate offices, for each employee, we record the name, company ID, salary, home address, home telephone, birthdate, start date, gender, and position.

For the local theatre offices, for each employee we record the name, company ID, salary, home address, home telephone, birthdate, start date, gender, position, and work schedule. Theatre employees are assigned to certain auditoriums to work in.

Each auditorium has employees who take care of it during certain shifts during the day. The auditorium has a number of seats and a number of handicapped accessible seats. It can have multiple movies assigned to it with different time associated with the movie. We track the status of whether the auditorium has been cleaned or serviced after a movie. We can take reservations for seats on-line so we track the seats that are currently reserved. We track the cost of each seats ticket cost so that we can analyze later how much money the auditorium made.

The theatre shows movies. Movies can be associated with multiple auditoriums. Movies are shown at certain times. Previews and commercials are associated with specific movies. Movies have ratings. Movies also have distributors and production companies. Distributors charge us a percentage of the sales for each movie to show the movie. Each distributor has a different rate for each movie. Movies also have posters. We record the placement of the poster in the theatre and the sale price for putting the poster up.

The company has customers or clients. These clients can belong to our rewards programs. For all customers, we record their name, email, phone number, address, credit card information, birthdate and gender. We track how much the customer spends on every transaction. We classify transactions as ticket sales or concession sales. Customers can belong to the rewards program. If they belong to the rewards program, we record a $5 coupon for every $100 they spend. This will get applied to their next bill and we will zero the coupon out after use.

All theatres offer concessions. We record the types of concessions and the vendor from which we get them from. We track a quantity, a gross price, and a sale price. With the sales, we track how much each of the concession items make daily. For drinks, we will consider 8oz or one bottle/can as a serving.