Give one ER model for Chapter 5 Exercises 5 8 Below 5 has

--> Give one E-R model for Chapter 5, Exercises 5 – 8( Below, #5 has 10 sub questions)

Note: Exercises 5 – 8 cover different parts of an E-R model. For problem 3, only one E-R model

needs to be submitted for covering all parts of the E-R model from Exercises 5 – 8. The list of 1-

10 on the top of Page 77 is a list of queries which tell you how users will use this database, you

read the queries to verify whether or not data in your E-R model provide sufficient information

to answer these queries, but you do not need to do queries; exercises 6-8 are at the bottom of

Page 77.

For the following, Go to http://www.dssbooks.com/web/ProjectsManual.html

EXERCISES 1. Give two instances of the InsuranceCompany entity in the E model of the healthcare database in Figure 5.19

Solution

Answer:

First create the sale table with ticket ,ticket amount, available tickets, date time,and id of customer and other info,who is buying.

So query is

1)

11)

!!!)

2) Top 5 awardwing movies

3) creat the table for theater with col movie_id, purchase,pchase_date,due_amount

4)The tble colounms are given in question are insufficient to produce the result so create one more table. movie_sell with coloumns movie_id,selling_count.

5)

so the other question (multople question asked in one question)