Question: Consider the following relation with 1 5 0 , 0 0 0 tuples, stored in 3 , 0 0 0 pages: STUDENTS ( SID ,

Consider the following relation with 150,000 tuples, stored in 3,000 pages:
STUDENTS(SID, Name, DeptID, Email, GPA)
Each of the five attributes requires the same amount of storage space. An alternative-2
unclustered tree index with fanout F is created for the search key DeptID.
a) What is the number of disk I/Os required to retrieve the 300 students in
Department 4710?
b) What is the 10 cost if a clustered hash index is used?
 Consider the following relation with 150,000 tuples, stored in 3,000 pages:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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

Students Have Also Explored These Related Databases Questions!