Syllabus

CS422 Principles of Database Systems

Fall 2010
Computer Science Department
California State University, Los Angeles


Lectures:
Tuesday 6:10pm - 10:00pm in E&T A332
Instructor:
Chengyu Sun
Email: csun@calstatela.edu
Office: E&T A317
Office Hours: MW 2-4pm and T 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 languages, 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 60%,  Midterm 20%, Final 20%

90 - 100
80 - 90
60 - 80
40 - 60
below 40
A
B
C
D
F
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
MIDTERM

6
Disk Access
Buffer Management
12
13
7
Failure Recovery
13,14
8
Concurrency Control
14
9
Record Management
Indexes
15
21
10
Query Execution 16,17,18,19
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.