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:
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.