Course Title
UNCP Home Page CSC 3800 Database Management Systems
 Fall 2009
Office Information
002 Instructor: Dr. Charles W. Lillie
 Office: 1219 Oxendine
 Telephone: 910-521-6415 email: lilliec@uncp.edu
Office Hours: MWF 8:30-9:30, MW 2:30-3:30
Time: 1:30 to 2:20 Meeting Days: MWF Location: Oxendine 1237B
Textbook: Databases Illuminated, Author: Catherine M. Ricardo, 2004, Jones & Bartlett Publishers
Description
The course covers the goals of DBMS including data independence, relationships, logical and physical organizations, schema, and subschema. Hierarchical, network, and relational models are covered with an emphasis on the relational model. Small SQL queries are created and examined.

Prerequisites
CSC 2850.

Course Content
  • Identify database management systems
  • Relational data model
  • High level database models
  • Relational Algebra
  • SQL database language

Goals
  • Understand database management systems
  • Understand relational data model
  • Describe high level database models
  • Implement SQL queries

Objectives
By the end of the semester the student will be able to:

  • Recognize and define database management systems
  • Identify and define relational data model
  • Evaluate high level database models
  • Analyze queries and manipulate SQL programs
  • Evaluate SQL queries
Course Links
Exams
The course will have two exams, a midterm and comprehensive final exam.

Class Project
The class project will apply the knowledge gained from lectures and outside research to implement a software system.  The system will be determined by selecting from a list of potential systems or choosing one proposed by the class.  The instructor will be the project manager and each student will be assigned roles based on the project's needs.  Grades will be determined by the amount of participation and contribution by each student.

Grading Policy
You are responsible for all material covered in class even if you are absent. The final grade will be a weighted average of the scores in the tests and the class project.

Grade Components
 Name Weight
Midterm Exam 30%
Final Exam 40%
Class Project
 30%
 
Final Grades
93 – 100 = A
 88 – 89 = B+
 78 – 79 = C+
 68 – 69 = D+
 Below  60 = F
90 –  92 = A-
 83 – 87 = B
 73 – 77 = C
 63 – 67 = D

80 – 82 = B-
 70 – 72 = C-
 60 – 62 = D-

Attendance Policy
Attendance will be checked. To get a passing grade in the course you should attend at least 90% of the classes. Less than 90% attendance will adversely affect your grade.

Student Conduct & Honor Code
The UNCP Academic Honor Code will be strictly observed in this class.

Please note that the use of University computers, as well as E-mail and Internet communications is for University-related business only.

Students with Disabilities
Any student with a documented disability needing academic adjustments is requested to speak directly to Disability Support Services and the instructor, as early in the semester (preferably within the first class week) as possible. All discussions will remain confidential.

This publication is available in alternative formats upon request. Please contact Mary Helen Walker, Disability Support Services, Career Services Center, 521-6270.


Contact Web Page Owner at lilliec@uncp.edu