Question: SQL Question A file has r=200000 STUDENT records of fixed-length. Each record has the following fields: NAME (30 bytes), SSN (9 bytes), ADDRESS (40 bytes),

SQL Question

SQL Question A file has r=200000 STUDENT records of fixed-length. Each record

A file has r=200000 STUDENT records of fixed-length. Each record has the following fields: NAME (30 bytes), SSN (9 bytes), ADDRESS (40 bytes), PHONE (10 bytes), BIRTHDATE (8 bytes), SEX (1 byte) MAJORDEPTCODE (3 bytes), MINORDEPTCODE (4 bytes), CLASSCODE (4 bytes, integer), and DEGREEPROGRAM (3 bytes). An additional byte is used as a deletion marker. The file is stored on the disk whose parameters are given in Question 1. (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 1. the file blocks are stored contiguously, and 2. if the file blocks are not stored contiguously. (d) Assume the file is ordered by SSN; calculate the time it takes to search for a record given its SSN value by doing a binary search

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Sally's Soaps Sally, your boss at * Sally's Soaps', just walked into your office. She is a little upset as she hands you a print out of an email she just received. You take it and read: Sally, I...

Question 2: A file has r=200000 STUDENT records of fixed-length. Each record has the following fields: NAME (30 bytes), SSN (9 bytes), ADDRESS (40 bytes), PHONE (10 bytes), BIRTHDATE (8 bytes), SEX...

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),...

Consider a disk with the following characteristics: block size B=512 bytes, interblock gap size G=28 bytes, number of blocks per track =20, number of tracks per surface =400. A disk pack consists of...

Consider a disk with block size B=512 bytes. A block pointer is P=6 bytes long, and a record pointer is P R =7 bytes long. A file has r=30,000 EMPLOYEE records of fixed-length. Each record has the...

A file has r = 2 0 0 0 0 STUDENT records of fixed - length. Each record has the following fields: NAME ( 3 0 bytes ) , SSN ( 9 bytes ) , ADDRESS ( 4 0 bytes ) , PHONE ( 9 bytes ) , BIRTHDATE ( 8...

A file has r = 3 0 0 0 0 STUDENT records of fixed - length. Each record has the following fields: NAME ( 3 0 bytes ) , SSN ( 9 bytes ) , ADDRESS ( 4 0 bytes ) , PHONE ( 9 bytes ) , BIRTHDATE ( 8...

. Consider a disk with block size B - 5 1 2 bytes. A block pointer is P - 6 bytes long and a recordPor PR - T bytes long. A file has r = 3 0 , 0 0 0 EMPLOYEE records of fixed - length. Each record...

For the following system configuration, please compute the solutions to each (a g) along with their sub-parts. Consider a disk with block size B=512 bytes. A block pointer is P=6 bytes long, and a...

A file has r = 20000 STUDENT records of xed-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), MAJOR...

Consider a disk with block size B-512 bytes. A block pointer is P 6 bytes long, and a record pointer is PR 7 bytes long. A le has r = 30000 EMPLOYEE records of xed- length. Each record has the...

Monica Bing, an educated businesswoman-turned-chef, was looking to join a local fitness club, to work off stress after the long hours she puts in at her restaurant, MC Ritzy, which she co-owns with...

Use Equation (4.1) to estimate MSBrand, the variability between Brand means. Equation 4.1 = 16 Ã (81.8 81.3)2 + 16 Ã (80.9 81.3)2 / 2 1 MSBran,-- 2-1

IRS compoters use document matching programs for both individuals and business taxpayers to keop the aradit rate low, Tree False

Waterways Corporation uses very stringent standard costs in evaluating its manufacturing efficiency. These standards are not "ideal" at this point, but the management is working toward that as a...

6. Discuss the steps involved in conducting a task analysis.

8. Explain competency models and the process used to develop them.

7. Analyze task analysis data to determine the tasks for which people need to be trained.