COP 4710 (Database Management Systems) Fall 2003

Room: Eng2 302

Date and Time: TR 1500 – 1615

Instructor: Khanh Vu

Office: CSB 237

Phone: (407) 823-3467

Office Hours: TR 1200 – 1430 and by appointment

Graduate Teaching Assistant: Mian Zhou
Office:             CCI 202
Email:               mzhou@cs.ucf.edu
Office Hours:    T 1600 – 1800, W 1500 - 1700 and by appointment

Required Book: Fundamentals of Database System, 4^th ed., by Elmasri and Navathe, Addison Wesley

Prerequisite: COP 3530C/Computer Science III

Web Resources: http://www.cs.ucf.edu/courses/cop4710/fall2003

Course Objectives

The general objective is to provide students with a broad background in database design, database languages, and database system implementation. The emphasis on the fundamental concepts of database management should provide you with the ability to accommodate to a variety of database technology. The topics covered should also provide a firm foundation for further studying, designing, implementing, and effectively using database systems.

Topical Outline

§ General Introduction and basic concepts

§ Conceptual Design, Entity-Relationship (ER) and extended ER Modeling

§ Relational Model

§ ER to relational mapping

§ Structured Query Language (SQL)

§ Relational Database Design

§ Relation Calculus

§ Storage & File Structures

§ Indexing & Hashing

§ Query Processing and Optimization

§ XML

§ (More material if time permits)

Term Project (see Project Description)

Grading

Assignments: 20%

Team Project: 20%

Midterm: 30%

Final exam: 30%

Letter grades are guaranteed according to the following percentages of points:

90% or above: A

80% or above: B

70% or above: C

60% or above: D

Late Assignments: No late assignments will be accepted by default.

Dishonesty

Cheating on examinations or other serious forms of academic dishonesty will result in a grade of "F" (and a required report to University officials). Persons "borrowing" someone else's work on an assignment will receive a zero on that assignment if it is the first offense. A second offense will be considered a serious form of academic dishonesty. (Borrowing is equally subject to penalties.) You are not expected to work in isolation on assignments. Significant learning frequently takes place in the interchange of ideas with one another. In the final analysis, however, your response to an assignment must be your own, not someone else's.

Missed Examinations

Only in extenuating circumstances such as family crisis, illness, births, etc., will makeup provisions apply. Advise your instructor in advance of absences due to such matters, if possible.

Drop Policy

See "Drop" policy in appropriate Class Schedule.

Incomplete

The grade of "I" will not be given in this course unless very unusual circumstances should arise.

Graduation Status

Those persons who expect to graduate this year are advised that tentative graduation status has no bearing whatsoever on grading policies and procedures.