CS422 Principles of Database Systems

Summer 2009

Lectures	TR 6:10pm - 7:50pm
Room	E&T A210
Instructor	Chengyu Sun, csun@calstatela.edu
Office Hours	MTR 3-5pm, or by appointment, in E&T A317

Announcements

Lecture Notes	Assignments
Syllabus Course Overview (ppt) (pdf) (video) Entity-Relationship Model (ppt) (pdf) (video1) (video2) (video3) Normalization (ppt) (pdf) (video) SQL and Transactions (ppt) (pdf) (video1) (video2) (video3) Stored Procedures and Triggers (ppt) (pdf) (video) Use Eclipse for SimpleDB Development Disk Access (ppt) (pdf) (video) Buffer Management (ppt) (pdf) (video) Failure Recovery (ppt) (pdf) (video1) (video2) Concurrency Control (ppt) (pdf) (video1) (video2) (video3) Record Management (ppt) (pdf) (video) Introduction to Query Processing (ppt) (pdf) (video) Indexes (ppt) (pdf) (video)	Homework 1 Due: Wednesday, July 8 Homework 2 Due: Wednesday, July 22 Homework 3 Due: Wednesday, August 12 Homework 4 Due: Wednesday, August 19 Homework 5 Due: Friday, August 28 Lab 1. SQL and PL/SQL
Other Course Materials	Exams
CS3 Server Information PostgreSQL Installation examples-create.sql, examples-drop.sql unversity-create.sql, university-drop.sql, university-query.sql plsql-create.sql, plsql-drop.sql store-create.sql, store-drop.sql SimpleDB 2.8 Repackaged SimpleDB Sample Code	Midterm