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:Employee Employeenumber name(6)(20)Designation Address(10) (30)Basicpay(6)Number of plattersNumber of cylindersAllowances Deductions(20)Number of tracks (surfaces)/cylinderNumber of sectors/trackNumber of bytes/sectorMaximum seek timeAverage seek timeMaximum Latency timeAverage latency timeTime to read/write a sector6800105051250 ms25 ms16.66 ms8.33 ms0.33 ms(20)Totalsalary(6)a) What is the storage space (in terms of bytes) needed to store the employee filein the disk?b) What is the storage space (in terms of cylinders) needed to store the employeefile in the disk?

To calculate the storage space needed to store the employee file, we need to determine the size of…

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 number name Designation Address Basic pay Allowances Deductions Total salary

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 number name Designation Address Basic pay Allowances Deductions Total salary

C++ for Engineers and Scientists

4th Edition

ISBN:9781133187844

Author:Bronson, Gary J.

Publisher:Bronson, Gary J.

Chapter8: I/o Streams And Data Files

Section8.5: A Case Study: Pollen Count File Update

Problem 4E

See similar textbooks

Similar questions

_______________ is a special purpose programming language for accessing and manipulating data stored in a relational database.
4. Movie Store System This is a system for selling and buying DVDs and videos of movies. There will be three types of users. First the regular customers, they can access the database of DVDs and videos with different types of search. Second there is a group of users that can post DVDs or/and videos to be sold. These users have access to add movies to the database, so that regular customers can search for these movies. When the customer has finished searching for a DVD and/or a video he/she can communicate a message to the seller in order to buy the product from him. The third class of user is the administrator; this user will be in charge of administrating the database and users. The administrator will be in charge of giving and revoking selling privileges to regular customers so that they are able to add videos and DVDs in the database. Use Visual Paradigm to answer the above question with following four UML diagrams: UML Diagram to be used: USE CASE (For Documentation), Class Diagram…
C++ Write a program that will allow a user to enter students into a database. The student information should include full name, student ID, GPA and status. The program should allow delete any student based on student ID.
c# Create a small Sports database with two tables: Team and Athlete. The Team table should include fields for the type of team (e.g., basketball), coach's name (both last and first), and the season the sport is most active (S for spring, F for Fall, or B for both). The Athlete table should include fields for student number, student first and last names, and type of sport. Use the same identifier for type of sport in both tables to enable the tables to be related and linked. Populate the tables with sporting teams from your school. Write a C# program that displays information about each team, including the names of the athletes. The data base we have provided to us just need to know how to program it in with the other guidelines given.
The following tables form part of a Library database held in an RDBMS: Book (ISBN, title, edition, year) BookCopy (copyNo, ISBN, available) Borrower (borrowerNo, borrowerName, borrowerAddress) BookLoan (copyNo, dateOut, dateDue, borrowerNo) where: Book contains details of book titles in the library and the ISBN is the key. BookCopy contains details of the individual copies of books in the library and copyNo is the key. ISBN is a foreign key identifying the book title. Borrower contains details of library members who can borrow books and borrowerNo is the key. BookLoan contains details of the book copies that are borrowed by library members and copyNo/dateOut forms the key. borrowerNo is a foreign key identifying the borrower. Formulate the following queries in relational algebra and tuple relational calculus: 5.27 List all copies of book titles that are available for borrowing. 5.28 List all copies of the book title “Lord of the Rings” that are available for…
The following tables form part of a Library database held in an RDBMS: Book (ISBN, title, edition, year) BookCopy (copyNo, ISBN, available) Borrower (borrowerNo, borrowerName, borrowerAddress) BookLoan (copyNo, dateOut, dateDue, borrowerNo) where: Book contains details of book titles in the library and the ISBN is the key. BookCopy contains details of the individual copies of books in the library and copyNo is the key. ISBN is a foreign key identifying the book title. Borrower contains details of library members who can borrow books and borrowerNo is the key. BookLoan contains details of the book copies that are borrowed by library members and copyNo/dateOut forms the key. borrowerNo is a foreign key identifying the borrower. Formulate the following queries in relational algebra and tuple relational calculus: a. List all book titles. b. List all borrower details. c.List all book titles published in the year 2012. d. List all copies of book titles that are…
The following tables form part of a Library database held in an RDBMS: Book (ISBN, title, edition, year) BookCopy (copyNo, ISBN, available) Borrower (borrowerNo, borrowerName, borrowerAddress) BookLoan (copyNo, dateOut, dateDue, borrowerNo) where: Book contains details of book titles in the library and the ISBN is the key. BookCopy contains details of the individual copies of books in the library and copyNo is the key. ISBN is a foreign key identifying the book title. Borrower contains details of library members who can borrow books and borrowerNo is the key. BookLoan contains details of the book copies that are borrowed by library members and copyNo/dateOut forms the key. borrowerNo is a foreign key identifying the borrower. Formulate the following queries in relational algebra only. a. How many copies of ISBN “0-321-52306-7” are there? b. How many copies of ISBN “0-321-52306-7” are currently available c. How many times has the book title with ISBN…
Student Database Management System We are making a project by means of data structure which will ensure the management of student’s record and profile. This is a simple student database management system developed in C++ by means of Data structure and Algorithms. It utilizes file handling and shows effective implementation of class and object of the programming language. This project will teach you how to add, list, modify and delete records in file.Following are the works which will be done in our project.1. Add Student Records:This feature allows you to add general information records. That includes the student’s name, course and section. All the added records in this student database management system are stored in file. (It may use different variety of nodes or a no linear data structure)2. Search Student Record:This feature allows you to search student records. All the added records in this student database management system are stored in file. (It may use…
IN java YOUR TASK IS TO IMPLEMENT A JAVA APPLICATION WHICH WILL FUNCTION AS A TYPE OF STUDENT REGISTRATION DATABASE WHICH WILL ENABLE AN ADMINISTRATIVE USER TO EITHER CREATE OR DELETE A STUDENT ACCOUNT IN THE DATABASE IN ORDER TO STORE THE FOLLOWING DETAILS:- (1)THE STUDENT’S NAME, (4) THE STUDENT’S ID NUMBER, (3) A LIST OF THE COURSES WHICH THE STUDENT HAS TAKEN ALONG WITH THE CORRESPONDING GRADES FOR THESE COURSES. NOTE: WHEN THE VALUE -1 IS ENTERED, THE APPLICATION WILL TERMINATE. please check the attached image
1. A language that provides a set of operations to support the basic data manipulation operations on the data held in the database is known as. a) DML b) DLD c)DLL d) DDL
A "composite data type" differs from a "atomic data type" in how it is defined.
In Perl language Inserting data into a flat-file database and amounts to simply tacking the new data onto the end of the file For example, inserting a new megalith record into a colon-delimited file can be expressed ?|