CS145 - Spring 2002
Introduction to Databases
Final Exam Information

Review Sessions
For your convenience, two alternative review sessions will be conducted by the TA's:

Please bring questions. The review sessions will not be televised.

Material Covered
The final exam will cover all material covered by the midterm exam (see Midterm Logistics and Review). In addition, the following material will be covered:

A few things to note:

What follows is an outline of the material we've covered since the midterm exam. All of this material is fair game for the final exam.

  1. Object-oriented design

  2. Translating E/R and ODL to relations

  3. Transactions

  4. Authorization

  5. Constraints and triggers

  6. Recursion

  7. Object-relational SQL

  8. Temporal databases

  9. Data warehousing and mining

  10. XSLT

  11. XML Schema (very cursory)