Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

********************************* in c programming languege ****************************** the ID id 190706807 You will construct and answer this question according to your student ID. Assume that you

********************************* in c programming languege ******************************

the ID id 190706807

You will construct and answer this question according to your student ID.

Assume that you will store citizen records in a B+ Tree. Find the minimum OR maximum height of this B Tree according to the following formula:

a-) If your ID is an odd number find the minimum height, otherwise find the maximum height of the tree.

b-) Assume that you have (Your student IDs last [rightmost] two digits * 10 * million) records.

c-) Assume that you have 5-byte pointers if your ID is odd, 10-byte pointers if your ID is even.

d-) Assume that the key size of your record is the (sum of first and last two digits of your ID) bytes.

e-) Assume that the record size of your question is (last [rightmost] two digits * 512 ) bytes.

f-) Assume that the block size of your question is the (first [leftmost] two digits) MB

For example, if your ID is 10 07 06 013 then you will solve the question according to the given parameters below:

a-) The given ID is an odd number, this means you must find the minimum height of the B+ Tree.

b-) The given ID ends with 13, this means you have (13 * 10 * million =) 130 million records.

c-) The given ID is an odd number, this means you will use 5 byte pointers.

d-) Key size is 10 + 13 = 23 bytes.

e-) Record size is 13 * 512 = 6656 bytes.

f-) Block size is 10 MB.

You MUST write down your ID first! If you don't write it your question will NOT BE ACCEPTED!!!

***************************************in C programming language *****************************************

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 Concepts

Authors: David Kroenke, David J. Auer

3rd Edition

0131986252, 978-0131986251

More Books

Students also viewed these Databases questions