| Week |
Day |
Topic |
Reading
Assignment |
Notes |
1
1/19
to
1/23 |
Mon. |
Introduction |
Syllabus, Ch. 1 |
|
| Tues. |
Overview |
Chapter 2
omit 2.10 on UML |
HW 1 Out |
| Wed. |
Entity-Relationship Data Model |
|
|
| Fri. |
|
|
|
2
1/26
to
1/30 |
Mon. |
MLK Day Observed; no class |
|
|
| Tues. |
Relational Data Model |
Chapter 3
Sec. 3.1 to 3.5 |
HW 1 Due;
HW 2 Out (pdf) |
| Wed. |
|
|
|
| Fri. |
|
Chapter 3
Sec. 3.6, 3.7 |
|
3
2/2
to
2/6 |
Mon. |
|
|
|
| Tues. |
|
|
|
| Wed. |
|
|
HW 2 Due
|
| Fri. |
SQL |
Chapter 4
Sec. 4.1 to 4.7 |
Project Proposal Due |
4
2/9
to
2/13 |
Mon. |
|
Chapter 4
Sec. 4.8 to 4.15 |
HW 3 Out (pdf) |
| Tues. |
|
|
|
| Wed. |
|
|
|
| Fri. |
|
|
|
5
2/16
to
2/20 |
Mon. |
|
|
HW 3 Due |
| Tues. |
Midterm 1 |
|
|
| Wed. |
Relational Database Design |
Chapter 7
Sec. 7.1 to 7.6 |
|
| Fri. |
|
|
Project Phase 3 Draft Design |
6
2/23
to
2/27 |
Mon. |
|
Chapter 7
Sec. 7.7 to 7.11 |
|
| Tues. |
|
|
|
| Wed. |
Functional Dependencies |
|
|
| Fri. |
Canonical Covers |
|
Project Phase 3 Design Turn-in HW4 Out: 7.2, 7.4, 7.7,
7.11, 7.12, 7.16 |
7
3/1
to
3/5 |
Mon. |
Normal Forms |
|
|
| Tues. |
|
|
|
| Wed. |
|
|
HW 4 Due by 2am. |
| Fri. |
|
|
|
8
3/8
to
3/12 |
Mon. |
Storage and File Structure |
Chapter 11 |
|
| Tues. |
|
|
|
| Wed. |
Indexing and Hashing |
Chapter 12 |
|
| Fri. |
|
|
|
| March 15 - 19: Spring Break |
9
3/22
to
3/26 |
Mon. |
Query Processing |
Chapter 13 |
|
| Tues. |
Query Optimization |
Chapter 14 |
|
| Wed. |
Transactions |
Chapter 15 |
|
| Fri. |
|
|
|
10
3/29
to
4/2 |
Mon. |
Concurrency Control |
Chapter 16 |
|
| Tues. |
|
|
|
| Wed. |
|
|
|
| Fri. |
Midterm 2 |
|
|
11
4/5
to
4/9 |
Mon. |
Recovery System |
Chapter 17 |
|
| Tues. |
|
|
|
| Wed. |
|
|
|
| Fri. |
|
|
|
12
4/12
to
4/16 |
Mon. |
Database System Architectures |
Chapter 18 |
|
| Tues. |
|
|
|
| Wed. |
|
|
|
| Fri. |
|
|
|
13
4/19
to
4/23 |
Mon. |
Distributed Databases |
Chapter 19 |
|
| Tues. |
|
|
|
| Wed. |
|
|
|
| Fri. |
|
|
|
14
4/26
to
4/30 |
Mon. |
Parallel Databases |
Chapter 20 |
|
| Tues. |
|
|
|
| Wed. |
|
|
|
| Fri. |
Integrity and Security |
Chapter 6 |
|
| 5/3 |
Mon. |
|
|
Project Due |
