Answered: For the employee file discussed in…

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

Question

For the employee file discussed in illustrative problem 18.1, making use of
Table P18.1, answer the questions given below:
Records from the employee file are to be read and, by making use of the basic
pay, allowances and deductions, the total salary is to be computed for each
employee. Assume that it takes 200 µs of CPU time to perform the computation for
a single record. The updated records are to be written onto the disk.
a) What is the time taken to process a sector of records?
b) Having processed a sector of records, what is the time taken to process all
records in the very next sector?
c) What is the time taken to process the records, in all sectors of a track,
assuming that the sectors are continuously read?
d) What is the time taken to process all records in a cylinder?

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