Exercise Instructions 1. Use the SQL Server Management Studio to complete this lab. a. Create a SQL script file named Car_Inspection_DB_Script_Your_initi als. SQL (John Doe would name it Car_Inspeciton_DB_Script_JD. SQL). When executed this script is to create a database named Car_Inspection_Your_Initials that contains the objects described in this document. 2. Upload and submit the Car_Inspection_DB_Script_Your_Initi als. SQL file before the due date. Car_Inspection_Your_Initials Design Specifications

What are listed in the vertical columns across the top of the event editor? a. file names b. conditions c. check marks d. action types

All of these are true about using adhesive except: a. dissimilar materials can be joined. b. mixing tips are product and material specific. c. a specific application gun may be required. d. two-part adhesives are dispensed using two mixing tips

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)?