Question: Consider a disk with a block size B = 512 bytes and a block pointer P = 6 bytes. Suppose file has r = 34816

 Consider a disk with a block size B = 512 bytesand a block pointer P = 6 bytes. Suppose file has r= 34816 EMPLOYEE records of fixed length. Each record has following attributes:

Consider a disk with a block size B = 512 bytes and a block pointer P = 6 bytes. Suppose file has r = 34816 EMPLOYEE records of fixed length. Each record has following attributes: Name (30 bytes); Ssn (9 bytes); Department_code (9 bytes); Address (40 bytes); Phone (10 bytes); Birth_date (8 bytes); Gender (1 byte); Job_code (4 bytes); Salary (4 bytes); Additional byte is used as a deletion marker. . a. Assuming an unspanned organization, calculate: Record size R (in bytes). - Blocking factor bfr. - Number of file blocks b. b. Suppose file is ordered by key attribute Ssn and primary index is constructed on this key attribute. Calculate: - Index blocking factor bfri. - Total number of indexes ri and number of index blocks bi. - Total number of accesses needed to search for a record using primary index

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!