Lecture #

Topic

Reading

Assignments

1

Welcome and Introduction

Ch. 1


Discussion

Java Tutorial



2

ER Model

Ch. 2


3

Relational Model

Ch. 3

Homework 1 Out.
Project 1 Out.

Discussion

Project 1 Intro



4

ER to Relational

Ch. 3


5

Relational Algebra

Ch. 4

Homework 1 due at 11:55PM

Discussion

HW 1 Soln; Project 1 issues



6

Relational Algebra(contd.) + Relational Calculus

Ch. 4

Homework 2 Out

7

SQL

Ch. 5

Project 1 due at 11:55PM

Discussion

JDBC and Project 2 discussion


Project 2 Assigned

8

SQL (contd.) and Triggers

Ch. 5


9

Database Application Pogramming

Ch. 6, except 6.4 and 6.5

Homework 2 due at 11:55PM

Discussion

HW 2 solutions, Open topics

Read SQL Handout


10

Normalization

Ch. 19 except 19.8, and Ch. 20.720.9


11

Wrap up for First Half


Project 2 due at 11:55PM

Discussion

Exam Review



12

Disks and Files

Ch. 9, except 9.2


First Exam (79pm, location TBA)




Discussion

Postgres Overview



13

Storage & Indexing

Ch. 8


14

Storage & Indexing (contd)



Discussion

Exam solutions



No Class




No Class




No Class



Homework 3 Out (on March 9)

15

Treestructured Indexing

Ch. 10 except 10.8.1


16

Hashbased Indexing

Ch. 11


Discussion

Problems on indexing


Project 3 assigned

17

Query Evaluation

Ch. 12 and 14


18

Sorting

Ch. 13

Homework 3 due on March 19 at 11:55PM

Discussion

Homework 3 solutions



19

Query evaluation

Ch. 12 Ch. 14

Homework 4 assigned

20

Query Evaluation

Ch. 12 Ch. 14


Discussion

Query evaluation review



21

Query Optimization

Ch. 15

Project 3 due on March 30th at 11:55pm. Project 4 out on March 31.

22

Transactions

Ch. 16, except 16.6; Ch. 17, up to and including 17.4

Homework 4 due on April 2 at 11:55pm.

Discussion

Project 4 intro and page counting, Homework 4 solutions



23

Transactions (contd.)

Ch. 18, except 18.6 and 18.8

Homework 5 assigned

24

Transactions (contd.)



Discussion

Open Topics



25

Open Topics


Homework 5 due at 11:55pm

26

Review



Discussion

Homework 5 solutions, Review


Project 4 due at 11:55pm

TBA




Second Exam (10:30am12:30pm, locatoin TBA)



