Week | Topic | Material/Readings |
week 1 (Aug 23) |
Organizational Details. Introduction: Why DBMSs? |
chap. 1 |
week 2 (Aug 28/30) |
Database Design/Modeling. | chap. 2. |
week 3 (Sep 4/6) |
Relational Data Model Design Translation. SQL DDL. PROJECT-DISCUSSION. |
chap. 3. |
week 4 (Sep 11/13) |
DB Languages: Relational Algebra; Relational Calculus. |
chap. 4. |
week 5 (Sep 18/20) |
DB Querying: SQL. Constraints and Triggers. PROJECT-INTENT DUE. |
chap. 5. |
week 6 (Sept 25/27) |
SQL SQL Examples |
chap. 5/6/7. |
week 7 (Oct 2/4) |
Triggers DB App. Development. PROJECT-PROPOSAL DUE. |
chaps. 19. |
week 8 (Oct 9/11) |
Views Functional Dependencies. |
chap 8/9/10/11. |
week 9: (Oct 16/18) |
TERM BREAK | - |
week 10 (Oct 23/25) |
Normalization. Indexing |
chap 19/8/9/10. |
week 11 (Oct 30/Nov1) |
MIDTERM (TU) Storage/Indexing. |
chap. 10/11. |
week 12 (Nov 6/8) |
Tree-Based Indexing. Hash Indexing. PROJECT-PROGRESS DUE. |
chap. 10,11. |
week 13 (Nov 13/15) |
Data-Intesive Processing/Sorting/Buffering. Join Processing Algorithms. |
chap. 12,13. |
week 14 (Nov 20/22) |
THANKSGIVING BREAK |
- |
week 15 (Nov 27/29) |
Physical Query Plans. Query Optimization: Costing/Ordering. |
chap. 14/15. |
week 16 (Dec 4/6) |
Transaction Management. Concurrency Control. |
chap. 17-19. |
week 17 (Dec 11/13) |
FINAL EXAM (TU). IN-CLASS FINAL PROJECTS (TH) (3pm - 6pm in FL320) |
. |