Computers and Technology, 28.03.2021 19:10 elise47

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.

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 09:30

What are the steps involved in accepting all the changes in a document? arrange these in order click edit. click accept or reject. click changes. click accept all.

Answers: 1

Answer

Computers and Technology, 22.06.2019 23:50

List a few alternative options and input and output over the standerd keyboard and monitor. explain their functioning in details.

Answers: 2

Answer

Computers and Technology, 23.06.2019 06:30

To become an audio technician, the most successful tactics might include the following. (select all that apply). learning how to persuade other people gaining different types of experience in audio technology learning as much as possible about art history establishing a reputation as a reliable professional

Answers: 1

Answer

Computers and Technology, 24.06.2019 11:30

Why is body language an important factor in a business meeting

Answers: 1

Answer

You know the right answer?

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

Questions