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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!