Need help? We are here

# List the names and addresses of all guests in Kuala Lumpur

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

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

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

iii.
Π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
SHAPE  * MERGEFORMAT

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

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

i.
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

Pages (275 words)
Standard price: \$0.00

### Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

### 175- to 260-word reflection of your experience in the BSHM

175- to 260-word reflection of your experience in the BSHM program in which you: Consider all of the courses and content you have learned

### write a 1-2 page memo (not including references page) to

write a 1-2 page memo (not including references page) to the CIO that identifies more than seven success criteria for implementation of enterprise systems, for

### Everyone uses computer nowdays. Have you ever been directly or

Everyone uses computer nowdays. Have you ever been directly or indirectly affected by malwares (virus, worm, adware, spyware,phishing,Trojan, etc)?  please share your experience with us; 1 page

### CHANGE MANAGEMENT DELIVERS FOR AUSTRALIAN SOCIAL SERVICES In 1997, the newly

CHANGE MANAGEMENT DELIVERS FOR AUSTRALIAN SOCIAL SERVICES In 1997, the newly elected conservative Australian government moved to overhaul its country’s social welfare services. At the

### As you have learned through your course readings and classroom

As you have learned through your course readings and classroom discussion, logic models may be used as a valuable tool in both the planning and

### https://www.youtube.com/watch?v=Fj3p6hrOcE4&feature=youtu.be As a result, the burden of birth control rests

https://www.youtube.com/watch?v=Fj3p6hrOcE4&feature=youtu.be As a result, the burden of birth control rests primarily on the woman’s shoulders.  Despite the increased cost and risk, six times more women

### Week 7 Please respond to the following: What incentives influence

Week 7  Please respond to the following: What incentives influence firms to use international strategies? What are the three basic benefits firms can gain by

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

### Module 06 Content For the final submission of your course

For the final submission of your course project you will complete both your Risk Register and submit the Risk Monitoring Plan that you have been developing throughout the course.

### 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.

### Quz help CHAPTER 26—THE CONSERVATIVE TURN 1969-1988 1. What was

Quz help CHAPTER 26—THE CONSERVATIVE TURN 1969-19881. What was Barry Goldwater’s conservative philosophy? Which Republican President used this plan and won the White House? Pp.1032-1033

### Answer the questions below Introduction to the topic A description

Answer the questions below    Introduction to the topic A description of the issues related to your topic How the issues have caused harm Instructions

New questions