List the names and addresses of all guests in Kuala Lumpur

Based on the schema above, describe the relations that would be produced by the following relational algebra operations:


ΠhotelNo (σprice > 50 (Room) )                                                       [2 Marks]

σHotel.hotelNo = Room.hotelNo(Hotel × Room)                                     [2 Marks]

ΠhotelName (Hotel ⊳⊲ Hotel.hotelNo = Room.hotelNo (σprice > 50 (Room)) ) [3 Marks] iv. ΠuestName, hotelNo (Booking ⊳⊲ Booking.guestNo = Guest.guestNo Guest) ÷ 

ΠhotelNo (σcity = ’London’(Hotel))                          [3 Marks] v.     Guest ⊐⊲ (σdateTo ‘1-Jan-2002’ (Booking))                                    [2 Marks]

                  vi.      Hotel

 Hotel.hotelNo = Room.hotelNo (σprice > 50 (Room)) )                   [3 Marks]


Write a relation algebra operation that would the answer for each of the following:  


List the names and addresses of all guests in Kuala Lumpur, alphabetically

ordered by name.                                                                      [3 Marks] ii.     List the bookings for which no dateTo has been specified.        [3 Marks] iii.    List the number of rooms in each hotel in London.                  [3 Marks] iv.    List the price and type of all rooms at the Ero Hotel.  [3 Marks] v.        Produce the number of guest made bookings for August.        [4 Marks] vi.     List all guests currently staying at the Grosvenor Hotel.       [4 Marks]


Click here to request for this assignment help

#List #names #addresses #guests #Kuala #Lumpur

Table of Contents

Calculate your order
Pages (275 words)
Standard price: $0.00

Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

cognitive psychology – Premium Paper Help

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along

Analyze health risks uncovered

Final Project Part II will involve the construction of a proposal for a health promotion teaching tool that will be of value for the patient.

New questions

Don't Let Questions or Concerns Hold You Back - Make a Free Inquiry Now!