Syllabus

CS422 Principles of Database Systems

Summer 2004
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 2:00-4:00pm, or by appointment

Course Description:

This course is about relational theory, logical and physical design of databases, and database performance optimization. In the first part of the course we will cover various data models and query languages, mainly focusing on the relational model and languages. In the second part of the course we will discuss some advanced features of SQL, and the issues and techniques related to improving database performance.

Textbook(s):

Database Systems: The Complete Book, by Hector Garcia-Molina, Jeffrey Ullman, and Jennifer Widom

Software Tools:

Required - Email and PostgreSQL
Optional (for access online lecture notes) - Adobe Acroread and/or MS PowerPoint

Grading Policy:

Homework and Projects 40%
Midterm 30%
Final 30%

Schedule:

Week	Topics	Chapters
1	Administrative issues Introduction to database systems ER Model	1 2
2	Relational Model (I)	3
3	Relational Model (II) Relational Algebra (I)	3 5
4	Relational Algebra (II) Lab	5
5	Datalog	10
6	MIDTERM
7	SQL	6
8	Schema definition and constraints Triggers and stored procedures	6,7 7,8
9	Embedded SQL and JDBC Object oriented DB features and hibernate	8 4,9
10	Performance tuning
11	FINAL

Online Resources:

Class home page - http://www.calstatela.edu/faculty/csun/teaching/cs422/index.html
Database Systems: The Complete Book - http://www-db.stanford.edu/~ullman/dscb.html
PostgreSQL Documentation - http://www.postgresql.org/docs/
MySQL Reference Manual - http://dev.mysql.com/doc/mysql/en/index.html
JDBC

Tutorial - http://java.sun.com/docs/books/tutorial/jdbc/index.html
API Reference - http://java.sun.com/j2se/1.4.2/docs/api/java/sql/package-summary.html

Hibernate

Reference Manual - http://www.hibernate.org/hib_docs/reference/en/html/
API Reference - http://www.hibernate.org/hib_docs/api/

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.