Question: Instead of the B - tree leaves having pointers to data records, the B - tree leaves hold the records themselves. A block can hold

Instead of the B-tree leaves having pointers to data records, the B-tree
leaves hold the records themselves. A block can hold ten records, but
on average, a leaf block is 70% full; i.e., there are seven records per leaf
block.
e) The data file is a sequential file, and the B-tree is a sparse index, but each
primary block of the data file has one overflow block. On average, the
primary block is full, and the overflow block is half full. However, records
are in no particular order within a primary block and its overflow block.

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!