Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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 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

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

Professional Microsoft SQL Server 2012 Administration

Authors: Adam Jorgensen, Steven Wort

1st Edition

1118106881, 9781118106884

More Books

Students also viewed these Databases questions