Tentative Schedule (MW: 4:00 – 5:15)

 


Week

Date

Topic

Slides

Comments

1

Wed 01/17/07

Ch. 1: Overview of Database Systems

 

 

2

Mon 01/22/07

Ch. 2: ER Model

 

 

Wed 01/24/07

Ch 3: Relational Model

 

 

3

Mon 01/29/07

Ch 4: Relational Algebra

 

 

Wed 01/31/07

Ch 5: SQL Queries

 

Hw 1 Out

4

Mon 02/05/07

Ch 8: Overview of Storage and Indexing

 

 

Wed 02/07/07

Ch 9:Data Storage

 

 

5

Mon 02/12/07

Ch 9:Data Storage

 

Lab 1 Out

Wed 02/14/07

Ch 10:Tree Indexes

 

Hw 1 Due

6

Mon 02/19/07

Ch 10:Tree Indexes

 

Hw 2 Out

Wed 02/21/07

Ch 11:Hash Indexes

 

 

7

Mon 02/26/07

Ch 11:Hash Indexes

 

 

Wed 02/28/07

Midterm Exam 1

 

 

8

Mon 03/05/07

Ch 12:Overview of Query Evaluation

 

Lab 1 Due

Wed 03/07/07

Ch 13: External Sorting

 

Hw 2 Due / Lab 2 Out

9

Mon 03/12/07

Spring Break

 

 

Wed 03/14/07

Spring Break

 

 

10

Mon 03/19/07

Ch 13: External Sorting

 

 

Wed 03/21/07

Ch 14: Evaluation of Relational Operators

 

Hw 3 Out

11

Mon 03/26/07

Ch 14: Evaluation of Relational Operators

 

 

Wed 03/28/07

Ch 15: A Typical Relational Optimizer

 

Lab 2 Due / Lab 3 Out

12

Mon 04/02/07

Ch 15: A Typical Relational Optimizer

 

 

Wed 04/04/07

Ch 16:Overview of Transaction Management

 

 

13

Mon 04/09/07

Ch 17: Concurrency Control

 

Hw 3 Due

Wed 04/11/07

Ch 17: Concurrency Control

 

Hw 4 Out

14

Mon 04/16/07

Midterm Exam 2

 

Lab 3 Due

Wed 04/18/07

Ch 18: Crash Recovery

 

Lab 4 Out

15

Mon 04/23/07

Ch 18: Crash Recovery

 

 

Wed 04/25/07

Advanced Topics

 

 

16

Mon 04/30/07

Advanced Topics

 

Hw 4 Due

Wed 05/02/07

Advanced Topics

 

Lab 4 Due