Question: 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

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!!!
solve for odd!!
id : 190706318

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!