Using a document at your own school (for example, a class schedule), determine the attributes present in the document. using your knowledge of the policies at your school, determine the functional dependencies present in the document. open a new microsoft® word document and use these dependencies to create a set of tables and columns that you could use to produce the document. save the file on your computer with your last name in the file name. (example: case_1-1 _jones. doc). click the choose file button to find and select your saved document.

Suppose there is a relation r(a, b, c) with a b+-tree index with search keys (a, b).1. what is the worst-case cost of finding records satisfying 10 < a < 50 using this index, in terms of the number of records n1, retrieved and the height h of the tree? 2. what is the worst-case cost of finding records satisfying 10 < a < 50 and 5 < b < 10 using this index, in terms of the number of records n2 that satisfy this selection, as well as n1 and h defined above? 3. under what conditions on n1 and n2, would the index be an efficient way of finding records satisfying the condition from part (2)?