HOW TO DO THIS DATABASE QUESTIONS 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). For all hotels in city Paris, list hotel name, hotelAddress, room type and price of all Single, Double or Family rooms with a price below 100.00 per night, in descending order of hotelName, ascending order of price and descending order of type. List each result entry only once. [Hint: city Paris is in FRANCE].

(b). For hotels in Surrey, list the bookings for which no dateTo has been specified. List the hotelName, hotelAddress, room number, dateFrom and dateTo.

(c). What is the average price of a room for each hotel? List it with the hotelName and in hotelName order.

(d). What is the average price of a room that is not Deluxe, for each hotel in each country?List it with the country and hotelName, and in country then hotelName order.