CS422 Principles of Database Systems

Fall 2013

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

Announcements

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

Lecture Notes	Assignments
Syllabus Course Overview (ppt) (pdf) Entity-Relationship Model (ppt) (pdf) Convert ER Design to Relations (ppt) (pdf) Normalization (ppt) (pdf) SQL (ppt) (pdf) Stored Procedures and Triggers (ppt) (pdf) Introduction to Query Processing (ppt) (pdf) Disk Access (ppt) (pdf) Record Management (ppt) (pdf) Buffer Management (ppt) (pdf) Failure Recovery (ppt) (pdf) Concurrency Control (ppt) (pdf) Indexes (ppt) (pdf)	Homework 1 Due: Thursday, Oct 10 Homework 2 Due: Thursday, Oct 17 Homework 3 Due: Thursday, Oct 29 Homework 4 Due: Monday, Nov 4 Homework 5 Due: Thursday, Nov 14 Homework 6 Due: Thursday, Dec 5
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 Midterm Sample Final Final