Question: Consider a disk with a block size B=1024 bytes and a block pointer P=12 bytes. Suppose, file has r=69632 EMPLOYEE records of fixed length. Each

 Consider a disk with a block size B=1024 bytes and a

Consider a disk with a block size B=1024 bytes and a block pointer P=12 bytes. Suppose, file has r=69632 EMPLOYEE records of fixed length. Each record has following attributes: - First name (60 bytes); - SSN (18 bytes); - Dnumber (18 bytes); - Home address (80 bytes); - Contact phone (20 bytes); - BDate (16 bytes); - Gender (2 byte); - Job code (8 bytes); - Salary (8 bytes); - Additional 2 bytes are used as a deletion marker. a. Assuming file is ordered by key attribute Ssn and primary index is constructed on this key attribute, calculate following. *To get full points, please, show all formulas and calculations. - Index blocking factor bbri. - 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!