CS 395: Relational Database Systems
Schedule (Tentative)

 
Day of Term Day of Week Date Topics Readings to be done in advance of this class
1 Monday 4/1/02 C++ Warmup Assignment Given
Introduction to course
Introduction to databases		 Chapter 1
2 Wednesday 4/3/02 Storing data: Disks and Files Chapter 7
3 Friday 4/5/02

C++ Warmup Assignment Due
Minibase Assignment 1 Given
Storing data: Disks and Files

Chapter 7
4 Monday 4/8/02 Storing data: Disks and Files
File Organizations and Indexes		 Chapter 7
Chapter 8
5 Wednesday 4/10/02

File Organizations and Indexes

Chapter 8
6 Friday 4/12/02 File Organizations and Indexes
Tree-Structured Indexing		 Chapter 8
Chapter 9
7 Monday 4/15/02

Tree Structured Indexing

 Chapter 9
8 Wednesday 4/17/02

Minibase Assignment 1 Due
Minibase Assignment 2 Given
Tree Structued Indexing
Relational Model, Relational Algebra

 Chapter 9
Chapter 3.1-3.2, Chapter 4.1-4.2
9 Friday 4/19/02 Relational Algebra, Relational Calculus Chapter 4.2-4.3
10 Monday 4/22/02 Relational Calculus
Entity-Relationship Model
Written Homework 1 Given
Chapter 4.3
Chapter 2
11 Wednesday 4/24/02

Entity-Relationship Model
Relational Model

Chapter 2

Chapter 3.3-3.7
12 Friday 4/26/02 Relational Model
Written Homework 1 Due 		Chapter 3.3-3.7
13 Monday 4/29/02

Hash Based Indexing

Chapter 10
14 Wednesday 5/1/02 Minibase Assignment 2 Due
Take Home Exam 1 Assigned
Hash Based Indexing 		Chapter 10
15 Friday 5/3/02

Take Home Exam 1 Due
Hash Based Indexing
SQL

Chapter 5
  Monday 5/6/02 BREAK  
16 Wednesday 5/8/02 Oracle Assignment Given
SQL
External Sorting		 Chapter 5
Chapter 11
17 Friday 5/10/02

Comps (for seniors) on Saturday
 External Sorting
Evaluation of Relational Operators

Chapter 11
18 Monday 5/13/02 Evaluation of Relational Operators Chapter 12
19 Wednesday 5/15/02

Oracle Assignment Due
Minibase Assignment 3 Given
Evaluation of Relational Operators

Chapter 12
20 Friday 5/17/02

Query Optimization

Chapter 13
21 Monday 5/20/02 Query Optimization
 Chapter 14
22 Wednesday 5/22/02

Minibase Assignment 3 Due
Written Homework 2 Given
Minibase Assignment 4 Given
Query Optimization
Schema Refinement and Normal Forms


Chapter 14
Chapter 15
23 Friday 5/24/02

Schema Refinement and Normal Forms

Chapter 15
24 Monday 5/27/02

Schema Refinement and Normal Forms

Chapter 15
25 Wednesday 5/29/02 Written Homework 2 Due
Physical Database Design and Tuning		 Chapter 16.1-16.2
26 Friday 5/31/02 Transaction Management Overview Chapter 18
27 Monday 6/3/02 Minibase Assignment 4 Due
Object Database Systems 		Chapter 25
28 Wednesday 6/5/02

Take Home Exam 2 Assigned
Slack

 
Last Day of Finals Monday 6/10/02 Take Home Exam 2 Due