CS186 In-class Exercises

Exercise 1 - 9/4, Relational Algebra, answers can be found at end of lecture 4

Exercise 2 - 9/11, Relational Calculus, answers can be found at end of lecture 6

Exercise 3 - 9/25, SQL, Query Optimization, the key for the SQL portion can be found here.  The key for the query optimization can be found here.

Exercise 4 - 10/1, E-R Models (key included)

Exercise 5 - 10/23, B-Trees & Hash Tables (key included)

Exercise 6 - 11/17, Concurrency Control (key included)

Exercise 7 - 11/24, Query Optimization (key included)