COURSE NUMBER: CS 360
COURSE TITILE: DataBase Management
INSTRUCTOR: Brian F. Clement M.B.A.
TERM DATES: Spring 1,20053
MEETING TIMES: Sat. 0800-1300
I. COURSE DESCRIPTION:
This course provides an overview of database system concepts. The course will deal with file organization methods, database models, data integrity and security, and database administration issues. The student will be introduced to application program development in a database environment with emphasis on setting up, modifying, and querying a database. Prerequisite: CS 219. 3:0:3
II. COURSE GOALS:
This goal of this course is to provide the student with a solid background in fundamental database theories sot that the student will be better prepared to plan, build and maintain various database applications. Three primary areas will be emphasized: the physical view of the database, the conceptual view of the database, and lastly, the user view of the database.
III. LEARNING OBJECTIVES:
Upon successful completion of the course, students should fully understand the following concepts:
1. Current physical database perspectives
2. Data Base modeling
3. File organization concepts
4. The role of the D.B.M.S.
5. Database application planning, implementation, and management
6. Various database management techniques
V. COURSE ARRANGEMENTS:
Course arrangements will consist of lectures, class discussions, laboratory examples and exercises, and homework assignments. Group and Individual projects and examinations may also be required. While laboratory facilities are available, students may complete required projects using computers outside the college campus providing the software requirements of the course are used.
V. COURSE REQUIREMENTS:
Students are responsible for reading all assignments from the text. All projects and assignments are due on the date assigned and late assignments will not be accepted unless coordinated with the instructor beforehand. Students are responsible for obtaining information regarding assignments made during any absence.
Kroenke, David M. DATABASE PROCESSING. 9TH Edition. Prentice Hall. 2004 ISBN 0-13-101514-1
VII. SUPPLEMENTAL RESOURCE MATERIALS LIST:
Students will be required to have a presentation folder which includes a pocket in which projects are to be submitted.
VIII. CLASS MEETING AND EXAMINATION SCHEDULE:
Please refer to Appendix A of this syllabus.
IX. CLASS POLICIES:
Students are cautioned regarding Park College policies regarding class attendance and academic honesty. This policies will be strictly adhered to. Additionally, policies regarding smoking and eating established by the Sergeants Major Academy will be observed. Late projects and / or assignments will not be accepted. All make-up examinations will be administered through the college testing facilities and will be available the last two (2) days of the semester.
Students are further advised that pursuant to N.C.A.C.A.S., V.A., and T.E.A. policies, classes will be in session the entire prescribed length of time. In the event lectures and / or classroom activities are curtailed, all students will use remaining time in the laboratory facilities.
X. GRADING POLICIES:
Student Grades will be accumulated on a point basis where four hundred points is the maximum allowed. Points shall be awarded as follows:
100 Points = Mid Term Examination 100 Points = Projects / Quizes
100 Points = Final Examination 100 Points = Final Project
Total Points = 400 points
The letter grade awarded shall correspond to the points accumulated in the following manner:
360 to 400 Points (90% - 100%) = ‘A’
320 to 359 Points (80% - 89%) = ‘B’
280 to 319 Points (70% - 79%) = ‘C’
240 to 279 Points (60% - 69%) = ‘D’
Below 240 Points (<60%) = ‘F’
Students are advised that “Incomplete” will be given only in the severest of circumstances. It is the responsibility of the student to withdraw from the class prior to the closing date for “Withdrawal” grades.
XI. INSTRUCTOR DATA:
Brian F. Clement, M.B.A.
El Paso, TX 79925-6604
Office hours by appointment only.
01 Introduction and DB Overview
02 Conceptual Overview of the DataBase
03 Data Modeling
04 Data and Database Administration Mid Term Exam
05 User View of Data
06 Applications Development and the Database
07 Project Presentations
08 Course Summary and Final Examination
This syllabus was prepared to provide a general outline of topics to be covered in the class and is subject to student mastery of the concepts and on-going presentations. Therefore, it is subject to revision based upon the actual accomplishments of the class.