63 209
Assignments Done
99,3%
Successfully Done
In July 2018

Answer to Question #13965 in Databases | SQL | Oracle | MS Access for Sajidah

Question #13965
3. Assume the following indexes exist:
• A hash index with no overflow on the primary key attributes, roomNo/hotelNo in Room;
• A clustering index on the foreign key attribute hotelNo in Room;
• A B+-tree index on the price attribute in Room;
• A secondary index on the attribute type in room

 nTuples (Room) = 10,000 bFactor(Room) = 200
 ntuples(Hotel) = 50 bFactor9Hotel) = 40
 nTuples(Booking) = 100,000 bFactor(Booking) = 60
 nDistincthotelNo(Room) = 50
 nDistinctType(Room) =10
 nDistinctprice(Room) = 500
 minprice (Room) = 200 maxprice(Room) = 50
 nLevelshotelNo(I) = 2
 nLevelsprice(I) = 2 nLFBlocksprice(I) = 50
Calculate the cardinality and minimum cost for each of the following selection operations
S1:  roomNo = 1  hotelNo =’H001’(Room)
S2: type’D’ (Room)
S3: hotelNo’H002’(Room)
S4: price > 100 (Room)
S5: type’S’  hotelNo = ‘H003’(Room)
S6: type’S’ price < 100 (Room)


Expert's answer
Unfortunately, your question requires a lot of work and cannot be done for free.
Submit it with all requirements as an assignment to our control panel and we&#039;ll assist you.

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions