Answered: A database must store an employee table…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

A database must store an employee table consisting of 100000records each of which is 80bytes
long. Answer the following questions by assuming these configurations/parameters: B = 512bytes,
interblock gap size G = 128bytes, numberof blockspertrack = 256, numberof trackspersurf ace =
400. The disk has 8 platters each with two heads (only one head can read at a time of all 16 heads),
rotates at 7200rpm, has a track − to − trackseektime(m) of 1ms, s = 12ms, r = 4.16ms, and
btt = 0.03255ms.

1. How many records can be stored per block (blocking factor) using spanned and unspanned
configurations?
2. What is the utilization (%) for the unspanned configuration?
3. If the file is physically ordered, what is the average time in milli second to read a record in
each configuration?

Can you provide detailed solution?

Expert Solution