Syllabus

CS422 Principles of Database Systems

Summer 2009
Computer Science Department
California State University, Los Angeles


Lectures:
 Tuesday and Thursday 6:10pm - 7:50m, in E&T A210
Instructor:
 Chengyu Sun
Email: csun@calstatela.edu
Office: E&T A317
Office Hours: MTR 3-5pm, or by appointment, in E&T A317
Course Description:
This first part of the course covers topics related to database development, including Entity-Relationship model, normalization, transactions, SQL, procedure language, and some performance tuning techniques. The second part of the course explores the internals of a database management system and discusses the details of disk access, memory access, query processing, concurrency control, and failure recovery.
Prerequisites: CS122 and CS312
Textbook(s): Database Design and Implementation, by Edward Sciore.
Software Tools:
 Required - Email, and PostgreSQL
Optional (for access online lecture notes) - Adobe Acroread and/or MS PowerPoint
Grading Policy:
 Homework and Projects 50%,  Lab 5%,  Midterm 20%, Final 25%

90 - 100
80 - 90
60 - 80
40 - 60
below 40 		A
B
C
D
F
Tentative Schedule:
Week
 Topics
 Chapters
1
 Administrative Issues
Course Overview
Entity-Relationship (ER) Model
1
3
2
 Normalization
 2,3
3
 SQL and Transactions
 4,14
4
 Stored Procedure and Triggers
 5
5
 Lab 1. SQL and PL/pgSQL
MIDTERM
6
 Disk Access
 12
7
 Buffer Management
Failure Recovery (I)
 13
14
8
 Failure Recovery (II)
Concurrency Control (I)
 14
14
9
 Concurrency Controller (II)
Query Execution (I)
 14
17,18,19
10
 Query Execution (II)
Indexing
 17,18,19
21
11
 FINAL
Online Resources:
Academic Integrity:
 Cheating will not be tolerated. Cheating on any assignment or exam will be taken seriously.  All parties involved will receive a grade of F for the course and be reported to the Academic Senate.