Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Related questions
Question
Consider a disk with block size B=512 bytes. A block pointer is P = 6 bytes long. A record pointer is P = 7 bytes long and key value size = 9 bytes long. Construct a B Tree with 30,000 records. The minimum height of the tree is (Assume root node is of level 1).
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Consider the following binary search tree (BST) with the node (#70) circled in red. Due to a programming error, this node cannot be visited /accessed, resulting in the tree's inability to accommodate certain numeric values when inserted. Given the described situation, we insert a value 89 into this BST. Which node # becomes this value 89's parent? O O 70 80 O 75 O 90 15 20 18 23 25 30 35 50 error node, cannot be visited 45 65 68 80 75 90 95 100 150arrow_forwardWrite a program that inserts the numbers into an initially empty BST such that the tree produced is equivalent to binary search tree. Insert 16 as a root node then add 1 into 16 to generate 2nd number for insertion, add 2 to the 2nd number to generate 3rd number continue adding according to the level of the tree till 5th level. Then subtract 1 from root node to generate 7th node Continue subtracting till level of 5th level. The Insert function will only take the root node and construct the entire tree Implement a remove function which can remove the 3rd layer numbers from right and left both sub trees. Implement a function to find the number which is nearby to your given age Question-2 (b) Draw a binary search tree and AVL tree from the following traversals: {15, 5, 20, 70, 3, 10, 60, 90, 16} Delete 15 and re-draw both Binary Search Tree and AVL Tree drawn in given traversal. Reverse path of Binary Search Tree drawn Convert Binary Search Tree into Binary Tree such that sum of…arrow_forwardExplore a specific way to delete the root node ofthe Binary Search Tree (BST) while maintaining the Binary Search Tree(BST) property after deletion.Implementation will be as stated below:[1] Delete the root node value of the BST and replace the root value withthe appropriate value of the existing BST .[2] Perform the BST status check by doing an In-Order Traversal of theBST such that even after deletion the BST is maintained.# Class to represent Tree nodeclass Node:# A function to create a new nodedef __init__(self, key):self.data = keyself.left = Noneself.right = NoneThe root element of the Binary Search Tree is given to you. Below is an illustrated sample of Binary Search Tree nodes for your reference, which in-fact isthe same example we discussed in the lecture.root = Node(4)root.left = Node(2)root.right = Node(6)root.left.left = Node(1)root.left.right = Node(3)root.right.left = Node(5)root.right.right = Node(7)Delete the root node value provided and replace the root valuewith…arrow_forward
- You are going to simulate the operation of an AVL tree on paper. For the purposes of this assignment, assume that new returns addresses in the following order: @1480 @1120 @1096 @1264 @1180 @1192 @1768 @1804 @1228 @1372 @1312 @1276 @1168 @1696 @1084 @1504 @1468 @1216 @1384 @1204 @1648 @1024 @1108 @1396 @1144 @1432 @1252 @1348 @1564 @1072 @1684 @1540 @1672 @1624 @1420 @1588 @1300 @1792 @1060 @1720 @1336 @1612 @1552 @1324 @1636 @1660 @1288 @1708 @1732 @1492 @1780 @1528 @1156 @1444 @1036 @1456 @1240 @1576 @1516 @1756 @1360 @1132 @1408 @1600 @1744 @1048 Also note that if you remove all references to an address (so it is garbage collected), it goes to the back of the queue (so would be after whatever is the last address in the AVL at that time). For delete() of a node with two children, I want you to assume that we replace the data (but not the node itself) with the successor value (and that the successor is removed and garbage collected). There are no duplicates allowed, so if there's a…arrow_forward= Suppose that we have a B and the size of the search key field V is equal to 10 bytes, the size of the data (record) pointer Pr 6 bytes, and the tree (block) pointer P is 5 bytes and the value of p (the order or the maximum number of a tree pointers in a node) is equal to 20 for an internal node. a) Calculate the block size (B) b) Suppose that we have a B- tree instead of B and based on the block size found in question (a), calculate the order (p) for an internal node in this case.arrow_forwardunique please Your task for this assignment is to identify a spanning tree in one connected undirected weighted graph using C++. Implement a spanning tree algorithm using C++. A spanning tree is a subset of the edges of a connected undirected weighted graph that connects all the vertices together, without any cycles. The program is interactive. Graph edges with respective weights (i.e., v1 v2 w) are entered at the command line and results are displayed on the console. Each input transaction represents an undirected edge of a connected weighted graph. The edge consists of two unequal non-negative integers in the range 0 to 9 representing graph vertices that the edge connects. Each edge has an assigned weight. The edge weight is a positive integer in the range 1 to 99. The three integers on each input transaction are separated by space. An input transaction containing the string “end-of-file” signals the end of the graph edge input. After the edge information is read, the process…arrow_forward
- Implement a priority list using a heapordered binary tree, but instead of an array, use a triply linked structure. Each node will require three links: two to travel down the tree and one to traverse up the tree. Even if no maximum priority-queue size is known ahead of time, your implementation should ensure logarithmic running time per operation.arrow_forwardconstruct a binary search tree using a set of numbers, similar to the example mentioned in the class. after constructing the BST, you need to give the pre-order traversal of the tree. Finally, you’re required to remove the root of tree. Please show me step by step how to do this!arrow_forwardLanguage : javaarrow_forward
- Implement a priority queue using a heapordered binary tree, but use a triply linked structure instead of an array. You will needthree links per node: two to traverse down the tree and one to traverse up the tree. Yourimplementation should guarantee logarithmic running time per operation, even if nomaximum priority-queue size is known ahead of time.arrow_forward= Suppose that we have a B and the size of the search key field V is equal to 10 bytes, the size of the data (record) pointer Pr 6 bytes, and the tree (block) pointer P is 5 bytes and the value of p (the order or the maximum number of a tree pointers in a node) is equal to 20 for an internal node. a) Calculate the block size (B) b) Suppose that we have a B- tree instead of B and based on the block size found in question (a), calculate the order (p) for an internal node in this case.arrow_forwardA binary search tree is a data structure that consists of JavaScript objects called "nodes". A tree always has a root node which holds its own integer value property and can have up to two child nodes (or leaf nodes), a left and right property. A leaf node holds a value attribute and, likewise, a left and right attribute each potentially pointing to another node in the binary tree. Think of it as a javascript object with potentially more sub-objects referenced by the left and right attributes. There are certain rules that apply to a binary tree: A node's left leaf node has a value that is <= than to its own value A node's right leaf node has a value that is => its own value. In other words: let node = { value: left: right: = this object's value> } You will be writing a function called isPresent that takes two arguments: the root object and a value (number), and returns a boolean true if the value is present in the tree or false if it is not present. function isPresent(root,…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON 
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education