Week of | Monday | Wednesday | Friday |
September 25 | Introduction
Chapter 1 |
Database Design
Section 2.1, 2.2, 2.3 |
Databases Design
Section 2.4, 2.5, 2.6 |
October 2 | The Relational Data Model
3.1, 3.2, 3.3, 3.4 |
Functional Dependencies
3.5 |
Functional Dependencies
3.5, 3.6, 3.7 Homework 1 due Project groups decided |
October 9 | Normal Forms
3.7, 3.8 |
XML Data
|
Relational Algebra
4.1 |
October 16 | Datalog
4.2, 4.3 Preliminary Project proposals due |
SQL
5.1, 5.2, 5.3, 5.4 | SQL
5.4, 5.5, 5.6, 5.7, 5.8 Homework 2 due |
October 23 | SQL
5.7.7, 5.9, 6.1, 6.2 Project E/R diagrams and schemas due |
SQL
5.9, 6.1, 6.2 |
Querying XML
Homework 3 due |
October 30 |
Midterm | Systems Aspects of SQL
7.1, 7.2 |
Java, JDBC, Perl, CGI, Embedded SQL
Project formal specifications due |
November 6 | DBMS Overview, Data Storage
1.1-1.2.5-8.6 |
Representing Data Elements 2.3.3-2.3.5, 3 Homework 4 due |
Holiday |
November 13 | Indexing
8.5-8.6 |
Indexing
Vol 2: 1.1,1.2,1.3,2.1 |
Query Exectution
Chapter 4 Project sample end-to-end application due |
November 20 | Query Execution
|
Query Execution
Homework 5 due |
Thanksgiving
Vacation |
November 27 | Optimization
Skim 7.1 Read 7.2.1, 7.3-7.7 (but not 7.6.6) |
Optimization | Optimization |
December 4 | Optimization
Chapter 8 Homework 6 due |
Optimization | FINAL EXAM |