WK

Class/Date

Topic

Book Chapter

Lecture  Notes (updated)

Events

SectionNotes

1

Tu 1/17

Introduction

1

[6up PDF] [ppt]

Th 1/19

Relational Model

3

[6up PDF] [ppt]

2

Tu 1/24

Storing Data - Disks and Files

9

[6up PDF] [ppt]
(new 1/29)

HW 1 Out

  [Sections 1&2]

Th 1/26

File Organization

8,9

[6up PDF] [ppt]
(new 1/29)

[Section 3]

3

Tu 1/31

Indexing Overview

8,9

[6up PDF] [ppt]
(new 2/7)

 HW 1 Pt 1 Due W (2/1)

[section notes]

Th 2/2

Tree Structured Indexes

10

Use 1/31 Notes

4

Tu 2/7

B+Tree Indexes

10

Use 1/31 Notes

[section notes]

Th 2/9

Hash-based Indexes

11

[6up PDF] [ppt]

5

Tu 2/14

Formal Langs - Relational Algebra and Calculus

4

[6up PDF] [ppt]
and
[6up PDF] [ppt]

HW 1 Pt 2 Due

[section notes]

Th 2/16

Formal Langs(Cont.)/ MT Review

4

Use 2/14 Notes

6

Tu 2/21

EXAM 1

-

In-class Exam

Th 2/23

SQL I

5

[6up PDF] [ppt]

HW 2 Out

7

Tu 2/28

SQL II & HW2 Overview

5,14

2/23 Notes & [6up PDF] [ppt]

[section notes]

Th 3/2

SQL III

5

Use 2/28 Notes

8

Tu 3/7

Relational Operator Implementation

12,14

[6up PDF] [ppt]
(new 3/21)

Th 3/9

Rel Op Impl (cont.) & Query Optimization Intro

14, 15

Use 3/7
Notes

9

Tu 3/14

Query Optimization, cont.

15

[6up PDF] [ppt]
(new 3/21)

HW 2 Due

[section notes]

Th 3/16

Query Processing Continued

15

Use 3/14
Notes

HW 3 Out 3/18

10

Tu 3/21

Query Optimizaiton Wrap-Up & Midterm Overview

15

Use 3/14
Notes

[section notes]

Th 3/23

EXAM 2 (solutions)

-

In-class Exam
HW 3 due 3/24 @5pm

[Exam Practice Questions]

-

Tu 3/28

SPRING BREAK

-

SPRING BREAK

Th 3/30

SPRING BREAK

-

SPRING BREAK

11

Tu 4/4

ER Model

2

[6up PDF] [ppt]

HW 4 Out

Th 4/6

ER Model; ER to Relational

3.5-3.9

Use 4/4 notes.

12

Tu 4/11

Logical DB Design

19

[6up PDF] [ppt]

Th 4/13

DB Design, cont.

19, 20

[6up PDF] [ppt]

13

Tu 4/18

Intro to Transactions

16/17

[6up PDF] [ppt]
(new 4/25)

[section notes] 

Th 4/20

Concurrency Control I

17

Use 4/18 notes.  

14

Tu 4/25

Concurrency Control II

17

Use 4/18 notes.  

HW 4 Due

[section notes] 

Th 4/27

Recovery I

18

[6up PDF] [ppt]  

[section notes] 

15

Tu 5/2

Recovery II

18

Use 4/27 notes.  

HW 5 Out 

Th 5/4

NO LECTURE

-

16

Tu 5/9

Transaction Wrap-up and Course Review

-

HW 5 Due F 5/12 

W 5/17

FINAL EXAM - 8am-11am

Final Exam