Daily Schedule for 444


(Subject to change)

January 5Introduction
SQL basics

SQL For Web Nerds, Chapter 3
SQL Basics
Section 6.1-6.2
January 12 Advanced SQL
HW#1 distributed
Section 6.3-6.4
SQL Schema Creation

Section 6.5-6.6
Section 6.7
January 19 Martin Luther King, Jr. Day Constraints and Triggers
HW#1 due; 
Chapter 7
Programming and Transactions
Chapter 8
January 26 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 2 Functional Dependencies
Section 3.6
Relational Decomposition and Relational Algebra
Section 5.1-5.2
Relational Algebra and Project Discussion
Section 5.2
February 9 XML
Section 4.7
HW#2 due
Querying XML Web services
February 16Presidents' Day Project discussion
Project Phase II Part 1&2 due
Querying XML (cont)
Project Phase II due
HW#3 distributed
February 23DBMS Internals
Project Phase II Part 3 due
Storage and Indexing
Section 13.1
Section 13.2-13.3
March 1Query Execution
Query Execution (cont.)
HW#3 due; HW#4 distributed
Query Optimization
March 8 Query Optimization (cont.) Query Optimization (cont.)
Phase III due
HW#4 due
March 15FINAL EXAM (2:30-4:30)