Week #  Main topic  Monday  Wednesday  Friday 
1  Introduction and DB modeling

Jan 5: Introduction and welcome. What is a database?  Jan 7: ODL modeling  Jan 9: E/R modeling 
2  More modeling and the relational data model  Jan 12: Modeling constraints  Jan 14: Principles of good DB design  Jan 16: The relational data model 
3  From a DB design to a DB schema  Jan 19: No classes  Jan 21: From E/R models to relational schema  Jan 23: Normalization 
4  Relational algebra  Jan 26: More on normalization  Jan 28: Relational algebra  Jan 30: Concepts of data storage 
5  Storage and optimization  Feb 2: Concepts of storage (continued)  Feb 4: MIDTERM EXAM  Feb 6: Concepts of query optimization 
6  SQL  Feb 9: Concepts of query optimization (cont'd)  Feb 11: SQL preliminaries  Feb 13: SQL quirks 
7  SQL

Feb 16: No classes  Feb 18: SQL schemas, views, nulls,...  Feb 20: Constraints and triggers. 
8  Transaction processing  Feb 23: Concepts of transaction processing  Feb 25: Concepts of transaction processing  Feb 27: Embedded SQL 
9  Recursion  Mar 2: Recursion (datalog)  Mar 4: Recursion in SQL3  Mar 6: Object Query Language 
10  Object orientation, advanced topics  Mar 9: OQL  Mar 11: Objects in SQL3  Mar 13: Advanced topics (data integration, data mining) 
FINAL EXAM
Monday March 16 