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 DA 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

1 Expert Approved Answer
Step: 1 Unlock

a This will produce a relation with a single attribute hotelNo giving the number of those hotels wit... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

672-CS-DB (1251).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!