In the final I will not ask (again) about the E/R design. However, all the rest covered in class will be there. The textbook is designed to be for two courses, the second one being a 4th year & grad topics course (offered sometimes, usually once every other year). The covered material for CSC 370 is as follows: Ch 1 (all) --- not in final exam Ch 2 (except 2.3) --- not in final exam Ch 3.1-3.3 --- not in final exam ---All the rest is in the final Ch 3.4 3.5 3.6.1-3.6.5 Ch 5.1 5.2 5.3 5.4 Ch 6 (all) (For the above, the posted slides contain also some additional examples and explanations.) Regarding the material of Ch 7, I recommend you read instead my correponding slides: Constraints: Foreign Key Constraints. Constraints on attributes and tuples. Modification of Constraints. Triggers. where I have filtered out things, which aren't completely implemented by databases today. Ch 8.2 8.5 8.7 Regarding 8.2, I also suggest you read instead my corresponding slides: Procedures Stored in the Schema. PL/SQL. The Impedance Mismatch Problem. Cursors. More PL/SQL. where I cover the Oracle variant of stored procedures. Regarding 8.7, I have additional and slightly different material in my slides. Ch 11.2 11.3 11.4 Ch 13.1.1 - 13.1.3, 13.1.6, 13.2.1 - 13.2.3 13.3.1 - 13.3.5, 13.3.7 Ch 17.1 17.2 17.3 Ch 18.1 18.2 18.3 18.4.1, 18.4.2 Also, I have covered Overview of Query Evaluation: Algorithms for Relational Operators. Introduction to Query Optimization. which is not exactly in the book. In fact the book has a lot of material on this topic, and I have provided a short summary in my slides. Full coverage for Query Evaluation and other advanced topics is in the follow-up 4th year & grad topics course (offered sometimes, usually once every other year).