Question
Consider the following configuration: A disk with block size (B) = 512 bytes, A block pointer (P) = 8 bytes long, An EMPLOYEE file has
Consider the following configuration:
A disk with block size (B) = 512 bytes,
A block pointer (P) = 8 bytes long,
An EMPLOYEE file has the following fields:
NAME (30 bytes), SSN (9 bytes), DEPARTMENTCODE (9 bytes), ADDRESS (40 bytes), PHONE (9 bytes), BIRTHDATE (8 bytes), SEX (1 byte),
JOBCODE (4 bytes), SALARY (4 bytes, real)
The EMPLOYEE file has r=20000 EMPLOYEE records and there is an additional byte used as a deletion marker.
Suppose the file is ordered by the unique key field SSN and we want to construct an index on SSN.
1.. Calculate the index blocking factor (bfri ).
2.Calculate the number of index entries and the number of index blocks.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started