CS422 Principles of Database Systems

Fall 2012

Lectures	MW 1:30pm - 3:10pm
Room	E&T A210
Instructor	Chengyu Sun, csun@calstatela.edu
Office Hours	T 3-5pm R 2-4m, or by appointment, in E&T A317

Announcements

11/25 - Final will be from 1:30pm to 4:00pm on Monday, December 3 in E&T A210.
10/20 - Midterm will be from 1:30pm to 3:10pm on Monday, October 29 in E&T A210.

Lecture Notes	Assignments
Syllabus Course Overview (ppt) (pdf) (video) Entity-Relationship Model (ppt) (pdf) (video1) (video2) Convert ER Design to Relations (ppt) (pdf) (video) Normalization (ppt) (pdf) (video1) (video2) SQL (ppt) (pdf) (video1) (video2) (video3) Stored Procedures and Triggers (ppt) (pdf) (video1) (video2) Introduction to Query Processing (ppt) (pdf) (video) Disk Access (ppt) (pdf) (video) Record Management (ppt) (pdf) (video) Buffer Management (ppt) (pdf) (video) Failure Recovery (ppt) (pdf) (video) Concurrency Control (ppt) (pdf) (video1) (video2) Indexes (ppt) (pdf) (video)	Homework 1 Due: Thursday, October 11 Homework 2 Due: Thursday, October 25 Homework 3 Due: Monday, October 29 Homework 4 Due: Thursday, November 15 Homework 5 Due: Thursday, November 29
Other Course Materials	Exams
CS3 Server Information PostgreSQL Installation university-create.sql, university-drop.sql, university-query.sql plsql-create.sql, plsql-drop.sql Use Eclipse for SimpleDB Development	Sample Midterm Sample Final Midterm Final