Class Schedule and Slides

This is our tentative class schedule, which will be changed frequently to reflect our actual rate of progress, visitors from industry, and so on.

.pptx files are the output of Microsoft PowerPoint 2007. If you don't have the same version of PowerPoint, please download and install PowerPoint Viewer 2007.

Date

Topic

Chapter/Section Readings

Assignments

 

 

 

Out

Due

Tu 8/25

Introduction (pdf)

Chapter 1

 

 

Th 8/27

ER Model (pdf)

Sections 2.1, 4.1

 

 

Tu 9/1

Good and Bad ER Diagrams (pdf)

Sections 4.1 - 4.6

 

 

Th 9/3

Relational Model & Translating from ER Diagrams to Relational Schemas (pdf)

Sections 2.2 2.3, 4.6

Projects, Grad Projects

Project Stage 0

Tu 9/8

Relational Schema Design 1 (pdf)

Sections 3.1 - 3.3

 

 

Th 9/10

Relational Schema Design 2 (pdf)

Sections 3.4 - 3.7

HW 1

Project Stage 1

Tu 9/15

Relational Algebra (pdf)

Sections 2.4, 5.1, 5.2

 

 

Th 9/17

SQL: Queries (pdf)

Sections 6.1, 6.2

 

Project Stage 2

Tu 9/22

SQL: Subqueries and aggregation (pdf)

Sections 6.3, 6.4

HW 2

HW 1

Th 9/24

SQL: Subqueries and aggregation 2 (pdf) (notes)

Sections 6.3, 6.4

 

Grad Project A

Tu 9/29

SQL: DB Definition, Modification, View, Modification (pdf) (notes)

Sections 2.3, 6.5, 6.6, Chapter 8

 

Project Stage 3

Th 10/1

SQL: Constraints and Triggers (pdf) (notes)

Chapter 7

 

HW 2

Tu 10/6

SQL: Systems Aspects (pdf) (notes) (sample programs)

Chapter 9

 

 

Th 10/8

Midterm Review (pdf) (notes) (mini-lecture)

 

 

 

Tu 10/13

Midterm Exam (solution)

 

 

 

Th 10/15

Data Storage and Representation (pdf) (notes)

Chapter 13

 

 

Tu 10/20

Indexing 1 (pdf) (notes)

Sections 14.1, 14.2

 

 

Th 10/22

Indexing 2 (pdf) (notes)

Sections 14.3, 14.4

HW 3

 

Tu 10/27

Query Execution 1 (pdf) (notes)

Sections 15.1 - 15.4

 

 

Th 10/29

Query Execution 2 (pdf)

Sections 15.5 -15.8

 

Grad Project B

Tu 11/3

Query Optimization 1 (pdf) (notes)

Sections 16.1 - 16.5

 

HW 3

Th 11/5

Query Optimization 2 (pdf) (notes)

Sections 16.6, 16.7

HW 4

 

Tu 11/10

Introduction to Information Retrieval and its Applications (Maryam Karimzadehgan) (pdf)

 

 

 

Th 11/12

Introduction to Data Integration (Hanna Zhong) (pdf)

 Chapter 21

 

Project Stage 4

Tu 11/17

Logging and Recovery (pdf) (notes)

Chapter 17

HW 5

HW 4

Th 11/19

Concurrency Control 1 (pdf) (notes)

Sections 18.1 - 18.7

 

 

Tu 11/24 and Th 11/26

Thanksgiving Break

 

 

 

Tu 12/1

Concurrency Control 2 (pdf) (notes)

Sections 18.8, 18.9

 

HW 5, Grad Project C

Th 12/3

Final Review (pdf) (notes)

 

 

Project Stage 5

Tu 12/7

Selected Course Project Demos/Graduate Project Presentations

 

 

 

Tu 12/15

Review Session (pdf)

 

 

 

Th 12/17

Final Exam 7-10pm