Mathematics/Computer
Science
CSC 465-01: Database Management Systems
Instructor: Dr. Chuck Lillie Semester: Spring 2003
Class Location: SCI 112 Time: TR 12:30 PM to 1:45 PM
Section:
01
Description:
The content of this course includes a discussion of goals of DBMS including data independence, relationships, logical and physical organizations, schema, and subschema. Hierarchical, network, and relational models. Examples of implementation. Data descriptor langauges. Query facilities. File organization. Index organization. Data integrity and reliability.
Goals:
·
Comprehend
database functions.
·
Apply
database concepts.
Objectives:
By the end of this course the student should be able to:
·
Recognize
and define database functions.
·
Evaluate
a database management system to determine its capabilities.
·
Create
third normal form relations
·
Develop
a relational database schema
·
Design
and document a simple relational database application
Course Materials:
Textbook: Ramakrishnan &
Gehrke, Database Management Systems, 3rd Edition
Supplemental Reading:
As needed or assigned.
Course Content:
· Lectures discussing database functions.
· Homework assignments covering
· Programming project that applies concepts discussed in lecture.
Assignments and Project:
CSC465-01
Project Requirements.htm
Office Hours:
Office: SCI 102
Email: lilliec@uncp.edu
Phone: 910-521-6415
Office Hours: MWF 1:30 PM to 2:30 PM
TR 2:00 PM to 3:00 PM
Or by appointment
Open door indicates unscheduled office hours
Course Links:
Exams, Homework, and Projects:
This course will have three exams, homework
assignments, operating system project, and comprehensive final exam.
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 homework, project, exams, and final exam. Homework is due on Assignment Due Date. Your grade for that assignment is decreased
by 10% if it is one week late. If it is
later than one week, you get a score of zero.
Grade Components:
|
Name |
Weight |
|
Three
Major Tests (15% each) |
45% |
|
Homework |
25% |
|
Project |
0% |
|
Final
Exam |
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.
Student
Conduct & Honor Code
The UNCP Academic Honor Code
will be strictly observed in this class.
UNCP Academic Honor Code: http://www.uncp.edu/catalog99/academic.htm#honor_code
Dates:
Last day to drop classes:
March 17, 2003
Final Exam: Monday, May 5,
2003, 1:00 PM to 3:00 PM
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 week) as possible. All discussions will remain
confidential. Please contact Mary Helen
Walker, Disability Support Services, DF Lowry building, 521-6695.
This syllabus is available
in alternative formats upon request.
Please contact Mary Helen Walker, Disability Support Services, DF Lowry
building, 521-6695.