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
Computers and Technology, 21.06.2019 17:30
How many pairs of chromosomes do human body cells contain?
Answers: 2
Computers and Technology, 21.06.2019 18:30
The method of presentation refers to the planning process for the presentation. the information chosen for the presentation. how the presentation topic will be introduced. how the presentation will be delivered.
Answers: 1
Computers and Technology, 24.06.2019 14:30
Ahousehold consists of a married couple and their twin five-year old daughters. the couples children had no income and lived with their parents all of last year. how many exemptions can the couple claim on last years tax return or they file with the “ married filing jointly “ status? a. 4 b. 5 c. 3 d. 2
Answers: 1
Consider a disk with block size B = 512 bytes.
A block pointer is P = 6 bytes long, A file has r =...
Mathematics, 23.03.2021 21:30
Mathematics, 23.03.2021 21:30
Mathematics, 23.03.2021 21:30
History, 23.03.2021 21:30
Mathematics, 23.03.2021 21:30
Mathematics, 23.03.2021 21:30
Physics, 23.03.2021 21:30