Relational algebra tree for queries

Assignment Help Computer Engineering

Reference no: EM1316946

By utilizign the Hotel database schema:

Hotel (hotelNo, name, address)
Room (roomNo, hotelNo, type, price)
Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)

Where,

a) Hotel contains hotel details and hotelNo is the Primary Key (PK).
b) Room consists of room details for each hotel and hotelNo, roomNo, forms the PK.
c) Booking consists of details of the bookings and guestNo, HotelNo and dateFrom forms the PK.

Based upon the schema, a query for choosing the room number, room type and room price for

EDC Hotel and the room price must RM150 and above are described:
SELECT r.roomNo, r.type, r.price
FROM Room r, Booking b, Hotel h
WHERE r.roomNo = b.roomNo AND b.hotelNo = h.hotelNo and h.hotelName = ‘EDC Hotel’ AND r.price > 150;

1) Sketch a relational algebra tree (RAT) for each of queries and use the heuristic rules to convert the queries into a more efficient form. Describe each step and state any transformation rules utilized in the process.

Reference no: EM1316946

Questions Cloud

Describing the penetration test : By using the MS Word, write down the three-page summary explaining a successful penetration test. Which penetration tools and techniques do you think would be required in the successful penetration test.

Prepare the molecular formula for given compounds : Prepare the molecular formula for given compounds and determine the amount of molecules present and write the molecular formula and determine how many grams of each you have

Creating confidence interval for mean score of exam : Create a 90% confidence interval for mean score on this placement exam for all students.

Optimum level of consumption and budget allocation : Optimal consumption. The following Table describes the demand for tickets to the opera, during the two=-week season.

Relational algebra tree for queries : Sketch a relational algebra tree (RAT) for each of queries and use the heuristic rules to convert the queries into a more efficient form. Describe each step and state any transformation rules utilized in the process.

Depends on the satellite informationwhat is the expected no : Depends on the satellite information illustrate what is the expected number µ of real forest fires on the Seward Peninsula.

Calculating the margin of error : Constructing a 95% confidence interval for the true length of time for all pepper seeds to germinate you must calculate the margin of error. The margin of error in this case is 0.60.

Value of the chi-square statistic and test : Calculate the value of the chi-square statistic and test whether all regions are statistically the same at 5% and 1% level tests.

Evaluate the molecular weight of the reactants : Write balanced chemical equation and evaluate the molecular weight of the reactants and Calculate the molecular weights of the reactant.

User Account

All Pages