CS422 Principles of Database Systems

Fall 2010

Lectures	T 6:10pm - 10:00pm
Room	E&T A332
Instructor	Chengyu Sun, csun@calstatela.edu
Office Hours	MW 2-4pm and T 3-5pm, or by appointment, in E&T A317

Announcements

11/30 - Final will be from 7:30pm to 10:00pm on Tuesday, December 7 in E&T A332.
10/15 - Midterm will be from 7:30pm to 9:30pm on Tuesday, October 26 in E&T A210.

Lecture Notes	Assignments
Syllabus Course Overview (ppt) (pdf) (video) Entity-Relationship Model (ppt) (pdf) (video) Normalization (ppt) (pdf) (video) SQL and Transactions (ppt) (pdf) (video1) (video2) 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) (video) Concurrency Control (ppt) (pdf) (video) Record Management (ppt) (pdf) (video) Indexes (ppt) (pdf) (video) Introduction to Query Processing (ppt) (pdf) (video)	Homework 1 Due: Wednesday, October 13 Homework 2 Due: Wednesday, October 20 Homework 3 Due: Wednesday, October 27 Homework 4 Due: Wednesday, November 10 Homework 5 Due: Wednesday, November 17 Homework 6 Due: Wednesday, November 24
Other Course Materials	Exams
CS3 Server Information PostgreSQL Installation university-create.sql, university-drop.sql, university-query.sql plsql-create.sql, plsql-drop.sql SimpleDB 2.8 Repackaged SimpleDB Sample Code	Sample Midterm Sample Final