Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

Soru 1 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 ID's 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!!! If you do NOT answer the correct question your answer will NOT BE EVALUATED! Therefore, you should first write down your ID and the parameters of your question on top of the text field. If you do not write them correctly, your question will NOT BE EVALUATED! Soru 1 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 ID's 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!!! If you do NOT answer the correct question your answer will NOT BE EVALUATED! Therefore, you should first write down your ID and the parameters of your question on top of the text field. If you do not write them correctly, your question will NOT BE EVALUATED

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_2

Step: 3

blur-text-image_3

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

Flash XML Applications Use AS2 And AS3 To Create Photo Galleries Menus And Databases

Authors: Joachim Schnier

1st Edition

0240809173, 978-0240809175

More Books

Students also viewed these Databases questions

Question

=+designing international assignment C&B packages.

Answered: 1 week ago