Exams
Assignments
- Written Assignment #1 Due April 8
PostScript, PDF
- Written Assignment #2 Due April 15
PostScript, PDF
- Written Assignment #3 Due April 22
PostScript, PDF
- Programming Assignment #1 Due April 23
PostScript, PDF
- Written Assignment #4 Due May 6
PostScript, PDF
- Programming Assignment #2 Due May 7
PostScript, PDF
- Written Assignment #5 Due May 13
PostScript, PDF
- Programming Assignment #3 Due May 16
PostScript, PDF
- Written Assignment #6 Due May 20
PostScript, PDF
- Programming Assignment #4 Due May 23
PostScript, PDF
- Written Assignment #7 Due May 27
PostScript, PDF
- Programming Assignment #5 Due May 30
PostScript, PDF
- Written Assignment #8 Not Due
PostScript, PDF
Lecture Notes
- Lecture Notes #1: Introduction
(PostScript, PDF)
- Lecture Notes #2: Database Design Using E/R Model
(PostScript, PDF)
- Lecture Notes #3: Database Design Using ODL
(PostScript, PDF)
- Lecture Notes #4: Relational Database Design: The Basics
(PostScript, PDF)
- Lecture Notes #5: Relational Database Design: FD's & BCNF
(PostScript, PDF)
- Lecture Notes #6: Relational Algebra
(PostScript, PDF)
- Lecture Notes #7: SQL Query & Modification
(PostScript, PDF)
- Lecture Notes #8: SQL Tables, Keys, Views, Indexes
(PostScript, PDF)
- Lecture Notes #9: SQL NULL's, Constraints, Triggers
(PostScript, PDF)
- Lecture Notes #10: SQL Programming
(PostScript, PDF)
- Lecture Notes #11: SQL Transactions
(PostScript, PDF)
- Lecture Notes #12: SQL3 Object-Relational Features
(PostScript, PDF)
- Lecture Notes #13: SQL3 Recursion
(PostScript, PDF)
- Lecture Notes #14: Lossless Decomposition, 3NF, 4NF
(PostScript, PDF)
- Lecture Notes #15: Introduction to OQL
(PostScript, PDF)
- Lecture Notes #16: Beyond CS145: Data Warehousing,
Data Mining, XML/XQL, Search Engines
(PostScript, PDF)