A file has 40,000 Student records of fixed-length. Consider a disk with block size B=512 bytes....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A file has 40,000 Student records of fixed-length. Consider a disk with block size B=512 bytes. A block pointer is 8 bytes long and a record pointer is 7 bytes long. Each record has the following fields: Attributes StudentID Size (in bytes) 9 Name Sex Course Major Phone Address 30 1 10 9 30 8 3 DoB Status a. Calculate the record size R in bytes. b. Calculate the blocking factor bft and the number of files blocks b assuming an unspanned organization. c. Suppose the file is ordered by the key field StudentID and we want to construct a primary index on it. Calculate the index blocking factor bft_i. A file has 40,000 Student records of fixed-length. Consider a disk with block size B=512 bytes. A block pointer is 8 bytes long and a record pointer is 7 bytes long. Each record has the following fields: Attributes StudentID Size (in bytes) 9 Name Sex Course Major Phone Address 30 1 10 9 30 8 3 DoB Status a. Calculate the record size R in bytes. b. Calculate the blocking factor bft and the number of files blocks b assuming an unspanned organization. c. Suppose the file is ordered by the key field StudentID and we want to construct a primary index on it. Calculate the index blocking factor bft_i.
Expert Answer:
Related Book For
Fundamentals of Database Systems
ISBN: 978-0136086208
6th edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date:
Students also viewed these programming questions
-
What is the role of the Golgi complex within the cell cytoplasm?
-
The Torrid Zone on Earth is the area between the Tropic of Cancer and the Tropic of Capricorn, as shown. The distance between these two tropics is about 3250 miles. You can think of this distance as...
-
What is SAV? What are some economic forces that can help explain SAV? What are some demographic and other considerations? How might physician uncertainty lead to SAV?
-
Which kind of plan-tactical or operational-should be developed first? Why? Does the order really matter? Why or why not?
-
Does someone with authority always have power? Does a person who accepts responsibility necessarily have authority? Explain.
-
If a well-behaved investment alternative's internal rate of return (IRR) is equal to MARR, which of the following statements about the other measures of worth for this alternative must be true? 1....
-
"The following information is available for Remmers Corporation for 2010. 1. Depreciation reported on the tax return exceeded depreciation reported on the income statement by" $120,000. This...
-
What are some similarities and differences between the Microsoft SQL Server, Oracle Database, Amazon Aurora, IBM Db2, and MySQL relational database vendors?
-
Several AI winters, or rapid collapses in levels of economic and academic activity (and media interest) associated with AI, have occurred. Describe the causes of each collapse and of the boom in...
-
Salary Ron's paycheck this week was $17.43 less than his paycheck last week. His paycheck this week was $103.76. How much was Ron's paycheck last week?
-
Problem 1 / 1 / MatlabGrader Develop a Matlab function mySquares that calculates the rst N squares. As input, the function shall take the positive integer number N and as output the function shall...
-
Which algorithm can find if two vertices x & y have path between them?lag stion a . . Depth First Search ( ( DFS ) ) b . . Breadth First Search ( ( BFS ) ) c . . Both DFS & BFS d . . None DFS or BFS
-
Write a function named myrowproduct that takes in input a matrix A , , a column vector x and a random number k , , and as output gives the product computed by row as defined above, and the...
-
Develop a C + + + + program named 'yourName _ _ substringSearch' that allows the user to input a main string and a search string. Please use the linear search to find and display all occurrences of...
-
The fallacy of appeal to authority occurs when an inference relies on the experience, training, or knowledge of people who are experts relevant to the issue at hand. O True O False
-
Explain the meaning of the N-point DFT samples x[k] that are computed from N-points of a sequence x[n].
-
Wholesalers Ltd. deals in the sale of foodstuffs to retailers. Owing to economic depression, the firm intends to relax its credit policy to boost productivity and sales. The firms current credit...
-
Use the K-means algorithm to cluster the data from Exercise 28.20. We can use a value of 3 for K and can assume that the records with RIDs 1, 3, and 5 are used for the initial cluster centroids...
-
Consider the ER diagram shown in Figure 7.21 for part of a BANK database. Each bank can have multiple branches, and each branch can have multiple accounts and loans. (a) List the strong (nonweak)...
-
Discuss which of the updates that created each of the tuples shown in Figure 26.9 were applied retroactively and which were applied proactively.
-
Depository institutions have been losing their advantage over other financial intermediaries in attracting customers funds. Why?
-
In the aftermath of the financial crisis of 20072009, there were calls to reinstate the separation of commercial and investment banking activities that was removed with the repeal of the...
-
The globalization of banking has led to the need for global benchmarks for interest rates. In light of the LIBOR scandal, what characteristic do you think is most central to any new interest rate...
Study smarter with the SolutionInn App