CSc 4710/6710 Database Systems
Spring 2003 (Computer Number: 11216/11232)
10.00 to 11.40 TT, Room: 103 CS

Instructor: Dr. Raj Sunderraman (758 COE, 651-0672, raj@cs.gsu.edu, Office hours: 9.00 to 10.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; JDBC.
  3. Database design techniques; ER Modeling, relational database design theory;
  4. Object Oriented Data Model, ODL, OQL, ObjectStore Database System.
  5. XML Data Model.
  6. Web access to databases
  7. 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). Basic Unix skills are required. strong programming skills in Java 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.
    Book Web Page
    Old Edition Web Page
Grading Policy: The grading for this course will be based upon the following components:
  1. 3 Exams worth 25% each (22% each for 6710 students).
  2. Several homework and programming assignments worth 25% (24% for 6710 students)

Additional Requirement for Csc 6710 students: Project/Paper: 10%

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

Withdrawal Date: March 10, 2003 (Monday)

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.

  1. All assignments are supposed to be individual work and any collaboration or cheating would result in a zero score for the assignment.
  2. A second incident of dishonest work will result in an automatic F grade for the class.
  3. It is also the repsonsibility of each student to protect his or her work including computer files etc from being extracted by others. Computer accounts will be de-activated immediately if the student is found to have been careless in maintaining his or her files (i.e. has kept them open for others to read!). If such carelessness results in another student copying the computer files and submitting them for the assignments all students involved will automatically get a zero for the assignment.

Note: Deviations from this syllabus may be necessary during the semester and changes will be announced in class.

Raj Sunderraman