Syllabus

CS422 Principles of Database Systems

Summer 2006
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: M 2-3:30pm and TR 3:30-5:30pm, or by appointment, in E&T A317

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	3
4	Multivalued Dependency Relational Algebra	3 5
5	SQL	6
6	Datalog Lab 1: Normalization and SQL	10
7	MIDTERM Introduction to Transactions
8	PL/SQL Stored Procedures and Triggers	7
9	JDBC and Embedded SQL Object-Oriented Features in DBMS	8 4, 9
10	Lab 2: PL/SQL and JDBC Object-Relational Mapping
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.