Week # | Main topic | Monday | Wednesday | Friday |
1 | Introduction and DB modeling
|
Sep 28: Introduction and welcome. What is a database? | Sep 30: No classes | Oct 2: ODL modeling |
2 | More modeling and good DB design | Oct 5: E/R modeling | Oct 7: Modeling constraints | Oct 9: Principles of good DB design |
3 | The relational data model and going to a DB schema | Oct 12: The relational data model | Oct 14: From E/R models to relational schema | Oct 16: Normalization |
4 | Relational algebra | Oct 19: More on normalization | Oct 21: Relational algebra | Oct 23: SQL preliminaries |
5 | SQL | Oct 26: ASP/SQL Server instruction | Oct 28: SQL quirks | Oct 30: SQL- schemas, views, nulls,... |
6 | SQL | Nov 2: MIDTERM EXAM | Nov 4: Constraints and triggers. | Nov 6: Embedded SQL |
7 | Recursion
|
Nov 9: Recursion (datalog) | Nov 11: No classes | Nov 13: Recursion in SQL3 |
8 | Object orientation | Nov 16: Object Query Language | Nov 18: OQL | Nov 20: Objects in SQL3 |
9 | Data storage | Nov 23: Data storage | Nov 25: Storage (continued) | Nov 27: No classes |
10 | Optimization and transaction processing | Nov 30: Query optimization | Dec 2: Query optimization (cont'd) | Dec 4: Transaction processing |
11 | Transaction processing and advanced topics | Dec 7: Transaction processing | Dec 9: Advanced topics (data integration, data mining) | |
FINAL EXAM
Wednesday Dec 16 |