Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,

image text in transcribedimage text in transcribed

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 seat's 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. 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 seat's 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Management With Website Development Applications

Authors: Greg Riccardi

1st Edition

0201743876, 978-0201743876

More Books

Students also viewed these Databases questions

Question

List the benefits of depositary receipts to the investors.

Answered: 1 week ago

Question

How does selection differ from recruitment ?

Answered: 1 week ago

Question

6. How do histories influence the process of identity formation?

Answered: 1 week ago