CS 347: Relational Database Systems
Schedule (Tentative)

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

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

Chapter 9
4 Monday 9/22 Storing data: Disks and Files
Database Design and Entity-Relationship Model
 Chapter 9
Chapter 2
5 Wednesday 9/24

Database Design and Entity-Relationship Model
Relational Model 

Chapter 2
Chapter 3
6 Friday 9/26 Relational Model
Relational Algebra, Relational Calculus
 Chapter 3
Chapter 4
7 Monday 9/29

Relational Algebra, Relational Calculus

 Chapter 4
8 Wednesday 10/1

Minibase Assignment 1 Due
Minibase Assignment 2 Given
Relational Algebra, Relational Calculus
SQL

 Chapter 4
Chapter 5
9 Friday 10/3
 SQL Chapter 5
10 Monday 10/6 Storage and Indexing
Written Homework 1 Given
Chapter 8
11 Wednesday 10/8

Storage and Indexing

Chapter 8
12 Friday 10/10 Storage and Indexing
Tree Structured Indexing
Written Homework 1 Due 		Chapter 8
Chapter 10
13 Monday 10/13

Tree Structured Indexing

 Chapter 10
14 Wednesday 10/15 Minibase Assignment 2 Due
Take Home Exam 1 Assigned
Hash Based Indexing 		Chapter 11
15 Friday 10/17

Take Home Exam 1 Due
Hash Based Indexing
Overview of Query Evaluation

 Chapter 11
Chapter 12
  Monday 10/20 BREAK  
16 Wednesday 10/22 Oracle Assignment Given
Overview of Query Evaluation
External Sorting		 Chapter 12
Chapter 13
17 Friday 10/24

External Sorting
Evaluation of Relational Operators

Chapter 13
Chapter 14
18 Monday 10/27 Evaluation of Relational Operators Chapter 14
19 Wednesday 10/29

Oracle Assignment Due
Minibase Assignment 3 Given
Evaluation of Relational Operators

Chapter 14
20 Friday 10/31

Query Optimization

Chapter 15
21 Monday 11/3 Query Optimization
 Chapter 15
22 Wednesday 11/5

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


Chapter 15
Chapter 19
23 Friday 11/7

Schema Refinement and Normal Forms

Chapter 19
24 Monday 11/10

Schema Refinement and Normal Forms

Chapter 19
25 Wednesday 11/12 Written Homework 2 Due
Transaction Management
 Chapter 16
26 Friday 11/14 Transaction Management
 Chapter 16
27 Monday 11/17 Minibase Assignment 4 Due
Object Database Systems 		Chapter 23
28 Wednesday 11/19

Take Home Exam 2 Assigned
Slack

 
Last Day of Finals Monday 11/24 Take Home Exam 2 Due