Answered: Records from the employee file are to…

Name: Records from the employee file are to be read and, by making use of th
Uploaded: 2024-03-20T06:51:23.000Z
Channel: Bartleby
Description: 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

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

Topic Video

Question

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 all records in a cylinder?

Illustrative problem (a) computed the time taken to process all records of the employee file residing in a cylinder. Assume that the time taken for the read/write head to move from one cylinder to another is 10 ms.
b) What is the time taken to process all records in the next cylinder?
c) What is the time taken to process the entire employee file of records on the disk?

Employee Employee Designation Address
number
name
(6)
(20)
(10)
Basic
pay
(30) (6)
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)
Total
salary
(6)

Expert Solution

Step by step

Solved in 3 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