in Databases
508 views
0 votes
0 votes
Consider a B+ -tree in which the maximum no. of keys in a root is 11. What will be minimum no. of keys in a non-root node? What will be the same in a B-Tree

Please also refer the source from where clear-cut formulae are given
in Databases
508 views

1 Answer

3 votes
3 votes

Number of Keys Present in Internal Nodes of Both B and B+ Trees are govern by the Formula

[ Ceil( p/2 ) - 1 to p-1 ] , where p is the Order of the Tree.

And For the root the formula is :[1, p-1]

Solution of the Question: Given that p-1 =11 , so p=12.

Hence the Order of  the B+ tree is 12

Applying the Formula :  [ Ceil( 12/2 ) - 1 to 12-1 ] , answer turn out to be: [5,11]

So the Minimum number of keys Present will be 5