![subject](/tpl/images/cats/informatica.png)
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.
![ansver](/tpl/images/cats/User.png)
Answers: 2
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 21.06.2019 22:30
What are compression artifacts? 1) visible defects in the picture caused by the nature of the compression algorithm. 2) numbers that tell a web server how much to compress a picture for faster transmission. 3) invisible defects in the picture preserved by lossless compression. 4) numbers that tell a photo editing program how much to compress a picture for faster transmission.
Answers: 3
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 00:30
These tools give presenters more freedom to move about the room and interact with their audience. laptop computer laser pointer lcd projector remote control
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 08:00
Digital information is stored using a series of ones and zeros. computers are digital machines because they can only read information as on or off β1 or 0. this method of computation is known as the system
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 02:30
Which component acts as a platform on which application software runs
Answers: 2
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
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/fizika.png)
![question](/tpl/images/cats/istoriya.png)
History, 08.07.2021 17:00
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 08.07.2021 17:00
![question](/tpl/images/cats/mat.png)
Mathematics, 08.07.2021 17:00
![question](/tpl/images/cats/himiya.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 08.07.2021 17:00
![question](/tpl/images/cats/himiya.png)
Chemistry, 08.07.2021 17:00
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 08.07.2021 17:00
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/en.png)
English, 08.07.2021 17:00
![question](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 08.07.2021 17:00
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 08.07.2021 17:00