Reference no: EM131053909
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 (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 additional byte is used as a deletion marker. The file is stored on the disk whose parameters are given in Exercise 17.27.
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. Calculate the average time it takes to find 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 contiguously.
d. Assume that the file is ordered by Ssn; by doing a binary search, calculate the time it takes to search for a record given its Ssn value.
|
What is the total capacity of a track
: What is the total capacity of a track, and what is its useful capacity (excluding interblock gaps)?
|
|
Product as ameasure of economic performance
: What are some of the limitations using gross national product as ameasure of economic performance?
|
|
What is the flaw of argument
: A common argument in favor of minimum wage laws is that they are necessary to prevent employers from taking unfair advantage of their employees. What is the flaw of this argument? Please include a example.
|
|
What is meant by more productive a resource is more demand
: What is meant by "The more productive a resource is, the more it will be in demand." Can you provide an example?
|
|
Calculate the blocking factor bfr
: Calculate the average time it takes to find 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 contiguously.
|
|
What is the smallest number of hours
: Ying threatens not to work on the project. For Ying's threat to be credible, what is the smallest number of hours that Xavier must contribute to the project? How much time does Xavier contribute? Does Ying work on the project?
|
|
Why should entrepreneurship models include ethics
: Why should entrepreneurship models include ethics and social responsibility?
|
|
Human resource functions at a glance
: Based upon your research, prepare a case study about the human resource functions necessary for the 2016 Olympics to be held in Rio de Janeiro, Brazil.
|
|
Embark on quantitative easing in early
: For quantitative easing, why did Britain, the USA, Japan, the European Monetary Union and others embark on quantitative easing in early 2009 but not Australia?
|