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 (pdf)
Chapter 9

HW #2

Th 10/9
Midterm Review (pdf)

Grad Project Stage1

Tu 10/14
Midterm Exam (solution)

Th 10/16
Data Storage and Representation (pdf)
Chapter 13

Grad Project Stage 3

Project stage 3.5

Tu 10/21
Indexing 1 (pdf)
Sections 14.1, 14.2

Th 10/23
Indexing 2 (pdf)
Sections 14.3, 14.4

HW #3

Tu 10/28
XML Query (pdf)

Th 10/30
Data Integration (pdf)

HW #3

Tu 11/4
Query Execution 1 (pdf)
Sections 15.1 - 15.4

Th 11/6
Query Execution 2 (pdf)
Sections 15.5 -15.8

HW #4

Tu 11/11
Query Optimization 1 (pdf)
Sections 16.1 - 16.5

Th 11/13
Query Optimization 2 (pdf)
Sections 16.6, 16.7

Project stage 4, HW #4

Tu 11/18
Logging and Recovery (pdf)
Chapter 17

HW #5

Grad Project Stage 2

Th 11/20
Concurrency Control 1 (pdf)
Sections 18.1 - 18.7

Tu 11/25 and Th 11/27 Thanksgiving Break

Tu 12/2
Concurrency Control 2 (pdf)
Sections 18.8, 18.9

HW #5

Th 12/4
Distributed Transactions (pdf)
Sections 19.1, 19.2

Project stage 5

Tu 12/9
Final Review (pdf)

Grad Project Stage 3

Th 12/11

HW #6

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 (pdf)	Chapter 9		HW #2
Th 10/9	Midterm Review (pdf)			Grad Project Stage1
Tu 10/14	Midterm Exam (solution)
Th 10/16	Data Storage and Representation (pdf)	Chapter 13	Grad Project Stage 3	Project stage 3.5
Tu 10/21	Indexing 1 (pdf)	Sections 14.1, 14.2
Th 10/23	Indexing 2 (pdf)	Sections 14.3, 14.4	HW #3
Tu 10/28	XML Query (pdf)
Th 10/30	Data Integration (pdf)			HW #3
Tu 11/4	Query Execution 1 (pdf)	Sections 15.1 - 15.4
Th 11/6	Query Execution 2 (pdf)	Sections 15.5 -15.8	HW #4
Tu 11/11	Query Optimization 1 (pdf)	Sections 16.1 - 16.5
Th 11/13	Query Optimization 2 (pdf)	Sections 16.6, 16.7		Project stage 4, HW #4
Tu 11/18	Logging and Recovery (pdf)	Chapter 17	HW #5	Grad Project Stage 2
Th 11/20	Concurrency Control 1 (pdf)	Sections 18.1 - 18.7
Tu 11/25 and Th 11/27	Thanksgiving Break
Tu 12/2	Concurrency Control 2 (pdf)	Sections 18.8, 18.9		HW #5
Th 12/4	Distributed Transactions (pdf)	Sections 19.1, 19.2		Project stage 5
Tu 12/9	Final Review (pdf)			Grad Project Stage 3
Th 12/11				HW #6
Tu 12/16	Final Exam, 8 - 11am