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

Related questions

Q: To what extent does validating input data entail?

A: Data validation is an essential part of any data handling task whether you’re in the field…

Q: 25. Kelly wants to store some data in her program that concerns iPhone replacement chip shipments.…

A: Data structure: The data structure is one of the important branches of the computer science…

Q: What is the purpose of grouping data in a file and how does it work in reality?

A: Introduction: To create grouped data, individual observations of a variable are combined into groups…

Q: The file space's hierarchical structure was created at some point.

A: Introduction: A hierarchical structure refers to the chain of command inside a company, which often…

Q: File organization, databases

A: As we have seen already, database consists of tables, views, index, procedures, functions etc. The…

Q: 9 When data is read from the database but retrieves data that is not the most current, it is called…

Q: from storage

A: In summary, while file structure and storage structure are related concepts, they represent…

Q: What are the advantages and disadvantages of each file allocation method?

A: The methods used for file allocation are essential to the way data is stored on computer systems.…

Q: Function and presentation of a file extension must be kept distinct.

A: Extensions tell your computer which application created or can open the file.

Q: transCredits string bothDone = "N" num HIGH_VALUE = 999999 InputFile master…

A: the code is an given below :

Q: (Rectangle Class) Create class Rectangle. The class has attributes length and width, each of which…

A: Refer the code below having example of how you might create a Rectangle class in C# that meets the…

Q: Explain the three main file structure approaches.

A: Introduction: When it comes to storing data on a computer, there are several approaches to file…

Q: A movie file has the following record structure: name of the movie producer director type production…

A: A movie file has the following record structure: name of the movie producer director type production…

Q: The structure of the file space's hierarchical organization is known.

A: A Hierarchical File System is a way to organize digital files on a computer using folders and…

Topic Video

Question

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
record structure and the size of the fields in bytes (shown in brackets) are given
below:
Employee Employee Designation Address Basic
number
name
pay
(6)
(10) (30)
(6)
(20)
External Sorting 217
Allowances Deductions
Number of platters
Number of cylinders
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
Table P18.1. Specifications of a typical disk storage system
Total
salary
(20) (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?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

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

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.
The file space's hierarchical structure was created at some point.
The hierarchical structure of the file space was introduced by someone or something.
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?
To what extent does validating input data entail?
Gimme Shelter Roofers maintains a file of past customers, including a customer number, name, address, date of job, and price of the job. It also maintains a file of estimates given for jobs not yet performed; this file contains a customer number, name, address, proposed date of job, and proposed price. Each file is in customer number order. Design the logic that merges the two files to produce one combined file of all customers whether past or proposed with no duplicates; when a customer who has been given an estimate is also a past customer, use the proposed data. (flowchart or pseudocode)