Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Computer Engineering Expert

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.

 

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M9718042

Have any Question?


Related Questions in Computer Engineering

Question suppose that you are working with gps data from an

Question : Suppose that you are working with GPS data from an Excel spreadsheet and that you map it in ArcMap. However, you are surprised that the data points are in Australia instead of Chile? What could be the possible ...

A substring is a contiguous sequence of characters from a

A substring is a contiguous sequence of characters from a string. For example, "cde" is a substring of the string "abcdefg". We say that substring s1 is duplicated in string s if s1 shows us in s at least two times, with ...

Number of cars average trvel time between a and b using

Number of cars Average trvel time between A and B using route 1 1 10 2 10 3 10 4 11 5 12 6 14 7 18 8 24 Alternative route 2: average travel time is 18 minutes(no matter how many cars are using it) How many cars will take ...

Question explain the need for designing procedures for

Question: Explain the need for designing procedures for simple tasks such as creating or modifying access controls. Create a procedure guide that provides clear instructions that anyone with a basic technical knowledge b ...

What is an example of a repetitive and specific task in

What is an example of a repetitive and specific task in which you use descriptive statistics on a daily basis. What is an example of how you consciously or subconsciously rely on the presence of descriptive statistics in ...

Requirementsnew payroll functionality to allow global

Requirements New payroll functionality to allow global employee to submit banking information to get paid electronically (i.e. direct deposit paycheck to bank account). Initial pilot has 3 countries in Asia Pacific, Euro ...

You are running a small manufacturing shop with plenty of

You are running a small manufacturing shop with plenty of workers but with a single milling machine. You have to produce n items; item i requires m i machining time first and then p i polishing time by hand. The machine ...

Would you help me by giving me some helpful tips about how

Would you help me by giving me some helpful tips about how to study basic C programming in days?

Question 1 assume that you are the project manager for an

Question: 1) Assume that you are the project manager for an upcoming new information systems project designed to replace your organization's old inventory management system. The server and database will also be upgraded. ...

1 what is a domain name in the context of internet what

1. What is a domain name in the context of Internet? What is the procedure to get a domain name and link it to an Internet Protocol (IP) address? Use an example.

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As