Question: Solve this typing please, not on paper. Question 1: Consider the following configuration: A disk with block size (B)=512 bytes, A block pointer (P)=8 bytes
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 (bfri). 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
