Computers and Technology

Consider the following relational database schema for booking hotel rooms: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 bookings and ( HotelNo, GuestNo, dateFrom) forms the primary key;Guest contains guest details and guestNo is the primary key. Generate the relational algebra for the following queries:1. List all hotels2. List all single rooms with a price below $20 per night3. List the names and cities of all guests4. List the price and type of all rooms at the Grosvenor Hotel5. List all guests currently staying at Grosvenor Hotel.6. List the names of the guests currently having a booking.7. List the details of all rooms at the Grosvenor Hotel, including the name of the guest staying in the room, if the room is occupied.8. List the guest details (guestNo, guestName, and guestAddress) of all guests staying at the Grosvenor Hotel.

answer
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 04:30, Lilabbychichi
Ryan is working on the layout of her web page. she needs to figure out where her header, navigation bar, text, and images should go. what technique can her?
Answers: 1
image
Computers and Technology, 23.06.2019 17:00, evanwall91
What does the faves button do? a. users mark a web page as a favorite b. leads other readers to favor a specific page c. readers sort and align their favicons, or favorite icons d. leads users to a message board where they can post questions
Answers: 1
image
Computers and Technology, 24.06.2019 16:50, genyjoannerubiera
Ramp charts are generally created in wordlotusexcelpowerpoint
Answers: 1
image
Computers and Technology, 24.06.2019 22:10, mikaylaaaaa
How many different ways are there to order the eight jobs in the queue so that job usu comes somewhere before cdp in the queue (although not necessarily immediately before) and cdp comes somewhere before bbd (again, not necessarily immediately before)?
Answers: 1
Do you know the correct answer?
Consider the following relational database schema for booking hotel rooms:Hotel (hotelNo , hotelName...

Questions in other subjects:

Konu
Mathematics, 25.05.2021 19:30