User Account

All Pages

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

  Data speed effect on fundamental business decisions

Can the speed in which data is transmitted have an adverse effect on fundamental business decisions? Yes, speed that is traveling at big rates of speed can have an affect on fundamental business decisions.

  Discuss new security features in windows server

Which of the system changeover methods is the most expensive? Why? Which of the system changeover methods is the most risky? Why?

  Create algorithm to prepare daily hotel charge report

Create the algorithm to prepare the daily hotel charge report. Input consists of series of records which contain a room number, customer name, cost of the room, and cost of meals charged to the room.

  Encryption feistel cipher and decryption algorithm

If this is psudocode for encryption feistel cipher determine decryption algorithm?Output: ciphertext = (left[16], right[16]) Explain pseudo-code of corresponding decryption algorithm for this cipher.

  Creating code for a class called arrayqsn

Create all the code for a class called ArrayQsn. This class will contain 2-techniques. The first technique runningSumMean accepts an array of ints as a parameter, and will return the mean of the values as a double.

  Create time algorithm-minimum time required to finish task

Create the O(|V | + | E |) time algorithm which, given times ti and the dependencies, determines minimum time required to complete all the tasks.

  Questionm about distributed database

Explain what a distributed database is and how replication works with respect to managing the information in these databases.

  Data structures for a single algorithm

Data structures for a single algorithm

  Database design activities

Assume Ray wishes to start a DVD rental program at his stores that he plans to call Henry's DVD Club. He refers to each of his consumers as members.

  Cloud computing assignment

WSDL service that receives a request for a stock market quote and returns the quote

  Create algorithm to calculate union of two input sets-array

Create algorithm to calculate union of two input sets given as arrays, both of size O(n). The output must be array of distinct elements that form union of the sets.

  Use of primitives helps remove ambiguities in algorithm

Explain the distinction between an ambiguity in a proposed algorithm and an ambiguity in the representation of an algorithm. Describe how the use of primitives helps remove ambiguities in an algorithm's representation.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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