Question: Please write answers as a relational algebra expression. Consider the following relation schemas. The primary keys are underlined. All attributes are of type string if

Please write answers as a relational algebra expression.
Consider the following relation schemas. The primary keys are underlined. All attributes are of type string if not indicated otherwise. Use multi-step and multi-line queries to ease the formulation of queries. Use the rename operator to give intermediate query results a name (some textbooks use the equivalent ' ' notation). Aggregate functions as you can find them defined in some textbooks are not allowed, neither in homework assignments nor in exams. [Note: If the location of your answer for a question is not correctly specified in Gradescope, one point will be deducted.] - Hotels(hID, name, location, phone, avgRating: integer) - Rooms(rID, hID, type, price, availability: boolean) - Bookings(bID, rID, IID,gID, startDate, endDate, totalCost: integer) - Guests(gID, name, phone, address) - Amenities(amenityID, name, description) - HotelAmenities(hID, amenityID) - HotelReviews(hID, gID, rating: integer, review) (a) [5 points] Find the names of hotels, their available room types, and prices. The hotels should be located in Orlando and should have amenities such as free breakfast and a pool (amenity name) available. (b) [5 points] Find the names of guests who have made more than one booking at HotelA (unique name). (c) [5 points] Find the names of guests who have made a booking with HotelA (unique name) but have not reviewed the hotel yet. (d) [5 points] Find the reviews and ratings of HotelA (unique name) given by either GuestA or GuestB (unique names). (e) [5 points] Find the names of hotels in Orlando with the highest average rating. Display the hotel names and ratings together. (f) [5 points] Find the names of guests who have booked every hotel in Orlando
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
