Questiona file has r 20000 student records of permanent

Assignment Help Computer Engineering

Reference no: EM13348425

Question

A file has r = 20,000 STUDENT records of permanent length. Each record has following fields-

Name (30 bytes), Ssn (9 bytes), Address (40 bytes), PHONE (10 bytes), Birth_date (8 bytes), Sex (1 byte), Major_dept_code (4 bytes), Minor_dept_code (4 bytes), Class_code (4 bytes, integer), and Degree_program (3 bytes).An extra byte is used as a removal marker. The file is stored on disk whose parameters are given -

a. Calculate record size R in bytes.

b. Calculate blocking factor bfr and the number of file blocks b, assume an unspanned organization.

c. Calculate average time it takes to discover a record by doing a linear search on the file if

(i) the file blocks are stored contiguously, and double buffering is used;

(ii) the file blocks are not stored closely.

d. Assume that the file is ordered by Ssn; by doing a binary search, compute the time it takes to search for a proof given its Ssn value.

Reference no: EM13348425

Questions Cloud

Question 1a i describe briefly a good handling technique : question 1a i describe briefly a good handling technique that can be adopted by a person who is required to lift a load

Question1 what are three goals of safety in computing for : question1. what are three goals of safety in computing? for each goal list two controls that be able to be implemented

Questionthe averaging algorithm proposed by lamport et al : questionthe averaging algorithm proposed by lamport et al. works for a totally connected network of clocks. will such

Questiontroubleshooting dns records-you have been hired to : questiontroubleshooting dns records-you have been hired to decide cause of e-mail and web site outages at a local

Questiona file has r 20000 student records of permanent : questiona file has r 20000 student records of permanent length. each record has following fields-name 30 bytes ssn 9

Questionfor this module you will require to complete : questionfor this module you will require to complete following tasks. this section will be additional to the end of

Questionwrite down a program which asks user to respond to : questionwrite down a program which asks user to respond to a question by entering either 1 for yes or 2 for no. use a

Questionfor each of following schedules state and : questionfor each of following schedules state and illustrate precedence graph whether schedule is serializable or

Question 1you are a newly recruited safety officer in a : question 1you are a newly recruited safety officer in a medium sized company involved in the manufacturing of

User Account

All Pages