E-R model HWBasically you will be completeing several ER Models. I will provide all the video lectures, the entire textbook, and powerpoint slides from the class. It can be however long you want, just saitisfy the questions.HW#1 Listed1. Complete Chapter 5, Exercise 1Give two instances of the InsuranceCompany entity in the E-R model of thehealthcare database in Figure 5.19.2. Complete Chapter 5, Exercise 3Give two instances of the Order relationship in the E-R model of the healthcaredatabase in Figure 5.19.3. Give one (total, not one for each) E-R model that satisfies Chapter 5 Exercises 5 – 8Exercise 5A list of database application projects is available at http://www.dssbooks.com/web/ProjectsManual.html. Project 48 describes a database application for a movietheater. The movie theater database should include data about the following:• Customers with their ID, name, address, phone number, and e-mail• Employees with their ID, name, date of hire, employment history, and salary,where employment history is a multi-valued attribute• Producers with their ID, name, contact information (address, phone number,and e-mail), and current balance• Movies with their ID, title, year of production, rating, description, awards won,and actors, where awards won and actors are multi-valued attributes• Showrooms with their name, location, and capacityWhen a show of a movie is assigned to a showroom, the database records thedate and time of the show and the total number of tickets available for the show.When a customer purchases ticket(s) for a show of a movie, the database recordsthe ticket number, date, unit price, number of tickets purchased, and amountpaid. The number of tickets purchased for a show decreases the total numberof tickets available for the show. When a customer signs up as a member tobuy tickets online, the member’s login name and password are recorded. Whenthe movie theater purchases movie(s) from a producer, the database recordsthe transaction number, purchase price, purchase date, payment due date, andamount due.The manager of the movie theater queries the database to obtain certain information.The following is a list of data queries:Conceptual Data Modeling 771. Financial informationa. Create a query that presents monthly revenues from ticket sales, monthlyexpenses from salaries, monthly expenses from movie purchases, andmonthly earnings during the current year.b. Create a query that presents yearly revenues, salary expenses, and movieexpenses during the current year.2. Create a query that lists the five best movies of the current year based on thenumber of awards won.3. Create a query that lists the five most expensive movies of the current year.4. Create a query that displays the total number of tickets sold per movie indecreasing order of tickets sold.5. Create a query that presents the average room usage per showroom in the currentyear.6. Create a query that lists the 100 most preferred customers based on the amountsthat the customers spent in the movie theater.7. Create a query to present information about the producer that the movie theaterdid the most business during the current year.8. Create a query that prompts for a date and a movie title and then presents thenumber of tickets available per show for the movie on that date.9. Create a query that prompts for a movie title and then presents the weeklyshow schedule of the movie and the total number of tickets available per show.10. Create a query that prompts for a customer name and presents informationabout the tickets purchased by the customer during the current month.Given the above requirements for the movie theater database, use an E-R diagramto describe the Customer, the Employee, the Producer, the Movie, and theShowroom entities, along with their attributes. Give two instances of each entity.Exercise 6Given the requirements of the movie theater database in Exercise 5, use an E-R diagramto describe all entities and relationships in this database without the maximumand minimum cardinalities of each relationship.Exercise 7Add the maximum and minimum cardinalities to each relationship in the E-Rmodel produced in Exercise 6.Exercise 8Create superclass and subclass entities, if needed, in the E-R model produced in Exercise 7
Order Management
Premium Service
- 100% Custom papers
- Any delivery date
- 100% Confidentiality
- 24/7 Customer support
- The finest writers & editors
- No hidden charges
- No resale promise
Format and Features
- Approx. 275 words / page
- All paper formats (APA, MLA, Harvard, Chicago/Turabian)
- Font: 12 point Arial/Times New Roman
- Double and single spacing
- FREE bibliography page
- FREE title page
0% Plagiarism
We take all due measures in order to avoid plagiarisms in papers. We have strict fines policy towards those writers who use plagiarisms and members of QAD make sure that papers are original.