CSc 4710/6710 Database Systems
Spring Quarter 2000 (Computer Number: 1879/1890)
11.00 to 12.15 TT, Room: 106 CS

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

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, relational database design theory;
4. Advanced topics (as time permits): Deductive databases, Web access to databases, JDBC, SQLJ, Object-oriented databases, 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)

Texts:

1. Elmasri and Navathe, Fundamentals of Database Systems, Third Edition, Addison-Wesley, 2000.
2. R. Sunderraman, Oracle8 Programming - A Primer, Addison-Wesley, 2000.

1. 3 Exams worth 20% each (18% for 6710 students)
2. Several homework and programming assignments worth 20% (18% for 6710 students).
3. Course project worth 20% (18% for 6710 students).

Additional Requirement for Csc 6710 students: A research paper in a database related topic worth 10%. A suggested list of topics will be posted sometime during the semester.

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

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