| 1 |
01/12 |
Introduction
Chapters 1 and 2 |
|
| 2 |
01/19 |
The Relational Model
Chapter 3 |
Project Teams Due
Topic Selection Due
github usernames provided |
| 3 |
01/26 |
Basic SQL
Chapter 4 |
|
| 4 |
02/02 |
More SQL
Chapter 5 |
|
| 5 |
02/09 |
Relational Algebra and Relational Calculus
Chapter 6 |
Project Proposals Due |
| 6 |
02/16 |
Data Modeling
Chapters 7–10 (emphasis on Chapter 8) |
SQL Assignment Due |
| 7 |
02/23 |
Functional Dependencies and Normalization
Chapter 15 |
Initial Project Schema Due |
| 8 |
03/02 |
Further Dependencies
Chapter 16 |
|
| 9 |
03/09 |
Storage, Indexing and Hashing
You're Probably Storing Passwords Incorrectly
http://www.codinghorror.com/blog/2007/09/youre-probably-storing-passwords-incorrectly.html
Chapters 17 and 18 |
Normalization Assignment Due
Schema Critiques Due (3/14) |
| 10 |
03/16 |
Spring Break—no classes. |
|
| 11 |
03/23 |
Database Connectivity
Chapters 13 and 14 |
|
| 12 |
03/30 |
Query Processing/Database Security
Chapters 19 and 24 |
Indexing Assignment Due |
| 13 |
04/06 |
Object Databases and Spatial Databases
Chapter 11 and Handout |
|
| 14 |
04/13 |
Project Presentations |
All Projects Due |
| 15 |
04/20 |
Project Presentations |
|