Date |
Module |
Lecture |
Handout (downloadable) |
|
Aug. 24, Tues. |
|
Course introduction |
|
|
Aug. 26, Thurs. |
1 |
Database foundations |
|
|
Aug. 31, Tues. |
1 |
ERD fundamentals |
|
|
Sept. 2, Thurs. |
1 |
Drawing an ERD |
|
|
Sept. 7, Tues. |
1 |
Relational model |
|
|
Sept. 9, Thurs. |
1 |
Mapping
an ERD to a schema Assignment 1 due |
|
|
Sept. 14, Tues. |
1 |
Schema decomposition |
|
|
Sept. 16, Thurs. |
|
No class |
|
|
Sept. 21, Tues. |
1 |
Schema decomposition Assignment 2 due |
|
|
Sept. 23, Thurs. |
1 |
Normal forms |
|
|
Sept. 28, Tues. |
2 |
Relational algebra |
|
|
Sept. 30, Thurs. |
2 |
Creating and managing
tables Assignment 3 due |
|
|
Oct. 5, Tues. |
2 |
Lab – Creating tables
|
|
|
Oct. 7, Thurs. |
2 |
SELECT statements
|
|
|
Oct. 12, Tues. |
|
Mid-term exam |
|
|
Oct. 14, Thurs. |
|
No class |
|
|
Oct. 19, Tues. |
2 |
Lab – SELECT statements |
|
|
Oct. 21, Thurs. |
2 |
Group functions, joins,
subqueries |
|
|
Oct. 26, Tues. |
2 |
Lab - Managing tables |
|
|
Oct. 28, Thurs. |
2 |
SQL wrap-up |
|
|
Nov. 2, Tues. |
2 |
Lab – Functions and joins |
|
|
Nov. 4, Thurs. |
2 |
User interface design Assignment 4 due |
|
|
Nov. 9, Tues. |
2 |
Lab – Developer/2000
basics
|
|
|
Nov. 11, Thurs. |
2 |
User interface wrap-up |
|
|
Nov. 16, Tues. |
2 |
Lab – Developer/2000 forms development |
|
|
Nov. 18, Thurs. |
3 |
File organization and storage structure |
|
|
Nov. 23, Tues. |
3 |
Database
integrity and security Assignment 5 due |
|
|
Nov. 25, Thurs. |
|
No class – Thanksgiving Break |
|
|
Nov. 30, Tues. |
3 |
Transaction management |
|
|
Dec. 2, Thurs. |
3 |
Query processing |
|
|
Week of Dec. 6 |
|
Final exam |