Consider a disk with block size B = 512 bytes. A block pointer is P = 6 bytes long, A file has r = 30,000 records

EMPLOYEE records of fixed length. Each record has the following fields:
• Name (30 bytes),
• Ssn (9 bytes),
• Department_code (9 bytes),
• Address (40 bytes),
• Phone (10 bytes),
• Birth_date (8 bytes),
• Sex (1 byte),
• Job_code (4 bytes),
• Salary (4 bytes ).

Requirements

1. Suppose that the file is ordered by the key field Ssn and we want to construct a primary index on Ssn.

Calculate ( 1 point)
a. The index blocking factor bfr
b. The number of block required to store index file
c. Number of accesses needed to search for and retrieve a record from the file using the primary index.

2. Suppose that the file is not ordered by the key field Ssn and we want to construct a secondary index on Ssn. ( 1 point)
a. Repeat the previous exercise for the secondary index and compare with the primary index.