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.

Creating "smart interfaces" in all sectors of industry, government, and the public arena is one of the fastest growing hct areas. these interfaces model, interpret, and analyze such human characteristics as speech, gesture, and vision. the field of biometrics, in which humans authenticate themselves to machines, is an area of considerable interest to hct practitioners. fingerprint scans are one of the most frequently used biometric options, and this article, biometric student identification: practical solutions for accountability & security in schools, makes a case for the implementation of fingerprint scans in schools. critique the article, and answer the following questions: according to the author, what are the main benefits of adopting fingerprint scans in schools for student identification? according to the author, what are the main drawbacks of adopting fingerprint scans in schools for student identification? do you agree with the author's assessment of the pl