Syllabus
The course consists of 15 weeks of lecture and lab, and a final exam to be held during the winter term examination period.
Quizzes are held at the beginning of the week's lecture session.
Project deliverables are due at the beginning of the week's lab session.
| Week |
Class Dates |
Quiz |
Project Deliverable |
Topic |
| 1 |
September 5 |
|
|
Introduction to Databases |
| 2 |
September 10, 12 |
|
|
Entity-Relationship Model |
| 3 |
September 17, 19 |
|
Initial Proposal |
Normal Forms |
| 4 |
September 24, 26 |
1 |
|
Normalization 1 |
| 5 |
October 1, 3 |
2 |
Refined Proposal |
Normalization 2 |
| 6 |
October 8, 10 |
3 |
|
SQL DDL 1 |
| 7 |
October 15, 17 |
4 |
Conceptual Model |
SQL DDL 2 |
| 8 |
October 22, 24 |
5 |
|
SQL DML 1 |
| 9 |
October 29, 31 |
6 |
Physical Design |
SQL DML 2 |
| 10 |
November 5, 7 |
7 |
|
SQL DML 3 |
| 11 |
November 12, 14 |
8 |
DML Population Scripts |
SQL DML 4 |
| 12 |
November 19, 21 |
9 |
|
SQL DML 5 |
| 13 |
November 26, 28 |
10 |
DML Query Scripts |
Database Applications |
| 14 |
December 3, 5 |
11 |
|
Advanced Topics |
| 15 |
December 10, 12 |
|
Final Project Submission |
Term Review |
| 16 |
Week of December 16 |
|
|
Final Exam |
|
