Computations of database characteristics

Assignment Help Data Structure & Algorithms
Reference no: EM1380466

Question: 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) Compute the record size R in bytes.
(b) Compute the blocking factor bfr and the number of file blocks b assuming an unspanned organization.
(c) Suppose the file is ordered by SSN; compute the number of blocks it takes to search for a record given its SSN value by doing a binary search.

 

Reference no: EM1380466

Questions Cloud

Question about lan and wan : Think about the following two scenarios two computers are connected to a LAN using a total of 20-feet of cable, and two computers are connected over the Internet and are 8000 miles from each other.
Illustrate what tradeoffs did you contemplate : When faced with challenges, illustrate what information did you use to make your decision also illustrate what tradeoffs did you contemplate.
Explain why manager believe that fundamental contradiction : Explain why manager believe that fundamental contradiction to be encountered in organizational life also especially in health care organizations.
Sharing a large computer file : Assume you are sitting at desk at office and using your laptop computer. The boss calls an emergency meeting for you and many colleagues, and asks everyone to bring his or her laptop computer.
Computations of database characteristics : A file has r=20,000 student records of fixed-length. Suppose the file is ordered by SSN; compute the number of blocks it takes to search for a record given its SSN value by doing a binary search.
You may write on an ethical dilemma you have individually : You may write on an ethical dilemma you have individually experienced provided it isn't something that is confidential or seen at work
Paul has confined some powerful words for the believer : Paul has confined some powerful words as well as encouragement for the believer. Our call to sacrificially submit ourselves to others doesn't begin with our sacrifice however with God's blessings
Predict ticket sales for the upcoming season : You have projected income elasticity to be 0.75. Describe what this means and why it is important for management.
Most populations with reliable data birth rates vary : For instance in most populations with reliable data birth rates vary by the season of the year. The seasonality of births isn't identical in all populations.

Reviews

Write a Review

Data Structure & Algorithms Questions & Answers

  Explain solution to recurrence-appealing to recursion tree

Solve the following recurrence relations by the method of your choiceT(n) = 1 for n = 4 and T(n) =pnT(pn) + n for n > 4. Argue that the solution to the recurrence T(n) = T(n=3) + T(2n=3) + cn is (n lg n) by appealing to the recursion tree.

  Polynomial time algorithm for rooted directed acyclic graphs

Illustrate that if you were given a polynomial time algorithm for determining whether two rooted directed acyclic graphs are isomorphic, then polynomial time algorithm for testing.

  Java program to assign passengers seats in airplane

Prepare a Java program to assign passengers seats in an airplane. Suppose a small airplane with seats numbered as follows:

  Benefits of dynamic over static arrays

Discuss the benefits of dynamic over-static arrays. Under what conditions will you choose dynamic arrays?

  Describe why algorithm runs in linear time-adjacency matrix

Rreached from every other vertex. Describe why your algorithm runs in linear time (O(V2) on an adjacency matrix; O(E+V) on an adjacency list).

  Question about damaged database

Suppose if you were one of the users of a damaged database, discuss how would you be affected by such a failure and what measures could you take to prevent it?

  Find maximum possible amount of money by optimal strategy

Removes it from row permanently, and receives value of coin. Find out the maximum possible amount of money we can definitely win if we move first.

  Explain types of information systems

Question 1. Explain five types of information systems, and give an example of each. Question 2. Describe three common reasons for a systems request. Try and find one not listed in the text.

  Studying in major paralegal

Make a Microsoft Word document which includes a table and hyperlinks to Web sites helpful to someone studying in your main Paralegal.

  Demonstrate a decision tree or table

Demonstrate a decision tree or table

  Describe properties of bfs and dfs for acyclic tree

Analyze the given properties of BFS and DFS for Acyclic Tree without making any assumptions. Optimality, Completeness.

  Create a java program to arithmetic expression

Create a Java program that takes as input an infix arithmetic expression then transforms to a postfix expression and based on binary tree, it evaluates that expression.

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