Office Hours: Monday
2:30 PM – 4:00 PM and Wednesday 11:30 AM – 1:00 PM
Office Location: Center for Advanced Research Computing
CARC Office: 1000 D
1601 Central Ave. NE
Albuquerque, NM 87106
Week of | Topic | Reading |
---|---|---|
1/16 | Introduction; Relational Model; E/R Model | Chs 1,2,4 |
1/23 | E/R Model; Functional Dependencies | Chs 4, 3 |
1/30 | Functional Dependencies, Normalization | Ch 3 |
2/6 | Relational Algebra | Chs 2, 5 |
2/13 | SQL & Transactions | Chs 6, 2, 8 |
2/20 | SQL in a Webserver | Chs 9 |
2/27 | Constraints and Triggers + Exam | Chs 7, 8 |
3/6 | More on SQL | Ch 7 |
3/13 | Spring Break - No Class | n/a |
3/20 | Data Storage and Representation | Ch 13 |
3/27 | Index Structures | Ch 14 |
4/03 | Query Execution + Exam | Ch 15 |
4/10 | Query Compiler | Ch 16 |
4/17 | Coping with Failures | Ch 17 |
4/24 | Concurrency Control | Ch 18 |
5/01 | Project Presentations + Exam | n/a |