The specification for a typical disk storage system is shown in Table P18.1. An employee file consisting of 100,000 records is stored on the disk. The employee External Sorting 217 record structure and the size of the fields in bytes (shown in brackets) are given below: Employee Employee Designation Address number name (6) (20) Basic pay (10) (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) Table P18.1. Specifications of a typical disk storage system Total salary (6) a) What is the storage space (in terms of bytes) needed to store the employee file in the disk? b) What is the storage space (in terms of cylinders) needed to store the employee file in the disk?

The specification for a typical disk storage system is shown in Table P18.1. An employee file consisting of 100,000 records is stored on the disk. The employee External Sorting 217 record structure and the size of the fields in bytes (shown in brackets) are given below: Employee Employee Designation Address number name (6) (20) Basic pay (10) (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) Table P18.1. Specifications of a typical disk storage system Total salary (6) a) What is the storage space (in terms of bytes) needed to store the employee file in the disk? b) What is the storage space (in terms of cylinders) needed to store the employee file in the disk?

Name: The specification for a typical disk storage system is shown in Table
Uploaded: 2024-03-20T06:51:23.000Z
Channel: Bartleby
Description: The specification for a typical disk storage system is shown in Table P18.1. Anemployee file consisting of 100,000 records is stored on the disk. The employeerecord structure and the size of the fields in bytes (shown in brackets) are givenbelow:Emp

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

Similar questions

Give Advantages of using pointers in file organization as compare to sequential file organization.
What are the advantages and disadvantages of indexed sequential file?
Low-level formatting allows drive to organize and store data in a. Data definition b. Data organization c. Data declaration d. Data modification
This article focuses on file extensions and the software that generate them. It is critical to have examples.
You have just been hired by a rental company to manage its rental car data. You are in charge of writing the program. a.) What information would you store? Give at least three fields along with their data types. b.) What kind of data structure would you use to store the records? Explain why.
File organization is the physical arrangement of records on a storage device. Explain any two of the types of file organisations discussed in class. Why will you prefer one to the other?
The file space's hierarchical structure was created at some point.
Explain the three main methods of file structure.
What are the advantages and disadvantages of indexed sequential file?
The hierarchical structure of the file space was introduced by someone or something.
What distinguishes logical from physical file descriptions?
The following record structure describes a movie file: the title of the film, the director's style, and the budget Assume that the file's primary key is the title of the film. The field type describes the genre of the film, such as drama, science fiction, horror, crime thriller, comedy, etc. Enter a sample set of records into the movie file of your choosing.i) Create a primary ISAM file organisation system based on indexes.ii) Put in place supplementary indexes for the director, type, and cost of production.iii) How may Programming Assignment 3's secondary index-based file organisation be utilised to respond to a question like "Which directors have overseen comedies or dramas that have incurred the highest production costs?