COMP 3421, Winter 2014, Outline

Note, timing of topics covered is approximate, we will likely vary from these dates.
Date Due Topic
1/7 Intro, DB Design, Data Modeling, ER Model
1/9 ER Model
1/14 A1 due Relational Model, Relational Algebra
1/16 Relational Algebra Queries
1/21 SQL
1/23 A2 due SQL (aggregates)
1/28 SQL (triggers, referential integrity)
1/30 SQL, scripting
2/4 A3 due Dependencies
2/6 Normalization
2/11 Normalization
2/13 File System Overview, Buffer Management, Storage Devices
2/18 A4 due MIDTERM
2/20 Physical Organization of Records and Blocks
2/25 Index, B+ trees
2/27 A5 due B+ and B trees
3/4 H1 due OO DBMSs
3/6 A6 due OO DBMSs
3/11 FINAL
3/13 No class