Question: 3. Consider a disk with block size B = 8000 bytes. A file has r = 200,000 EMPLOYEE records of fixed length and are unspanned.

3. Consider a disk with block size B = 8000 bytes. A file has r = 200,000 EMPLOYEE records of fixed length and are unspanned. Each records' length is 200 bytes. (a) Calculate the blocking factor bfr and the number of file blocks b needed for the file. How many block accesses are needed if a binary search applied to the data file? (b) Suppose that the file is ordered by the key field SSN and we want to construct a primary index on SSN. The SSN key field is 4 bytes long and a block pointer is P = 6 bytes long. Calculate the index blocking factor bfri and the number of index blocks How many block accesses are needed if a binary search applied to the index file

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

10 pts 3- Consider a disk with block size B - 8000 bytes. A file has r - 200,000 EMPLOYEE records of fixed length and are unspanned. Each records' length is 200 bytes. ta) Calculate the blocking...

3- Consider a disk with block size B - 8000 bytes. A file has r= 200,000 EMPLOYEE records of fixed length and are unspanned. Each records' length is 200 bytes (al Calculate the blocking factor bfr...

3. Consider a disk with block size B 1024 bytes. A block pointer is P 6 bytes long. A file has r 60,000 EMPLOYEE records of fixed length. Each record has the following fields: Name(30 bytes), Ssn(9...

Database course Only part b please. 3. (Storage and Indexing) Consider a disk with block size B = 512 bytes, where a block pointer is 8 bytes long. A file has r= 90,000 EMPLOYEE records of fixed...

Database course 3. (Storage and Indexing) Consider a disk with block size B 512 bytes, where a block pointer is 8 bytes long. A file has r= 90,000 EMPLOYEE records of fixed length. Each record has...

Consider a disk with block size B = 512 bytes. A block pointer is P = 6 bytes long, and a record pointer is PR = 7 bytes long. A file has r = 80,000 EMPLOYEE records of fixed length. Each record has...

Department of Computer Science 1411365 DB Design and Implementation Exercise 3: Solve Exercise 18.18 (a, b and c) from the textbook. Exercises 18.18. Consider a disk with block size B = 512 bytes. A...

Consider a disk with block size B = 512 bytes. A block pointer is P = 6 bytes long, and a record pointer is PR = 7 bytes long. A le has r = 30000 EMPLOYEE records of xed-length. Each record has the...

Consider a disk with block size B = 5 1 2 bytes, a block pointer P = 6 bytes, and a record pointer PR = 7 bytes. A file contains 3 0 , 0 0 0 EMPLOYEE records, with the following fields: Name ( 3 0...

An economist has predicted that there will be a 7% per year inflation of prices during the next 10 years. If this proves to be correct, how much will an item that presently sells for $10 bring a...

Duke Corporation owns a 70 percent equity interest in UNCCH, a subsidiary corporation. During the current year, a portion of this stock is sold to an outside party. Before recording this transaction,...

Fiona and her daughter ( age 2 ) lived with Fionas grandmother during the year. Fiona is 2 3 years old and is a full - time student. Fiona worked part - time and earned $ 9 , 4 5 0 . Fionas...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...

What benefits are you looking to gain?

How do they look and behave?

How do you feel when they are talking with you?