Calendar
The approximate schedule of topics is outlined in the calendar below.
This schedule may change to accommodate new material of interest to the class,
or to spend additional time on the more difficult and complex topics.
Quizzes are held at the beginning of the Tuesday class.
Project deliverables are due at the beginning of the Thursday lab session.
| Week |
Class Dates |
Quiz |
Project Deliverable |
Topic |
| 1 |
Sept. 4 |
|
|
Introduction to Relational Databases |
| 2 |
Sept. 9, 11 |
|
|
Conceptual Modelling 1 |
| 3 |
Sept. 16, 18 |
|
Initial Proposal |
Conceptual Modelling 2 |
| 4 |
Sept. 23, 25 |
1 |
|
Normal Forms |
| 5 |
Sept. 30, Oct. 2 |
2 |
Refined Proposal |
Normalization 1 |
| 6 |
Oct. 7, 9 |
3 |
|
Normalization 2 |
| 7 |
Oct. 14, 16 |
4 |
Conceptual Model |
SQL Data Definition Language 1 |
| 8 |
Oct. 21, 23 |
5 |
|
SQL Data Definition Language 2 |
| 9 |
Oct. 28, 30 |
6 |
Physical Design |
SQL Data Definition Language 3 |
| 10 |
Nov. 4, 6 |
7 |
|
SQL Data Manipulation Language 1 |
| 11 |
Nov. 13 |
|
|
SQL Data Manipulation Language 2 |
| 12 |
Nov. 18, 20 |
8 |
DML Population Scripts |
SQL Data Manipulation Language 3 |
| 13 |
Nov. 25, 27 |
9 |
|
SQL Data Manipulation Language 4 |
| 14 |
Dec. 2, 4 |
|
DML Query Scripts |
SQL Data Manipulation Language 5 and Review |
| December 9, 2003 |
Final Examination: 6:00pm - 9:00pm in room A2704 |
|
