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/26
Introduction (pdf)
Chapter 1

Projecct stage 0

Th 8/28
ER Model (pdf)
Sections 2.1, 4.1

Projecct stage 1

Tu 9/2
Good and Bad ER Diagrams (pdf)
Sections 4.1 - 4.6

Project stage 2, Project stage 3, Project stage 3.5, Project stage 4, Project stage 5, Grad Project stage 0

Th 9/4
Relational Model & Translating from ER Diagrams to Relational Schemas (pdf)
Sections 2.2 2.3, 4.6

Projecct stage 0

Tu 9/9
Relational Schema Design 1 (pdf)
Sections 3.1 - 3.3

Th 9/11
Relational Schema Design 2 (pdf)
Sections 3.4 - 3.7

HW #1

Projecct stage 1

Tu 9/16
Relational Algebra (pdf)
Sections 2.4, 5.1, 5.2

Project stage 2

Th 9/18
SQL: Queries (pdf)
Sections 6.1, 6.2

Tu 9/23
SQL: Subqueries and aggregation (pdf)
Sections 6.3, 6.4

HW #1

Th 9/25
SQL: Subqueries and aggregation 2 (pdf)
Sections 6.3, 6.4

HW #2

Grad Project stage 0

Tu 9/30
SQL: DB Definition, Modification, View, Modification (pdf)
Sections 2.3, 6.5, 6.6, Chapter 8

Th 10/2
SQL: Constraints and Triggers (pdf)
Chapter 7

Grad Project Stage1, Grad Project Stage 2

Project stage 3

Tu 10/7
SQL: Systems Aspects
Chapter 9

HW #2

Th 10/9
Accessing a Database from PHP
Section 9.7

Grad Project Stage1

Tu 10/14
Midterm Exam

Th 10/16
Data Storage and Representation
Chapter 13

Project stage 3.5

Tu 10/21
Indexing 1
Sections 14.1, 14.2

Th 10/23
Indexing 2
Sections 14.3, 14.4

HW #3

Tu 10/28
Guest Lecture

Th 10/30

Tu 11/4
Query Execution 1
Sections 15.1 - 15.4

HW #3

Th 11/6
Query Execution 2
Sections 15.5 -15.8

Tu 11/11
Query Optimization 1
Sections 16.1 - 16.5

Th 11/13
Query Optimization 2
Sections 16.6, 16.7

Grad Project Stage 2

Tu 11/18
Logging and Recovery
Chapter 17

HW #4

Th 11/20
Concurrency Control 1
Sections 18.1 - 18.7

Tu 11/25 and Th 11/27 Thanksgiving Break

Tu 12/2
Concurrency Control 2
Sections 18.8, 18.9

Th 12/4
Distributed Transactions
Sections 19.1, 19.2

HW #4

Tu 12/9
Final Review

Tu 12/16
Final Exam, 8 - 11am

Date	Topic	Chapter/Section Readings	Assignments
			Out	Due
Tu 8/26	Introduction (pdf)	Chapter 1	Projecct stage 0
Th 8/28	ER Model (pdf)	Sections 2.1, 4.1	Projecct stage 1
Tu 9/2	Good and Bad ER Diagrams (pdf)	Sections 4.1 - 4.6	Project stage 2, Project stage 3, Project stage 3.5, Project stage 4, Project stage 5, Grad Project stage 0
Th 9/4	Relational Model & Translating from ER Diagrams to Relational Schemas (pdf)	Sections 2.2 2.3, 4.6		Projecct stage 0
Tu 9/9	Relational Schema Design 1 (pdf)	Sections 3.1 - 3.3
Th 9/11	Relational Schema Design 2 (pdf)	Sections 3.4 - 3.7	HW #1	Projecct stage 1
Tu 9/16	Relational Algebra (pdf)	Sections 2.4, 5.1, 5.2		Project stage 2
Th 9/18	SQL: Queries (pdf)	Sections 6.1, 6.2
Tu 9/23	SQL: Subqueries and aggregation (pdf)	Sections 6.3, 6.4		HW #1
Th 9/25	SQL: Subqueries and aggregation 2 (pdf)	Sections 6.3, 6.4	HW #2	Grad Project stage 0
Tu 9/30	SQL: DB Definition, Modification, View, Modification (pdf)	Sections 2.3, 6.5, 6.6, Chapter 8
Th 10/2	SQL: Constraints and Triggers (pdf)	Chapter 7	Grad Project Stage1, Grad Project Stage 2	Project stage 3
Tu 10/7	SQL: Systems Aspects	Chapter 9		HW #2
Th 10/9	Accessing a Database from PHP	Section 9.7		Grad Project Stage1
Tu 10/14	Midterm Exam
Th 10/16	Data Storage and Representation	Chapter 13		Project stage 3.5
Tu 10/21	Indexing 1	Sections 14.1, 14.2
Th 10/23	Indexing 2	Sections 14.3, 14.4	HW #3
Tu 10/28	Guest Lecture
Th 10/30
Tu 11/4	Query Execution 1	Sections 15.1 - 15.4		HW #3
Th 11/6	Query Execution 2	Sections 15.5 -15.8
Tu 11/11	Query Optimization 1	Sections 16.1 - 16.5
Th 11/13	Query Optimization 2	Sections 16.6, 16.7		Grad Project Stage 2
Tu 11/18	Logging and Recovery	Chapter 17	HW #4
Th 11/20	Concurrency Control 1	Sections 18.1 - 18.7
Tu 11/25 and Th 11/27	Thanksgiving Break
Tu 12/2	Concurrency Control 2	Sections 18.8, 18.9
Th 12/4	Distributed Transactions	Sections 19.1, 19.2		HW #4
Tu 12/9	Final Review
Tu 12/16	Final Exam, 8 - 11am