Need answer of Question # 5 (all sub-division 1 - 10) through # 8. Just have no

Question

Need answer of Question # 5 (all sub-division 1 - 10) through # 8.

Just have no idea how to do it

Thanks

76 Developing Windows-Based and Web-Enabled Information Systems 5.7 Summary This chapter describes E-R modeling to define the conceptual organization of data using concepts that are natural and easy to understand. The data organization is specified using entities along with their attributes, relationships along with their attributes, and maxi- mum and minimum cardinalities of relationships, which further define how instances of entities in a relationship are associated. An E-R model may also include associative enti ties, weak entities, superclass entities, and subclass entities. The next chapter describes the transformation of an E-R model into a relational data model EXERCISES 1. Give two instances of the InsuranceCompany entity in the E-R model of the 2. Give two instances of the CareProvider entity in the E-R model of the healthcare 3. Give two instances of the Order relationship in the E-R model of the healthcare 4. Give two instances of the Visit relationship in the E-R model of the healthcare 5. A list of database application projects is available at http://www.dssbooks.com/ healthcare database in Figure 5.19. database in Figure 5.19. database in Figure 5.19. database in Figure 5.11. web/ProjectsManual.html. Project 48 describes a database application for a movie theater. 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 and e-mail), and current balance and actors, where awards won and actors are multi-valued attributes Producers with their ID, name, contact information (address, phone number, Movies with their ID, title, year of production, rating, description, awards won, Showrooms with their name, location, and capacity When a show of a movie is assigned to a showroom, the database records the date 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 records the ticket number, date, unit price, number of tickets purchased, and amount paid. The number of tickets purchased for a show decreases the total number of tickets available for the show. When a customer signs up as a member to buy tickets online, the member's login name and password are recorded. When the movie theater purchases movie(s) from a producer, the database records the transaction number, purchase price, purchase date, payment due date, and amount due The manage mation. The following is a list of data queries: r of the movie theater queries the database to obtain certain infor-

Explanation / Answer

There would be following tables :-

Customer (c_id, c_name, address, phone_no., email)

Employee (e_id,e_name, date_of_hire, salary)

Employment_history(e_id,History)

Producers ( p_id,p_name, address, phone_no,email,current_balance)

Movies(m_id,title,yop,rating,description)

movie_awards(m_id,awards_won)

movie_actors(m_id,actors)

showrooms(s_name,loc,capacity)

movie_time(m_id,s_name,loc,Date,time,total_tickets)

purcahse_tckt( t_no., date, unit, price, no_of_tckts,purcahsed,amt_paid)

c_member( login,pwd)

movie_theatre(transaction_no., purcahse_price,purchase_date,payment_duedate,amount)

5.1.a. Select (capacity- sum(tickets purchased)) as monthly_revenues, (sum( salary) + purchase_price) as monthly expenses

from showrooms,purchase_tckt, employee,movie_theatre;

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.