Question: Question 1: 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
Question 1: 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. I. Calculate the index blocking factor (bri ) ). II. Calculate the number of index entries and the number of index blocks
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
