Question: . Consider a disk with block size B - 5 1 2 bytes. A block pointer is P - 6 bytes long and a recordPor

. Consider a disk with block size B-512 bytes. A block pointer is P-6 bytes long and a recordPor PR-T bytes long. A file has r=30,000 EMPLOYEE records of fixed-length. Each record has the following fields: NAME (30 bytes), SSN (bytes), DEPARTMENTCODE (9 bytes),ADDRESS (40 bytes). PHONE (9 bytes) BIRTHDATE (8 bytes), SEX (1 byte), JOBCODE (4 bytes, SALARY (4 bytes, real number). An additional byte is used as a deletion marker.1) Calculate the record size R in bytes,(1) Calculate the blocking factor bir and the number of file blocks b assuming an unspanned

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!