Question: Please help with the relational algebra for my database class Model: For this lab, you'll be using the following relational model to answer queries using

Please help with the relational algebra for my database class

Please help with the relational algebra for my database class Model: For

Model: For this lab, you'll be using the following relational model to answer queries using relational algebra: Hotel(hID, Name, city) primary key is hID Guest(gID, gName, gAddress) primary key is gID Room(hid, rNumber, price) primary key is (hID, rNumber). hID is a foreign key to Hotel relation Book(gID, hID, rNumber, StartDate, EndDate) primary key is all attributes! (hID, rNumber) is a foreign key to Room relation gID is a foreign key to Guest relation. Queries: 1. Select hotels with at least 1 room with price > $1000. 2. Select hotels with at least 2 rooms with price > $1000. 3. Select hotel names with at least 2 rooms with price > $1000. 4. Select cities that have at least 2 hotels. 5. Select guests who have reserved a room with price > $1000 (VIPs). 6. Select guests who booked rooms in the same hotel during Dale Cooper's stay at the Great Northern Hotel between February 24, 1989 and March 26, 1989. 7. Select guests who stayed at least 1 day in New York City hotels between September 8, 2001, and September 11, 2001. 8. Select guests who have never booked a room in the same hotels that John Doe has. 9. Select the hotel that has the cheapest room. 10. Select the hotel that has the second cheapest room. 11. Select guests who have booked a room in every hotel. 12. Select guests who have booked a room in every hotel in Las Vegas. For submitting, you have your choice: Type the queries in Word/Docs and export/upload a PDF Write them out by hand, take a photo, and upload a PNG or JPG

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!