Note that this schedule will be altered during the quarter. Please make sure to check it every week.
Week of |
Monday |
Wednesday |
Friday |
October 1 |
Introduction |
Database Design 2.1, 2.2, 2.3 |
Project and Systems Overview - |
October 8 |
Database Modeling 2.4, 2.5, 2.6 |
Relational Model 3.1-3.4 |
Funct Dependencies & Rel Schema 3.5,3.7 |
October 15 |
Normal Forms, Rel Algebra 3.7, 3.8, 4.1 Project Milestone 1 |
Relational Algebra 4.1,4.6 |
Relational Algebra & Datalog 4.1,4.2-4.4 Homework 1 Due |
October 22 |
XML Data on the Web 3.1,3.2 Project Milestone 2 |
XML cont Data on the Web 8.2.1,8.3.1 |
SQL 5.1-5.4 |
October 29 |
SQL cont 5.3-5.8 Project Milestone 3 Homework 2 Due |
More SQL |
Even more SQL |
November 5 |
MIDTERM |
XPath and XQuery Homework 3 Due |
DBMS Overview; Data Storage |
November 12 |
Veteran’s Day Holiday |
Representing Data Elements Project Milestone 4 |
Indexes |
November 19 |
B Trees Project
Milestone 5 |
Hash Tables and Query Exec Homework 4 Due |
Thanksgiving Holiday |
November 26 |
Query Execution Project Milestone 6 |
Query Execution (con't) |
Query Exec / Optimization Homework 5 Due |
December 3 |
Query Optimization |
Query Optimization (con't) |
Recovery |
December 10 |
Transaction Processing PROJECT DEMOS Homework 6 Due (Tuesday) |
Final Lecture Last day of instruction |
FINAL EXAM (2:30pm) |