Question: HOW TO DO THIS DATABASE QUESTION USING ORACLE? Hotel ( hotelNo , hotelName, hotelAddress, country) Room ( roomNo , hotelNo, type, price) Guest ( guestNo

HOW TO DO THIS DATABASE QUESTION USING ORACLE?

Hotel (hotelNo, hotelName, hotelAddress, country) Room (roomNo, hotelNo, type, price) Guest (guestNo, guestName, guestAddress, country) Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)

1. (a). What is the total income for each room type from bookings for each hotel (listing hotel names, not just hotelNo) today? Use 2019-01-21 as today's date. List in ascending order of hotel name and room type.

(b). List the new hotels that are still under construction, i.e. no room data in the Room table as yet for these hotels

(c). What is the percentage of hotels still under construction? List the total number of hotels, number of hotels completed, the number of hotels under construction, and the percentage of hotels under construction. (Note: NO SUBQUERY; use OUTER JOIN with aggregates.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Can someone help me with these questions? I am using SQL plus. This is database relations shema. Hotel (hotelNo, hotelName, hotelAddress, country) Room (roomNo, hotelNo, type, price) Guest (guestNo,...

HOW TO DO THIS DATABASE QUESTIONS USING ORACLE? Hotel (hotelNo , hotelName, hotelAddress, country) Room ( roomNo , hotelNo , type, price) Guest ( guestNo , guestName, guestAddress, country) Booking (...

Hello, I created a database in mysql workbench that includes the following tables and their attributes: hotel table, with attributes (hotelno, hotelname, city) room table, (roomno, hotelno,type,...

Question 1 (50 pts) The following relations form part of a Booking schema held in a database: Hotel hotelNo, hotelName, streetAddress, city, state) Room(roomNo, hotelNo, type, price, noOfBeds)...

Identify the three types of keys used in the relational model. Provide an example for each type of key, based on Student records at a university. ( 4 marks ) The following tables form part of a...

Chris Martin has prepared the following list of statements about managerial accounting and financial accounting. 1. Financial accounting focuses on providing information to internal users. 2....

1. Given that D= zpcos o z Clm?, calculate the charge density at (1,T/4, 3) and the total charge enclosed by the cylinder of radius 1 m with - 2

the challenges and methods involved in calculating "Consolidated Earnings per Share ( EPS ) " . How do intercompany transactions and noncontrolling interests impact the EPS calculation?

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Technology. During the past few weeks, youve received manytoo manye-mails that contain chain letters, jokes, recipes, and other nonbusiness material. An occasional message of this nature is a nice...

Teamwork. Work with one other student. Exchange the messages you wrote in Exercise 7 and read them silently, then aloud.Discuss whether and how the tone you thought you used in your message...

Global. Technology. Access the home page of two companies based in countries other than the United States and two similar companies in the United States (e.g., financial institutions, airlines). In...