|
|
| Week | Topics | Reading | Assignment | Project |
|---|---|---|---|---|
| 1 (08/27, 08/29, 08/31) |
-- Introduction -- ER Model | Chapter 1 Chapter 2 | ||
| 2 (09/03, 09/05, 09/07) 09/03: Laber Day, no class | Relational Model | Chapter 3 | ||
| 3 (09/10, 09/12, 09/14) |
-- Project Overview -- Relational Algebra | Chapter 4.1-4.2 | Assignment 1 | Stage 1 09/14, Friday |
| 4 (09/17, 09/19, 09/21) | Relational Schema Design | Chapter 19.1-19.7 | Assignment 1 due 09/17, Monday | |
| 5 (09/24, 09/26, 09/28) |
-- Quiz 1 -- Relational Schema Design | Chapter 19.1-19.7 | ||
| 6 (10/01, 10/03, 10/05) | SQL-basics | Chapter 5 | Stage 2 10/05, Friday | |
| 7 (10/08, 10/10, 10/12) | SQL-basics | Chapter 5 | Assignment 2 | |
| 8 (10/15, 10/17, 10/19) |
-- SQL-modifications -- Midterm Review -- Midterm exam (10/19 Friday in-class exam) | Chapter 5 | Assignment 2 10/15, Monday | SQL demo |
| 9 (10/22, 10/24, 10/26) |
-- SQL-constraints -- Quiz 2 | Chapter 5 | ||
| 10 (10/29, 10/31, 11/02) |
-- Web-based DB Programming -- Quiz 3 | Chapter 6-7 | Stage 3 11/02, Friday | |
| 11 (11/05, 11/07, 11/09) | Tree-structured Indexing | Chapter 10 | Assignment 3 | |
| 12 (11/12, 11/14, 11/16) 11/12: Veteran's Day, no class | -- Hash Based Indexing -- Transaction Management | Chapter 11 | Assignment 3 11/14, Wednesday | |
| 13 (11/19, 11/21, 11/23) 11/21, 11/23: Thanks Giving Holiday, no class |
-- Transaction Management -- Quiz 4 | Chapter 16 | ||
| 14 (11/26, 11/28, 11/30) |
-- Crash Recovery -- Quiz 5 | Chapter 18 | Assignment 4 | Stage 4 11/30, Friday |
| 15 (12/03, 12/05, 12/07) 12/03: Project evaluation, no class |
-- Quiz 5 -- Final Review | Assignment 4 12/05, Wednesday | ||
| 16 (12/10 - 12/14) |
Final Exam (12/13, Thursday 10am-12pm) |