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

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

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!