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.

Reviews

Write a Review

Computer Engineering Questions & Answers

  Developing program for real estate agent in java language

Write down a java program for the real estate agent. The program must carry out the following tasks: Ask the users for average house price for the each of the past 5 years for the single family residence of 1500 square feet.

  Implementing different functions

Function celsius returns the Celsius equivalent of the Fahrenheit temperature utilizing the calculation C= 5.0/9.0 * (F-32);

  Declare three variables as integer

Log in to the Linux system as a user, and then open a Terminal emulation window.

  Assess the security risks

As part of your project in order to assess the security risks in order to compute the infrastructure, you have discovered that other managers often have several ideas on the severity and levels of the risk.

  How to support multiple incoming requests via threads

The email database server is designed to accept multiple incoming requests via a socket in order to locate a specific message and return it to the client email browser (such as Outlook Express).

  Program that continuously outputs random numbers

Write down a code in Java that continuously outputs random numbers between 0 and 10000 until a number which is divisible by 5 is encountered.

  Identifying the malicious activity in the program

State the most effective method in order to find if an attack has been made on the computer network? Specify the malicious activities does your recommendation recognize?

  Preparing the list of tables

In the last board meeting, your supervisor has asked someone to build a list of tables for the Fernandos Skate Shop customer orders.

  Hexadecimal values of dx and ax

Specify the hexadecimal values of DX and AX after the following given instructions have been executed.

  Organizational information processing theory

What is organizational information processing theory, explain its concepts and what do you meant by creating the slack resource, make the lateral relationship.

  Include the declaration in a program

Write down a declaration to store the string "This is a sample" in an array named samtest. Include the declaration in a program that displays the values in samtest in a for loop that uses a pointer to access each element in the array.

  Code to declare the four pointer variables

In C++: A pointer variable may consist of a pointer to a valid object, a pointer to a deleted object, NULL, or the random value. Write down the code which generates and sets four pointer variables a, b, c, and d to display each of these possibilit..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd