| Assignments | ||||
| Week | Content | Reading | Assign | Due |
| Jan 7-9 (1) | Course Overview, Intro to Databases | 1.1-1.6 | ||
| Introduction to Entity Relationship Diagrams | 2.1-2.4 (Q1) | |||
| Jan 12-16 (2) | Entity Relationship Diagram Examples | 2.5, 2.8-2.9 | ||
| Additional ERD Examples, Revised | ||||
| Relational Model | 3.1-3.9 (Q2) | HW#2 | HW#1 | |
| Jan 19-23 (3) | Relational Model (Translation Examples) | |||
| Relational Algebra | 4.1-4.5 (Q3) | |||
| Relational Algebra | ||||
| Jan 26-30 (4) | SQL (Access Files) | 5.1-5.10 (Q4) | HW#3 | HW#2 |
| SQL | ||||
| SQL | ||||
| Feb 2-6 (5) | SQL | |||
| Schema Design and Normal Forms | 19.1-19.10 (Q10) | HW#6 | HW#3 | |
| Schema Design and Normal Forms | ||||
| Feb 9-13 (6) | Schema Design and Normal Forms | |||
| Query Evaluation | 12.1-12.7 (Q11) | |||
| Query Evaluation | ||||
| Feb 16-20 (7) | Query Evaluation | |||
| Transaction Management | 16.1-16.8 (Q12) | HW#7 | HW#6 | |
| Transaction Management | ||||
| Feb 23-27 (8) | Transaction Management/Review | |||
| Midterm | HW#7 | |||
| Study Day | ||||
| Mar 2-6 (9) | Spring Break - No Class | |||
| Mar 9-13 (10) | Database Applications | 6.1-6.6 (Q5) | HW#8 | |
| Database Applications | ||||
| Database Applications Lab | ||||
| Mar 16-20 (11) | Database Applications Lab | |||
| Project Intro | Project (orig) | |||
| File Organization and Indexing | HW#4 | HW#8 | ||
| Mar 23-27 (12) | File Organization and Indexing | 8.1-8.6 (Q6) | Project ERD | |
| Project Lab | ||||
| Disks and Files | 9.1-9.8 (Q7) | |||
| Mar 30-Apr 3 (13) | Disks and Files | Project Schema | ||
| Project Lab | ||||
| Tree-Based Indexing (B+ Tree Demo) | 10.1-10.9 | HW#5 | HW#4 | |
| Apr 6-10 (14) | Tree-Based Indexing | (Q8) | ||
| Project Lab | Database and Queries | |||
| Easter Break - No Class | ||||
| Apr 13-17 (15) | Easter Break - No Class | |||
| Hash-Based Indexing | 11.1-11.5 (Q9) | |||
| Hash-Based Indexing | Initial Web App | |||
| Apr 20-24 (16) | Database Tuning | 20.1-20.13 (Q13) | HW#5 | |
| Project Lab | ||||
| HW Day/Project Demonstrations | Completed Web App | |||
| Apr 27-May 1 (Exam Week) | Review | |||
| Final Exam (ENS 240, Apr 29, 1-3PM) | ||||