Last updated Monday, February 17, 2003
Classes for Monday, February 17, 2003 are cancelled. We
will 'double up' next week's class. See modified schedule below.
CMIS 408 - Database Management
Monday evenings, 6:30-9:20 pm
Home Office Phone: (856)786-4216. If I'm
not there, identify yourself as a student, and leave a message. Be sure to
leave a return phone number.
- Required Text:
Database Management. 6th Edition by Hoffer, Prescott and McFadden
2000 Essentials Basic by Ferrett, Preston and Preston
Website for the Hoffer Textbook
- Other readings (short articles) may also be distributed.
- Course Objective:
An examination of data structures, file organization, and logical design of
large-scale database systems using relational and object-oriented models.
Includes a hands-on database design experience.
- Academic Integrity:
Holy Family College expects of its students the highest standards
of integrity in performance of academic assignments.
Dishonesty in college work, whether it be quizzes, laboratory work,
term papers, examinations, etc. is regarded as a serious offense and may
result in failure in the course and dismissal from the college. Anyone who
willfully assists another in the breach of integrity is held equally
responsible and subject to the same penalty.
- The components which will determine your grade for the course are:
Database Design Project
- Student Responsibilities:
- Homework Assignments:
- Read the assigned chapter prior to coming to class.
- Holy Family College does not recognize the cut system. Students are expected
to attend all classes and laboratory sessions regularly and may not absent
themselves except for illness or some other serious matter. Attendance is
especially important during the first three weeks of classes. Students may not
extend their vacation beyond the date assigned for return to college without
the approval of the associate provost for academic student services. Students
who do not attend classes during this period may jeopardize their enrollment
and may be administratively withdrawn from classes. Such actions may
jeopardize their financial aid status as well.
Instructors maintain a record of class attendance. All students are expected
to meet their usual class responsibilities until the hour set by the college
calendar for the beginning of a vacation period. In any semester, absences
equal to twice the number of weekly contact hours of a given class are deemed
excessive. Final grades and/or the receipt of academic credit may be effected
by excessive absences. In any case in which absences exceed the allotted
number, the instructor and the associate provost for academic student services
will determine whether circumstances warrant an exception to policy.
Read the assigned chapter prior to
coming to class
Each student will be expected to
complete (on their own) a Database Design Project
The Midterm examination will
consist of multiple choice, True or False, and Fill-in-the-blank type questions.
Expect 70 to 100 questions.
The Final examination will consist
of multiple choice, True or False, and Fill-in-the-blank type questions. Expect
70 to 100 questions.
The Final examination is NOT
Monday, January 20, 2003 is a
Monday, March 10, 2003 we will not
Monday, April 21, 2003 is a
college holiday--Easter Monday.
- Grading System (from the college catalog):
Outstanding master of the subject
Superior; above-average mastery of the subject
Average; satisfactory mastery of the subject
Passing; showing deficiency in ability or industry; not transferable; not
acceptable in major area of study
Not acceptable in major field of study
F 69.99 and below Failure; credit
can be earned only by repeating the course
Listen on KYW 1060
radio for the Holy Family Snow number = 2124. We will not have class
if school is closed. Class is usually rescheduled for later in the term.
If you are having problems in the course, it is your responsibility to discuss
these difficulties with me in a timely manner.
|Reading Requirements / Meeting Dates Outline:
Introductions, Course Overview, Course Requirements|
The Database Environment
The Database Development Process
Read: Chapters 1 and 2.
Martin Luther King Day---College Closed
Modeling Data in the Organization|
Read: Chapter 3
Complete: Access Essentials Projects 1 and 2
The Enhanced E-R Model and Business Rules|
Read: Chapter 4
Logical Database Design and the Relational Model|
Read: Chapter 5
Complete: Access Essentials Project 3
Physical Database Design and Performance|
SQl and Advanced SQL
Read: Chapters 6, 7 and 8
Complete: Access Essentials Project 4
Midterm Examination (Chapters 1 through 8)
Spring Break---College Closed
The Client/Server Database Environment|
Read: Chapter 9
Complete: Access Essentials Project 5
The Internet Database Environment
Read: Chapter 10
Read: Chapter 11
Complete: Access Essentials Project 6
Data and Database Administration
Read: Chapter 12
Read: Chapter 13
Complete: Access Essentials Project 7
Easter Monday---College Closed
Object-Oriented Data Modeling
Object-Oriented Database Development
Read: Chapters 14 and 15
Complete: Access Essentials Project 8
Final Examination (Chapters 9 through 15)
© 1998-2003 Smiley and Associates, Inc.
Revised - February 17, 2003