CS422 Principles of Database Systems
Spring 2012
Lectures
MW 9:50am - 11:30am
Room
E&T A210
Instructor
Chengyu Sun
,
csun@calstatela.edu
Office Hours
MW 1-3pm and TR 2-4pm
, or by appointment, in E&T A317
Announcements
6/3 -
Final will be from 8:00am to 10:30am on Wednesday, June 13 in E&T A210.
4/29 -
Midterm will be from 9:50am to 11:30am on Monday, May 7 in E&T A210.
Lecture Notes
Assignments
Syllabus
Course Overview (ppt)
(pdf)
(video)
Entity-Relationship Model (ppt)
(pdf)
(video1)
(video2)
Normalization (ppt)
(pdf)
(video)
SQL and Transactions (ppt)
(pdf)
(video1)
(video2)
(video3)
Stored Procedures and Triggers (ppt)
(pdf)
(video1)
,
(video2)
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)
Record Management (ppt)
(pdf)
(video)
Indexes (ppt)
(pdf)
(video1)
(video2)
Introduction to Query Processing (ppt)
(pdf)
(video)
Homework 1
Due: Thursday, April 19
Homework 2
Due: Tuesday, May 1
Homework 3
Due: Tuesday, May 8
Homework 4
Due: Thursday, May 24
Homework 5
Due: Thursday, May 31
Homework 6
Due: Thursday, June 7
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 Sample Code
Sample Midterm
Sample Final
Midterm
Final