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 |