Complete Chapter 5 Exercise 3 Give two instances of the Order relationship in the E-R model of the healthcare
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-mailEmployees with their ID name date of hire employment history and salarywhere employment history is a multi-valued attributeProducers with their ID name contact information (address phone numberand e-mail) and current balanceMovies with their ID title year of production rating description awards wonand actors where awards won and actors are multi-valued attributesShowrooms 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 members 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
Like this:Like Loading…
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
WHATSAPP CHAT: +1 (781) 253-4162
Click ORDER NOW..
