Question: Assume a situation where we have a relation FACULTY with primary key fid ( 6 bytes ) which defines the ordering of the records in
Assume a situation where we have a relation FACULTY with primary key fid bytes which defines the ordering of the records in the data file, and another nonordering key field unique PAN# bytes The record length is Bytes. We are required to store records of FACULTY relation on a disk file. The block size is Bytes. The address of any diskblock needs Bytes. Now we need to build secondary index one level only on nonordering key field unique PAN#
Now do the following.
Give how many data blocks are needed to store the records of FACULTY relation.
Give number of index blocks required in the indexing scheme done on PAN# attribute.
Give the number of block accesses needed to retrieve a record with given PAN# value from the file using the proposed secondary indexing structure.
Note: Assume unspanned record organization.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
