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

Solve this typing please, not on paper.
Solve this typing please, not on paper. Question 1: Consider 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 (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

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!