Syllabus

CS422 Principles of Database Systems

Summer 2005
Computer Science Department
California State University, Los Angeles

Lectures:

Tuesday and Thursday 6:10pm - 7:50m, in E&T A220

Instructor:

Chengyu Sun
Email: csun@calstatela.edu
Office: E&T A317
Office Hours: TR 4:00-6:00pm or by appointment

Course Description:

This course covers the design, implementation, query, application development, and performance tuning of databases, with emphases on data modeling, relational theory and languages, and procedural language programming. We will also discuss advanced features of SQL, and some special topics such as data warehousing, data mining, and XML data management.

Prerequisites:

CS122 and CS312

Textbook(s):

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

Software Tools:

Required - Email, and iSQL*Plus or SQL*Plus
Optional (for access online lecture notes) - Adobe Acroread and/or MS PowerPoint

Grading Policy:

Homework and Projects 40%, Lab 10%, Midterm 20%, Final 25%, Participation 5%

90 - 100
80 - 90
60 - 80
40 - 60
below 40

A
B
C
D
F

Schedule:

Week	Topics	Chapters
1	Administrative Issues Course Overview Introduction to Oracle Entity-Relationship (ER) Model	1 2
2	Introduction to Relational Model Functional Dependency	3 3
3	Normalization Multivalued Dependency	3 3
4	Relational Algebra SQL	5 6
5	Lab 1: Schema Design and SQL Introduction to Transactions
6	Datalog MIDTERM	10
7	PL/SQL
8	Stored Procedures and Triggers JDBC and Embedded SQL	7 8
9	Lab 2: PL/SQL and JDBC Object-Oriented Features in DBMS	4, 9
10	Object-Relational Mapping Performance Tuning
11	FINAL

Online Resources:

Class home page - http://sun.calstatela.edu/~cysun/www/teaching/cs320/index.html
Class forum - http://acm.calstatela.edu/forum/viewforum.php?f=32
Database Systems: The Complete Book - http://www-db.stanford.edu/~ullman/dscb.html
Oracle 10g Documentation - http://sun.calstatela.edu/~cysun/documentation/oracle/index.htm
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.