| Week | Date | Topic | Chapter | Notes | Assignment | Due date |
| 1 | 19-Aug-03 | Introduction | 1, 2, 3 | Class 1 | 1.7, 1.10 | |
| 21-Aug-03 | Class 2 | 2.11 | ||||
| 2 | 26-Aug-03 | Relational Data Model | 2,4 | Class 3 | Read Ch. 3 | |
| 28-Aug-03 | Class 4 | |||||
| 3 | 2-Sep-03 | Relational Data Model | 4 | Class 5 | ||
| 4-Sep-03 | Relational Data Model | 4 (Cont.) | Class 6 | 4.5,4.6,4.7 | ||
| 4 | 9-Sep-03 | E-R Model | 5 | Class 7 | Read 5.7 | |
| 11-Sep-03 | E-R Model(Continue) | 5 | Class 8 | 5.7 | 11:59 pm, Sep 17 | |
| 5 | 16-Sep-03 | Review | ||||
| 18-Sep-03 | Midterm 1 | |||||
| 6 | 23-Sep-03 | Relational Algebral and SQL | 6 | Class 9 | 6.9,6.10 | 11:59 pm, Oct 1 |
| 25-Sep-03 | RA & SQL (continue) | |||||
| 7 | 30-Sep-03 | Relational Normalization Theory | 8 | Class 13 | 8.4,8.15 | 11:59pm,Oct 15 |
| 2-Oct-03 | Relational Normalization (cont) | SQL Homework | 11:59pm, Oct 5 | |||
| 8 | 7-Oct-03 | BCNF, 3NF | 8 | 8.23,8.24 | 11:59pm,Oct 22 | |
| 9-Oct-03 | Decomposition | 8 | ||||
| 9 | 14-Oct-03 | Fall break | ||||
| 16-Oct-03 | 4NF | 8 | Project | |||
| 10 | 21-Oct-03 | 4NF continue | ||||
| 23-Oct-03 | Review (1/2 class) | |||||
| 11 | 28-Oct-03 | Midterm 2 | ||||
| 30-Oct-03 | Triggers and Active Database | 9 | Class 15 | 9.5 | 11:59pm,Nov 5 | |
| 12 | 4-Nov-03 | SQL in the real world | 10 | Class 16 | ||
| 6-Nov-03 | Physical Data Organization and Indexing | 11 | Class 17 | |||
| 13 | 11-Nov-03 | Extra Test | ||||
| 13-Nov-03 | Query Processing (Basics) | 13 | Class 18 | |||
| 14 | 18-Nov-03 | Object Databases | 16 | Class 19 | ||
| 20-Nov-03 | ||||||
| 15 | 25-Nov-03 | Database and the Web | 17 | Class 20 | ||
| 27-Nov-03 | Thanksgiving Holiday | |||||
| 16 | 2-Dec-03 | Database and the Web (Cont.) | Proj. Explaination | |||
| 4-Dec-03 | Review (1/2 class) | |||||
| 17 | 8-Dec-03 | Final Exam (3:30pm - 5:30pm) |
Last modified: Mon Dec 01 15:49:27 Mountain Standard Time 2003