Question: Question 2 (9 marks, 3 marks each part) Consider the linear hash structure below. Show the new structure (including Next, Level, N) after inserting each

Question 2 (9 marks, 3 marks each part) Consider the linear hash structure below. Show the new structure (including Next, Level, N) after inserting each of the following records accumulatively in that order. Assume that adding a new overflow page will trigger splitting a bucket. 1. a record with the search key 7 (i.e., binary 111) 2. a record with the search key 2 (i.e., binary 010) 3. a record with the search key 1 (i.e., binary 001) Note that you need to show the new structure of inserting each of above records. Overflow pages Level=0,N=4 H 0000 000 0001 001 0010 0011 011 0100 100 0101 101 0110 110 010 Next=3 Primary pages 32*, 8* 9*, 25*, 1* 9* 42*, 18*, 10*, 34* 31*, 35*,7*. 11* 44*, 36* 5*, 29* 14*, 30*, 22*, 38* 43* 46* Question 2 (9 marks, 3 marks each part) Consider the linear hash structure below. Show the new structure (including Next, Level, N) after inserting each of the following records accumulatively in that order. Assume that adding a new overflow page will trigger splitting a bucket. 1. a record with the search key 7 (i.e., binary 111) 2. a record with the search key 2 (i.e., binary 010) 3. a record with the search key 1 (i.e., binary 001) Note that you need to show the new structure of inserting each of above records. Overflow pages Level=0,N=4 H 0000 000 0001 001 0010 0011 011 0100 100 0101 101 0110 110 010 Next=3 Primary pages 32*, 8* 9*, 25*, 1* 9* 42*, 18*, 10*, 34* 31*, 35*,7*. 11* 44*, 36* 5*, 29* 14*, 30*, 22*, 38* 43* 46*
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
