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.

User Account

All Pages