1. Engineering
  2. Computer Science
  3. how to do this database question using oracle hotel hotelno...

Question: how to do this database question using oracle hotel hotelno...

Question details

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).List all guests currently staying at the Grosvenor Hotel. Include the roomNo in the output. Use 2019-01-21 as the current date.

           (b) What is the total income from bookings for the Grosvenor Hotel today? Do this question for each of the hotels with 'Grosvenor' in name. Use 2019-01-21 as the current date.

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution