Expert answer:4.[4 points]The following tables form part of a database held in a relational DBMS:-Hotel (hotelNo, hotelName, city)Room (roomNo, hotelNo, type, price)Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)Guest (guestNo, guestName, guestAddress)whereHotel contains hotel details and hotelNo is the primary key;Room contains room details for each hotel and (roomNo, hotelNo) forms the primary key;Booking contains details of the bookings and (hotelNo, guestNo, dateFrom) forms the primary key;andGuest contains guest details and guestNo is the primary key.Compose an SQL that lists the rooms that are currently unoccupied at the Grosvenor Hotel._____________________________________________________________________________________5.[4 points]The following tables form part of a database held in a relational DBMS:-Hotel (hotelNo, hotelName, city)Room (roomNo, hotelNo, type, price)Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)Guest (guestNo, guestName, guestAddress)whereHotel contains hotel details and hotelNo is the primary key;Room contains room details for each hotel and (roomNo, hotelNo) forms the primary key;Booking contains details of the bookings and (hotelNo, guestNo, dateFrom) forms the primary key;andGuest contains guest details and guestNo is the primary key.Compose an SQL that creates a view containing the hotel name and the names of the guests staying at the hotel.
