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, 22.06.2019 16:20
Octothorpe is another name for what common computer keyboard symbol?
Answers: 1
question
Computers and Technology, 23.06.2019 21:30
To move a file or folder in microsoft windows, you can click and hold down the left mouse button while moving your mouse pointer to the location you want the file or folder to be, which is also known as.
Answers: 3
question
Computers and Technology, 23.06.2019 22:30
The output voltage of a power supply is assumed to be normally distributed. sixteen observations are taken at random on voltage are as follows: 10.35, 9.30, 10.00, 9.96, 11.65, 12.00, 11.25, 9.58, 11.54, 9.95, 10.28, 8.37, 10.44, 9.25, 9.38, and 10.85
Answers: 1
question
Computers and Technology, 23.06.2019 23:00
Lucas put a lot of thought into the design for his company's new white paper. he made sure to include repeating design elements such as color schemes and decorative images. his goal was to a.add symmetry b.create a unified publication c.provide consistency d.save money
Answers: 1
You know the right answer?
Consider the following relational database schema for booking hotel rooms:Hotel (hotelNo , hotelName...
Questions
question
Mathematics, 26.01.2021 01:30
question
Mathematics, 26.01.2021 01:40
question
Mathematics, 26.01.2021 01:40
question
Mathematics, 26.01.2021 01:40
question
History, 26.01.2021 01:40
Questions on the website: 13722367