Daily Schedule for 444

Note that this schedule will be altered during the quarter. Please make sure to check it every week.

Key:

 

Week of

Monday

Wednesday

Friday

October 1

Introduction
Chapter 1

ppt html ps

Database Design

2.1, 2.2, 2.3

ppt html ps

Project and Systems Overview

-

ppt html ps

October 8

Database Modeling 

2.4, 2.5, 2.6

ppt html ps

Relational Model

3.1-3.4

ppt html ps

Funct Dependencies & Rel Schema

3.5,3.7

ppt html ps

October 15

Normal Forms, Rel Algebra      3.7, 3.8, 4.1

ppt html ps 

Project Milestone 1

Relational Algebra

4.1,4.6

ppt html ps

Relational Algebra & Datalog

4.1,4.2-4.4

ppt html ps

Homework 1 Due

October 22

XML

Data on the Web 3.1,3.2

ppt html ps

Project Milestone 2 

XML cont

Data on the Web 8.2.1,8.3.1

ppt html ps

 

SQL

5.1-5.4

ppt html ps

October 29

SQL cont

5.3-5.8

Project Milestone 3

ppt html ps

Homework 2 Due

More SQL

ppt html ps

Even more SQL

ppt html ps

November 5

 

MIDTERM

 

XPath and XQuery

ppt html ps

Homework 3 Due

DBMS Overview; Data Storage

ppt html ps

 

November 12

 

Veteran’s Day Holiday

 

Representing Data Elements

Project Milestone 4

ppt html ps

Indexes

ppt html ps

 

November 19

B Trees

ppt html ps

Project Milestone 5

Hash Tables and Query Exec

ppt html ps

Homework 4 Due

 

Thanksgiving Holiday

 

November 26

Query Execution

ppt html ps

Project Milestone 6

Query Execution (con't)

ppt html ps

 

Query Exec / Optimization

Homework 5 Due

ppt html ps

December 3

Query Optimization

ppt html ps

Query Optimization (con't)

ppt html ps

Recovery

ppt html ps

 

December 10

 

Transaction Processing

ppt html ps

PROJECT DEMOS

Homework 6 Due (Tuesday)

Final Lecture

ppt html ps

Last day of instruction

FINAL EXAM  (2:30pm)