| Week |
From
1/16/07
|
To
5/10/07 |
Chapter |
Contents |
Lab
Assignments |
Lab
Assignment Due |
| WK 01 |
1/17/07 |
1/19/07 |
Chapter 1 |
Introduction to Database
Management
|
Useful links |
|
| WK 02 |
1/22/07 |
1/26/07 |
Chapter 2 |
The Relational Model 1: Introduction, QBE, and Relational Algebra |
Lab 1:
Do Programming
1 & 2 (page 33) |
|
| WK 03 |
01/29/07 |
2/02/07 |
Chapter 2 |
Continue |
|
Lab 1 due
(Friday 2/2/07) |
| WK 04 |
02/05/07 |
02/09/07 |
Chapter 3 |
The Relational Model 2: SQL |
Lab 2:
Do Programming
1 & 3 (page 66) |
|
| WK 05 |
02/12/07 |
02/16/07 |
Chapter 3 |
Continue |
|
Lab 2 due
(Friday 2/16/07) |
| WK 06 |
02/19/07 |
02/23/07 |
Chapter 4 |
The Relational Model 3: Advanced Topics |
Lab 3:
Do Programming
1 & 2 (page 95-96) |
|
| WK 07 |
02/26/07 |
03/02/07 |
|
|
|
Lab 3 due |
| WK 08 |
03/05/07 |
03/09/07 |
Chapter 5 |
Database Design 1:
Normalization |
Lab 4:
Do Programming
4 (page 119) |
|
| WK 09 |
03/12/07 |
03/16/07 |
|
Spring Break |
|
|
| WK 10 |
03/19/07 |
03/23/07 |
|
Midterm Exam |
|
Lab 4 due |
| WK 11 |
03/26/07 |
03/30/07 |
Chapter 6 |
Database Design 1: Design
Methodology |
Lab 5:
Do Programming
4 (page 145) |
|
| WK 12 |
04/02/07 |
04/06/07 |
|
|
Project Assign
Answer |
Lab 5 due |
| WK 13 |
04/09/07 |
04/13/07 |
Chapter 7 |
DBMS Functions |
Lab 6:
Do Programming
3 (page 179) |
|
| WK 14 |
04/16/07 |
04/20/07 |
|
|
|
Lab 6 due |
| WK 15 |
04/23/07 |
04/27/07 |
Chapter 8 |
Database Administration |
|
Project due |
| WK 16 |
04/30/07 |
05/04/07 |
|
Final Exam |
|
|