CSc 4710/6710 Database Systems
Spring Quarter 2001 (Computer Number: 1906/1914)
10.00 to 11.40 TT, Room: 229 G

Instructor: Dr. Raj Sunderraman (758 COE, 651-0672, raj@cs.gsu.edu, Office hours: 11.40 to 1.00 TT)

Course Web Page: http://tinman.cs.gsu.edu/~raj/4710/sp01

Course Objective: To introduce the student to the fundamental concepts and principles that underlie modern-day database systems.

Catalog Description: An introduction to the fundamental concepts and principles that underlie the relational model of data. Topics include: formal query languages such as relational algebra, relational calculus, and Datalog; commercial query language SQL; query optimization; relational database design theory; physical database design, integrity, security, concurrency control, and recovery.

Syllabus: Topics to be covered:

1. Database concepts and architecture
2. Relational data model; Database Integrity; Formal query languages such as relational algebra, relational calculus, and Datalog; Commercial query language SQL; Embedded-SQL
3. Database design techniques; ER Modeling, object data modeling, relational database design theory;
4. Object data model: ODL, OQL
5. Advanced topics (as time permits): Deductive databases, Web access to databases, JDBC, SQLJ, Concurrency Control, Recovery.

Pre-requisites: CSc 3410, Data Structures (implicit in this pre-requiste is the fact that Discrete Mathematics, Math 2420, is also required); Strong programming experience in C/C++ and Java required.

Texts:

1. First Course in Database Systems by Jeffrey D. Ullman and Jennifer Widom, Prentice Hall, 1997, ISBN: 0-13-861337-0
2. Oracle8 Programming: A Primer by R. Sunderraman, Addison-Wesley, 2000, ISBN 0-201-61258-5

1. 3 Exams worth 25% each (22% for 6710 students)
2. Several homework and programming assignments worth 25% (22% for 6710 students).NOTE: All assignments will be submitted in a typed format (no hand written assignments) with proper identifying information. No exceptions will be made. Late submission policy: Assignments can be turned in until one week after the deadline for a 20% penalty. No assignment will be accepted after one week.

Additional Requirement for Csc 6710 students:

1. A research paper in a database related topic worth 6%. A suggested list of topics will be posted sometime during the semester.
2. An implementation project worth 6%. The student should discuss this with the instructor before the mid point in the semester.

The final letter grade will be determined based on the following criteria:

• A 90
• B 80
• C 65
• D 50

Withdrawal Date: March 2, 2001 (Friday)

Academic Honesty Policy The academic honesty policy as described in the University Faculty Handbook as well as the Student Handbook will be strictly enforced. Please review the document here.