(As of 4/4/99 -- subject to revision)
Week # | Main topic (with textbook chapter) | Monday | Wednesday | Friday |
1 | Introduction (1). Conceptual design and ER modeling (14). |
March 29: | March 31: | April 2: |
2 | The relational model (2). Mapping E/R to relational (14). Microsoft SQL Server. |
April 5: | April 7: | April 9: |
3 | Relational algebra (8). SQL (9). |
April 12: | April 14: | April 16: |
4 | More SQL. Relational calculus (8). QBE (11). |
April 19: | April 21: | April 23: |
5 | Normalization (15) Preview of Transaction Processing (17) |
April 26: | April 28: | April 30: |
6 | Midterm Exam this week! Probably
Monday. Concurrency (17) Recovery (18) |
May 3: | May 5: | May 7: |
7 | Object-Database Systems (21). Storage and indexing (3, 4, 5, 6) |
May 10: | May 12: | May 14: |
8 | Storage and indexing continued. | May 17: | May 19: | May 21: |
9 | Query Processing (12) Group project presentations. |
May 24: | May 26: | May 28: |
10 | More project presentations. Current issues in DB |
May 31: Memorial Day: No classes! | June 2: | June 4: LAST DAY OF INSTRUCTION! |
11 |
|
June 7: | June 9: FINAL EXAM 2:30 pm |
Lots of other schedules