Hotel(hID, hName, city) primary key is hIDGuest(gID, gName, gAddress) primary key is gIDRoom(hID, rNumber, price) primary key is (hID, rNumber). hID is a foreign key to Hotel relationBook(gID, hID,...

Hotel(hID, hName, 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. Write in relational algebra the following queries: Select guests who stayed at least 1 day in New York City hotels between September 8, 2001, and September 11, 2001. Select guests who have never booked a room in the same hotels that John Doe has. Select guests who have booked a room in every hotel in Las Vegas.