Answered: Using Table P18.1, answer the following…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Using Table P18.1, answer the following questions about the personnel file presented in illustrative issue 18.1:
Records from the employee file must be read, and the total salary for each employee must be estimated using the basic pay, allowances, and deductions. Assume that the processing for a single record takes 200 s of CPU time. The revised records must be written to disc.
a) How long does it take to process a sector of records?
b) After processing one sector of records, how long does it take to process all records in the following sector?
c) What is the time taken to process the records, in all sectors of a track,
assuming that the sectors are continuously read?

Employee Employee
number
name
(6)
(20)
Designation Address
Basic
pay
(6)
(10)
(30)
Number of platters
Number of cylinders
Allowances Deductions
Number of tracks (surfaces)/cylinder
Number of sectors/track
Number of bytes/sector
Maximum seek time
Average seek time
Maximum Latency time
Average latency time
Time to read/write a sector
(20)
6
800
10
50
512
50 ms
25 ms
16.66 ms
8.33 ms
0.33 ms
(20)
Table P18.1. Specifications of a typical disk storage system
Total
salary
(6)

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions