Describe the relations that would be produced by the following relational algebra operations: (a) ΠhotelNo(σprice > 50(Room)) (b) σHotel.hotelNo = Room.hotelNo(Hotel × Room) (c) ΠhotelName(Hotel 1...

Describe the relations that would be produced by the following relational algebra operations:

(a) ΠhotelNo(σprice > 50(Room))

(b) σHotel.hotelNo = Room.hotelNo(Hotel × Room)

(c) ΠhotelName(Hotel 1 Hotel.hotelNo = Room.hotelNo(σprice > 50(Room)))

(d) Guest 5 (σdateTo ≥ ‘1-Jan-2002’(Booking))

(e) Hotel 2 Hotel.hotelNo = Room.hotelNo(σprice > 50(Room))

(f) ΠguestName, hotelNo(Booking 1 Booking.guestNo = Guest.guestNo Guest) ÷ ΠhotelNo(σcity = ‘London’(Hotel))