Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) Assume that UHCL stores student records in blocks of 512 bytes. The system uses a block pointer which 10 bytes long and a record

image text in transcribed

1) Assume that UHCL stores student records in blocks of 512 bytes. The system uses a block pointer which 10 bytes long and a record pointer is also 10 bytes long. There are 40,000 student records. A student record has the following layout: Student(SSN, LastName, FirstName, Street, City, State, Zip, Phone, DateOfBirth, Gender, Major) 10 Bytes 10 Bytes 9 Bytes10 Bytes 9 Bytes 4 Bytes 20 Bytes 20 Bytes 2 Bytes10 Bytes 1 Byte A) Assume that the UHCL Student file uses an unspanned organization. That is, no record is may split across disk blocks. Ignore any overhead. Show work for each question below. It is worth a total of 15 points. a) Calculate the record size in bytes. b) Calculate the blocking factor of the data file c) Calculate the number of file blocks

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Transaction Processing

Authors: Philip M. Lewis, Arthur Bernstein, Michael Kifer

1st Edition

0201708728, 978-0201708721

Students also viewed these Databases questions