Class Schedule and Lecture Notes:

This schedule is subject to change so check it frequently.  In particular, check for changes to due dates and guest lectures.    

Note: in general, the pdf files are smaller (in bytes) than the ppt files.

WK

Lec#

Class/Date

Topic

Book Chapter

Events

Lecture  Notes

1

1

T 8/26

Introduction

1

  ppt  pdf
2

Th 8/28

The Relational Model

3

  ppt  pdf

2

3

T 9/2

Introduction to the ER Model
Storing Data: Disks and Files
2 (skim)
9
  ppt  pdf
4

Th 9/4

Relational Algebra
4 Homework 0 Due
ppt  pdf

3

5

T 9/9

File Organization and Indexing
8
  ppt  pdf
6

Th 9/11

Relational Calculus
4

ppt  pdf

4

7

T 9/16

SQL  I
5

ppt  pdf
8

Th 9/18

Query Evaluation 1:
Sorting & Joining
12, 13, 14
Homework 1 Due ppt  pdf

5

9

T 9/23

Query Evaluation 2:
Optimizing Queries
12, 13, 14
  ppt  pdf
10

Th 9/25

SQL 2
5

ppt  pdf

6

11

T 9/30

The ER Model 2
  ppt  pdf
12

Th 10/2

ER -> Relational Mappings 2, 3

ppt  pdf

Su 10/5

Homework 2 Due

7

13

T 10/7

Functional Dependencies and Normalization
19
ppt pdf
14

Th 10/9

FDs and Normalization (cont.)
Midterm Review
19
  ppt pdf
ppt pdf

8

15

T 10/14

Internet Applications 7
Midterm Exam 6-8pm
ppt pdf
16

Th 10/16

Database Applications 6

ppt pdf

9

17

T 10/21

Tree-Structured Indexes 10

ppt pdf
18

Th 10/23

Hash-Based Indexes 11

ppt pdf

10

19

T 10/28

Introduction to Transactions

16

ppt pdf
20

Th 10/30

Concurrency Control 17

ppt pdf

Su 11/2

Homework 3 Due

11

21

T 11/4

Logging and Recovery

18
  ppt pdf
22

Th 11/6

Concurrency Control (cont.) 17

ppt pdf

12


T 11/11

Veterans' Day Holiday



23

Th 11/13

Guest Lecture: Data Mining
26

ppt pdf

13

24

T 11/18

Concurrency Control (cont)
17
Homework 4 Due
ppt pdf
25

Th 11/20

Query Optimization - Another Try
15

ppt pdf

14

26

T 11/25

Physical Database Design and Tuning
20

ppt pdf

Th 11/27

Thanksgiving Holiday



15

27

T 12/2

Guest Lecture: Data Management at E-Trade
NA

ppt pdf
28

Th 12/4

Class Wrap-Up


ppt pdf

Mo 12/8

Homework 5 Due


Tu 12/9

Final Exam Review - 306 Soda
1pm - 3pm




 Fr 12/12 Final Exam - 4 LeConte
5pm - 8pm