Compute the record size r in bytes

Assignment Help Computer Engineering

Reference no: EM1336404

A file has r=20,000 STUDENT records of fixed-length. Each record has the following fields: NAME (30 bytes), SSN (9 bytes), ADDRESS (40 bytes), PHONE (9 bytes), BIRTHDATE (8 bytes), SEX (1 byte), MAJORDEPTCODE (4 bytes), MINORDEPTCODE (4 bytes), CLASSCODE (4 bytes, integer), and DEGREEPROGRAM (3 bytes). An additional byte is used as a deletion marker.

(a) Calculate the record size R in bytes.
(b) Calculate the blocking factor bfr and the number of file blocks b assuming an
unspanned organization.
(c) Assume the file is ordered by SSN; calculate the number of blocks it takes to search for a record given its SSN value by doing a binary search.

Reference no: EM1336404

Questions Cloud

Explain would you recruit and hire a person : Explain would you recruit and hire a person who was a brilliant and high-performing individualist and loner or an average performer who works well with others?

Explain marketing - scales and secondary data and demand : Explain Marketing - Scales and Secondary Data and Demand and How do market researchers utilize scales to establish quantifiable measures of subjective and abstract concepts

Pm for a process or product improvement activity : Imagine that you have been selected as the PM for a process or product improvement activity or the design of a new product or service in your organization.

Statute of limitations : Ellen Ellerby, a paralegal with Frankline & Gainsborough, works closely with another paralegal, Harry Henderson. IN the last few months.

Compute the record size r in bytes : suppose the file is ordered by SSN; calculate the number of blocks it takes to search for a record given its SSN value by doing a binary search.

Calculate the economic order quantity : If = 8,000 per month, = $45 per order, and = $2 per unit per month, Calculate the economic order quantity.

How various bits fit in the cable : A 100-km-long cable runs at the T1 data rate. The propagation speed in the cable is 2/3 the speed of light in vacuum. How various bits fit in the cable.

How can the company prevent crisis : How can the company prevent this type of crisis from happening in the future?

A paralegal case study questions : Evan Eldridge is a paralegal working for Matilda Moniker, who handles lots of small lawsuits that often go to trial. Matilda asks Evan to contact opposing counsel in six cases.

User Account

All Pages