For the following relational Hotel schema:
Hotel (hotelNo, hotelName, city)
Room (roomNo, hotelNo, type, price)
Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)
Guest (guestNo, guestName, guestAddress)
Produce an Object-Oriented schema for the system.
Suggest a number of methods that maybe applicable to the system.
Map the Object-Oriented database designed for part 2 to ODL.
Show how the following queries would be written in OQL:
a. List all hotels.
b. List all single rooms with the price below 20$ per night.
c. List all names and cities of all guests.
d. List the price and type of all rooms at the Grosvenor Hotel.
e. List all guests currently staying at Grosvenor Hotel.
f. List the deyails of all rooms at the Grosvenor Hotel, including the name of the guest staying in the room, if the room is occupied.
g. List the guest details guestNo, guestName, and guestAddress of all guests staying at the Grosvenor Hotel.