About 1/2 of the exam will be on earlier material, from weeks 1 – 8 (before Spring break). Pay particular attention to the earlier designs on books and energy monitoring, as well as SQL queries, constraints, triggers, and UML generally. I also include in this category our in-class coverage of design (see March 16, in class)
About 1/2 of exam 3 will cover the material on Views and relational design, including in-class and at-home study problems (e.g., see March 14, in class; March 21 and 23, in class).
Indexing will not be covered on exam 3 (but will be covered on the final exam).