CSI 3317 -- Notes

For most of the lectures, we use Raghu Ramakrishnan and Johannes Gehrke's notes that come with the book. I will adapt these notes to our needs, and since they are not complete, you'll get additional notes on due time. All the notes will be posted here.

The notes are copyrighted; therefore they are intended for your private use. Never redistribute them in any form whatsoever.

To print these notes in a 4-on-one-page format, do the following: point the mouse on the open slides and click on the right mouse button; go to the print menu; in the menu "Print what", choose "handouts", then set the "Slides per page" value to 4; finally, hit the "ok" button.

  1. Overview of DBMSs (RG Chap 1): notes -- Sept 10 2003
  2. The Entity-Relationship Model (RG Chap 2): notes -- Sept 12 2003
    Read further Sections 2.5.4, 2.7, and 2.8
  3. The Relational Model (RG Chap 3): notes -- Sept 17 2003
  4. Algebra and Relational Calculus (RG Chap 4):
  5. SQL: Queries, constraints, and triggers (RG Chap 5): notes -- Sept 26 2003 (tentatively)
  6. Database application development (RG Chap 6): notes -- Oct 03 2003
    Note: for these notes and the one for the next chapter, I will cover only selected parts, though you are encouraged to read the entire notes.
  7. Internet applications (RG Chap 7):
  8. Storage and indexing (RG Chap 8-11):
  9. Query processing (RG Chap 12-15):
  10. Transaction processing (Chap 16; Sections of Chap 17,18)
  11. Revision -- Nov 21 2003
  12. Schema refinement and nornal forms