| Week | Date | Topic | Remarks |
|---|---|---|---|
| 1 | Tues Aug 25 | Organizational Stuff | |
| Thur Aug 27 | A quick tour of data management issues | Slides pdf & the DB2 scripts zip | |
| 2 | Tues Sep 1 | Overview of Database Systems | Read Ch 1. Slides pdf |
| Thur Sep 3 | Introduction to Database Design | Read Ch 2. Slides pdf | |
| 3 | Tues Sep 8 | The Relational Model (i) | Quiz #1. Read Ch. 3. Slides pdf |
| Thur Sep 10 | The Relational Model (ii) | Read Ch. 3. Start reading Ch. 5. Info on projects. Slides pdf | |
| 4 | Tues Sep 15 | SQL: Queries, Constraints, Triggers (i) | Quiz #2. Read Ch. 5. Slides pdf |
| Thur Sep 17 | SQL: Queries, Constraints, Triggers (ii) | Read Ch. 5. Slides pdf | |
| 5 | Tues Sep 22 | SQL: Queries, Constraints, Triggers (iii) | Quiz #3. Read Ch. 5. |
| Thur Sep 24 | SQL: Queries, Constraints, Triggers (iv) | Read Ch. 5. Slides pdf | |
| 6 | Tues Sep 29 | SQL: Queries, Constraints, Triggers (v) | Quiz #4. Start reading Ch. 4.
A Toy Project pdf |
| Thur Oct 1 | Relational Algebra | Read Ch. 4.
Quiz 4 answers pdf
Slides pdf |
|
| 7 | Tues Oct 6 | Finish up on "Relational Calculus". Start on Database Application Development |
Quiz #5. Read Ch.4+6. Project proposals due. Slides for Rel Calc pdf Slides for DB App Dev pdf Sample SQC code sqc.zip |
| Thur Oct 8 | Database Application Development (ii) | Read Ch.6.
Slides for DB App Dev 2 pdf Sample ODBC code odbc.zip Sample JDBC code jdbc.zip |
|
| 8 | Tues Oct 13 | Mid-Term Exam | Grade Distribution |
| Thur Oct 15 | Review Mid-Term Exam | ||
| 9 | Tues Oct 20 | Overview of Storage and Indexing | Quiz #6. Read Ch. 8.
Slides pdf |
| Thur Oct 22 | Overview of Storage and Indexing (ii) | Slides pdf (updated 10/22 11AM to fix delete analysis for heap+hash) | |
| 10 | Tues Oct 27 | Overview of Storage and Indexing (iii) | Quiz #7.
Slides pdf Optional reading on multi-dimensional clustering. |
| Thur Oct 29 | Overview of Query Evaluation | Read Ch.12. Slides pdf updated Nov 4 |
|
| 11 | Tues Nov 3 | Overview of Query Evaluation (ii) | Quiz #8.
Project progress checkpoint. |
| Thur Nov 5 | Overview of Transaction Management | Read Ch.16.
Slides pdf SQL script for simulating the clusteredness of indexes using sequence numbers (explanation of Quiz 8 Qn 3.) |
|
| 12 | Tues Nov 10 | Overview of Transaction Management (ii) | Quiz #9.
Slides pdf |
| Thur Nov 12 | Schema Refrnement and Normal Forms | Read Ch.19.
Slides pdf |
|
| 13 | Tues Nov 17 | Schema Refrnement and Normal Forms (ii) | Quiz #10.
Slides pdf |
| Thur Nov 19 | Schema Refrnement and Normal Forms (iii) |
Slides pdf Project Presentation Template pdf , pptx |
|
| 14 | Tues Nov 24 | special topic: XML databases |
Read Ch 27.{6,7,8}
Slides pdf Scripts xml.zip Optional Reading: DB2 pureXML paper |
| Thur Nov 26 | Thanksgiving Holiday. No Class | ||
| 15 | Tues Dec 1 | Potpourri. | Quiz #11. |
| Thur Dec 3 | Project Demo & Presentations (8) | ||
| 16 | Tues Dec 8 | Project Demo & Presentations (7) | |
| Thur Dec 10 | Review | ||
| 17 | Tues Dec 15 | Final Examination | Open Notes Policy: One sheet of letter size paper with either printed or handwritten notes on both sides will be allowed in the Final Exam. |
