| Lecture | Topic | PDF/PPT | Next Lecture Reading |
|---|---|---|---|
| Tue, Jan. 4 | Course introduction Review of data models and data independence |
Ch.1-3 of EN |
|
| Thur, Jan. 6 | Review of ER modeling |
Ch. 8 of EN |
|
| Tue, Jan. 11 | Review ER-Relational Mapping Review of SQL language |
Ch. 6 of EN |
|
| Thur, Jan. 13 | Review of Relational algebra |
Ch. 7 of EN |
|
| Tue, Jan. 18 | No Class! |
Ch. 15 of EN |
|
| Thur, Jan. 20 | Normal forms |
Ch. 15 of EN |
|
| Tue, Jan. 25 | Normal forms - continued |
Ch. 16 of EN |
|
| Thur, Jan. 27 | Normal forms - continued |
Ch. 16 of EN |
|
| Tue, Feb. 1 | Normal forms - continued |
Ch. 16 of EN |
|
| Thur, Feb. 3 | Normal forms - continued |
||
| Tue, Feb. 8 | Database design life cycle |
||
| Thur, Feb. 10 | Midterm review |
||
| Tue, Feb. 15 | Midterm |
Ch. 17 of EN |
|
| Thur, Feb. 17 | Primary file organization |
Ch. 18 of EN |
|
| Tue, Feb. 22 | File indexing |
Ch. 19 of EN |
|
| Thur, Feb. 24 | Query processing |
Ch. 19 of EN |
|
| Tue, Mar. 1 | Query optimization |
||
| Thur, Mar. 3 | New types of databases |
||
| Tue, Mar. 8 | Final project - presentation |
|
|
| Thur, Mar. 10 | No Class! |
|