Daily Schedule for 444


(Subject to change)

Week ofMonday Wednesday Friday
January 6 Introduction
Guest lecturer: Dan Suciu
SQL basics
Guest lecturer: Rachel Pottinger
XML Info sheet due
SQL For Web Nerds, Chapter 3
SQL Basics
Section 6.1-6.2
January 13 Advanced SQL
HW#1 distributed
Section 6.3-6.4
SQL Schema Creation
Project schema due
Section 6.5-6.6
Section 6.7
January 20 Martin Luther King, Jr. Day Constraints and Triggers
HW#1 due; 
Chapter 7
Programming and Transactions
Chapter 8
January 27 Conceptual Database Design
Section 2.1, 3.2
HW#2 distributed
E/R Diagrams and Relational Model
Section 2.2-2.4, 3.1, 3.3
Project Phase I due
Functional Dependencies
Section 3.4-3.5
February 3 Functional Dependencies
Section 3.6
Relational Decomposition and Relational Algebra
Section 5.1-5.2
Relational Algebra and Project Discussion
Section 5.2
February 10 XML
Section 4.7
HW#2 due
Querying XML Web services
February 17 Presidents' Day Project discussion
Project Phase II Part 1&2 due
Querying XML (cont)
Project Phase II due
HW#3 distributed
February 24 DBMS Internals
Project Phase II Part 3 due
Storage and Indexing
Section 13.1
Section 13.2-13.3
March 3 Query Execution
Query Execution (cont.)
HW#3 due; HW#4 distributed
Project Phase III Part 1 due
Query Optimization
March 10 Query Optimization (cont.) Query Optimization (cont.)
HW#4 due
Project Phase III Part2 due
March 17 FINAL EXAM (2:30-4:30)