All dates, lecture topics, assignments, in-class exercises
are subject to
reasonable change at the discretion of your instructor.
Any changes will be announced.
 |
|
|
Week |
Day |
Topic |
Assignments |
|||||||||
|
|
1 |
|
K:
Chap. 1 HW
1 |
|||||||||
|
2 |
|
|
||||||||||
|
|
3 |
Simple
Tables |
K:
Chap. 2 HW
2 |
|||||||||
|
4 |
Relations
and Keys |
|
||||||||||
| Database Courseware | ||||||||||||
|
|
5 |
Constraints |
K:
Chap. 3 HW
3 |
|||||||||
|
6 |
Normalization |
K:
Chap. 5 F:
Chap. 2, pgs 45-50 |
||||||||||
|
|
7 |
Relationships
|
K:
Chap. 4 F:
Chap. 2, pgs 33-44, Chap. 11 HW
4 |
|||||||||
|
8 |
Many-to-Many,
WHERE clause |
K:
Chap. 4 |
||||||||||
|
|
9 |
Review |
K:
Chap. 3 |
|||||||||
|
10 |
Midterm |
|
||||||||||
|
|
11 |
Relational
Algebra, Subqueries |
F:
Chaps. 3, 4, 8, 9, 11, 10 Handout HW
5 |
|||||||||
|
12 |
Two-Table
Joins |
F:
Chap. 7 K: Chap. 3 |
||||||||||
|
|
13 |
|
K:
Chap. 3 HW
6 |
|||||||||
|
14 |
|
K:
Chap. 4 |
||||||||||
|
|
15 |
Subtypes
and Supertypes |
K:
Chap. 4 HW
7 |
|||||||||
|
16 |
Functions |
F:
Chap. 5 |
||||||||||
|
|
17 |
Advanced
SQL Queries |
F:
Chap. 6 |
|||||||||
|
18 |
Advanced
Database Design |
K:
Chap. 6 |
||||||||||
|
|
19 |
Review |
|
|||||||||
|
20 |
Final
– Part I: Practicum |
|
||||||||||
|
|
Finals
Week |
Final
– Part II |
|