1. M 01/23: Introduction (Ch 1) 2. W 01/25: Database concepts, architecture (Ch 2) 3. M 01/30: Relational model, SQL (Ch 3,4) 4. W 02/01: Relational algebra, Tuple relational calculus, SQL (Ch 4,5,6) 5. M 02/06: More queries, SQL programming (Ch 4,5,6) 6. W 02/08: SQL programming with Perl, PHP, Preventing injection attacks (Ch 13,14) 7. M 02/13: Entity relationship model (Ch 7) 8. W 02/15: Enhanced ER model (Ch 7,8), Examples of ER/EER design 9. M 02/20: Mapping from ER/EER to Relational model (Ch 9) 10. W 02/22: XML (Ch 12), Information systems and DB processes (10.1-10.2) 11. M 02/27: Database design theory: Guidelines, Functional dependencies (Ch 15) 12. W 02/29: Minimal covers, First and Second Normal forms (Ch 15) 13. M 03/05: Review for midterm exam 14. W 03/07: Midterm Exam 15. M 03/19: Case studies 16. W 03/21: Case studies 17. M 03/26: Third normal form (Ch 15), examples 18. W 03/28: Minimal cover, Lossless join test, more examples 19. M 04/02: BCNF, PHP 20. W 04/04: Disk storage 21. M 04/09: Heap files, Sorted files, Operations on files 22. W 04/11: Index files, B-Trees 23. M 04/16: Query processing and optimization 24. W 04/18: Heuristic optimization algorithm 25. M 04/23: Database tuning, Transaction processing: schedules and serializability 26. W 04/25: Concurrency control; locks, 2PL, Timestamp based methods 27. M 04/30: Locks, Deadlocks, Variations of 2PL, Recovery, Security 28. W 05/02: Security, Data mining 29. W 05/09 (5 PM): Final exam