CSCI 4710 Databases

Course Syllabus, Spring 2006

 

 

 

Course Title

Prerequisites

Professor

Course Description

Absence policy

Grading Policy

Academic Honesty

Tentative Course Outlines

 

1.      COURSE TITLE: Database Systems

 Required Text: Database Management Systems; by Raghu Ramakrishnan and Johannes Gehrke; Third Edition. (back to top)

 

2. PREREQUISITES: C or above in CSCI 3410 - Data Structures (back to top)


3. PROFESSOR: J .F. Yao, Ph.D.
               Office:       Atk 317
               Phone:        (478) 445-5483
               Email:        jf.yao@gcsu.edu
               URL:          http://abacus.gcsu.edu
               Office Hours: 2:00-3:15 P.M., Mon-Th or by appointment (back to top)

4. COURSE DESCRIPTION:
An introduction to basic concepts, design techniques, and theories in database management systems. The primary emphasis is on the relational database management systems. The goal is for students to be able to design and maintain a relational database management system as a DBA after taking this course. (back to top)

5. ABSENCE POLICY:
Regular attendance along with the timely completion of all homework assignments is essential for the successful completion of the course.  An unexcused absence from a test will result in a numerical grade of 0 for that test. (back to top)

6. GRADING POLICY:
The grade for the course will be determined from 2 exams, a final, and homework assignments.  Relative weights along with tentative examination dates are as follows:

Exam 1             25% (Feb. 16)
Exam 2             25% (March 23)
Final                 25% (11 a.m.-1:45 p.m. Th, May 4)
Homework       25%

   Note: Late assignments will be penalized 10% per day after the assigned due date. (back to top)

7. ACADEMIC HONESTY:
Students are expected to present a true and honest representation of all academic work regarding their performance during the course. Unless specifically stated as part of an assignment, team/group efforts on assignments are prohibited. Students may discuss general approaches to solving problems related to an assignment, but must work on assignments individually. (back to top)

8. TENTATIVE COURSE OUTLINE:

WEEK              TOPICS

=============================================================
1          Introduction (Ch. 1)
2          ER Model Conceptual Design (Ch. 2)

3                    Relational Model SQL DDL (Ch. 3)

4                    Relational Operators I: Relational Algebra (Ch. 4)

5                    Relational Operators II: Relational Calculus (Ch. 4)

6                    SQL DML (Ch. 5)

7                    Schema Refinement and Normal Forms (Ch. 19)

8                    Overview of Storage and Indexing (Ch. 8)

9                    Overview of Query Evaluation (Ch. 12)

10                Spring Break (Mar. 13 - Mar. 17)

11                Overview of Transaction Management (Ch. 16)

12                Databases and The Internet (Ch. 6)

13                Database-Backed Internet Applications (Ch. 7)

14                Object-Oriented Database Systems (Ch. 23)

15                Physical DB Design, Tuning (Ch. 20)

16                Physical DB Design, Tuning (back to top)

 

Martin Luther King Day: Jan. 16, 2006

March 3, 2006 is the last day to drop without academic penalty. (Back to top )

 

FIRE DRILL PROCEDURE

In the event of a fire alarm signal students will exit the building in a quick and orderly manner through the nearest hallway exit.  Learn the floor plan and exits of this building. Do not use elevators.  Crawl on the floor if you encounter heavy smoke. Assist disabled persons and others if possible without endangering your own life. Assemble for a headcount on front lawn of main campus. (Back to top)