subject

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.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 11:30
The most accurate readings that you can take on an analog vom are when the meter's pointer is at the a. center scale. b. extreme right. c. near right. d. extreme left.
Answers: 1
question
Computers and Technology, 23.06.2019 20:40
Instruction active describing list features which statements accurately describe the features of word that are used to create lists? check all that apply. the tab key can be used to create a sublist. the enter key can be used to add an item to a list. the numbering feature allows for the use of letters in a list. the numbering feature can change the numbers to bullets in a list. the multilevel list feature provides options for different levels in a list.
Answers: 2
question
Computers and Technology, 24.06.2019 15:30
What type of forensic evidence was recovered during the bomb set off at the new mexico facility on the video that was similar to the evidence obtained at the boston bombings and how did the evidence allow the researchers to connect other pieces of evidence to the same bomb?
Answers: 2
question
Computers and Technology, 24.06.2019 16:00
This isn't about school but every time it tells me to watch an ad to unlock the answer to a question it prompts a survey and it just keeps loading. so i haven't been able to get answers for my tests in like a week.
Answers: 2
You know the right answer?
Consider the following relational database schema for booking hotel rooms:Hotel (hotelNo , hotelName...
Questions
question
Mathematics, 16.04.2021 03:00
question
Mathematics, 16.04.2021 03:00
question
Mathematics, 16.04.2021 03:00
Questions on the website: 13722361