Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

10 pts 3- Consider a disk with block size B - 8000 bytes. A file has r - 200,000 EMPLOYEE records of fixed length and

image text in transcribed
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 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 fri and the number of index blocks How many block accesses are needed if a binary search applied to the Index ne

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Learning MySQL Get A Handle On Your Data

Authors: Seyed M M Tahaghoghi

1st Edition

0596529465, 9780596529468

More Books

Students also viewed these Databases questions

Question

=+company feels overworked; few people can imagine adding another

Answered: 1 week ago

Question

=+recurring task to their seemingly endless to-do lists.

Answered: 1 week ago

Question

=+how will you select people for the program?

Answered: 1 week ago