Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

- Record size R (in bytes). - Blocking factor bfr. - Number of file blocks b Consider a disk with a block size B=1024 bytes

image text in transcribed

- Record size R (in bytes).

- Blocking factor bfr.

- Number of file blocks b

Consider a disk with a block size B=1024 bytes and a block pointer P=12 bytes. Suppose, file has r=69632 EMPLOYEE records of fixed length. Each record has following attributes: - First_name (60 bytes); - SSN (18 bytes); - Dnumber (18 bytes); - Home_address (80 bytes); - Contact_phone (20 bytes); - BDate (16 bytes); - Gender ( 2 byte); - Job_code (8 bytes); - Salary (8 bytes); - Additional 2 bytes are used as a deletion marker. a. Assuming an unspanned organization, calculate following. *To get full points, please, show all formulas and calculations

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

Concepts Of Database Management

Authors: Joy L. Starks, Philip J. Pratt, Mary Z. Last

9th Edition

1337093424, 978-1337093422

More Books

Students also viewed these Databases questions

Question

1. Discuss the five types of learner outcomes.

Answered: 1 week ago