Question: 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
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))
DA
Step by Step Solution
3.42 Rating (165 Votes )
There are 3 Steps involved in it
a This will produce a relation with a single attribute hotelNo giving the number of those hotels wit... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
672-CS-DB (1251).docx
120 KBs Word File
