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

a) IIhotelNo sprice > 50 (Room) )

b) s Hotel.hotelNo = Room.hotelNo(Hotel x Room)

c) IIhotel Name (Hotel  Hotel.hotelNo = Room.hotelNo s price > 50 (Room))) 

d) Guest  (s dateTo ≥ ‘1-Jan-2007’ (Booking)) 

e) Hotel Hotel.hotel No = Room.hotelNo ((sprice > 50 (Room)))

f) IIguestName, hotel No (Booking Booking.guest No = Guest.guest No Guest) ÷ IIhotelNo (s city = London (Hotel))

Transcribed Image Text:

DA