Answered: Employee Employee number name (6) (20)…

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

Answer the following questions for the personnel file using Table P18.1: Records from the employee file must be read, and the total compensation 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) 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?

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