Week of |
Chapter |
Description and Slides |
Events |
|
Sept 25 |
1, 2 |
intro, general concepts; relational model |
Oct 2 |
2, 3 |
relational model (cont'd), SQL |
Oct 9 |
3,4,5 |
SQL views, complex types, integrity, Datalog |
Oct 16 |
6, 7 |
E-R model, normal forms |
Oct 23 |
7 |
normal forms (cont'd), midterm review |
Oct 30 |
9 |
Object-based DB |
Test
1 Thursday, Nov 2 |
Nov 6 |
12 |
Indexes, B+ tree, hashing |
Nov 13 |
10, 14 |
XML, query processing and optimization |
Final
Project Part 1: Thu, Nov 16 |
Nov 20 |
15 |
transactions |
Nov 27 |
16 |
concurrency control, final review |
|
Dec 4 |
|
finals week; |
Test
2 Wed, Dec 6, 1pm-3pm; Final
Project Part 2: Fri, Dec 8 (Email submission) |