Cannot use SQL - much show expression
Tables in a relational database:
Hotel (hotelNo, hotelName, city)
Room (roomNo, hotelNo, type, price)
Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)
Guest (guestNo, guestName, guestAddress)
A) Need to generate the relational algebra expression for the following queries:
1 List all hotels
2 List all single rooms with a price below $50 per night
3 List the names and cities of all guests
4 List the price and type of all rooms at the ABC Hotel
5 List all guests currently staying at the ABC Hotel
6 List the details of all rooms at the ABC Hotel, including the name of the guest staying in the room, if the room is occupied
7 List the guest details (guestNo, guestName, and guestAddress) of all guests staying at the ABC Hotel.
B) Using Relational algebra, create a view of all rooms in the ABC Hotel, excluding price details.