Calumet College of St.
Joseph
SYLLABUS FOR DATABASE
MANAGEMENT SYSTEMS
Term: Spring, 2002-2003 (022)
(January 6 – April 14)
Course Number: CIS 370x
Instructor: Br. Jerry Hall
Office Phone: 473-4268
E-mail: jhall@ccsj.edu
Office Hours: MTWF 9:00-11:30 AM
MTF 1:00-3:30 PM
Instructor
Background: Religious Brother of the
Missionaries of the Precious Blood
BS in geology – St. Joseph’s College, Rensselaer
MS in geology – Case
Western Reserve University, Cleveland
MS
in Computer Science and Information Systems, DePaul University, Chicago
Certificate in Lay
Pastoral Ministry – Athenaeum of Ohio
Course Time: Tuesdays
7:00-10:00 PM
Course Description:
This course will
introduce the student to integrated data bases, architecture of data base
systems, storage structures, data base management systems, and on-line
processing. Students will gain
theoretical experience in developing application programs in a data base
environment as well as accessing a database through a query language.
Learning Outcomes/
Competencies:
Students in this course
will:
-
Illustrate and describe
what a database is, how one is used, and what the components are
-
Understand and apply the
principles of data modeling and database design
-
Learn to process a
database via SQL and application programs.
-
Learn the features and
functions of DBMS products and apply that learning to MS SQL Server.
-
Understand and apply
technology and products for publishing databases using Internet technology with
JSP.
Textbooks: Database Processing – Fundamentals, Design,
and Implementation
David
M. Kroenke
Prentice-Hall Publishers
Learning Strategies:
Due to the technical nature of the subject
matter, the course material is presented mainly through lecturing. Students are encouraged to participate by
asking questions. Students demonstrate
the course competencies in part by completing periodic programming assignments
and projects
Assessment:
Quizzes 15 % of grade
Homework/Projects
40 % of grade
First
Exam
15 % of grade
Second
exam
15 % of grade
Final
exam
15 % of grade
Class Policy for
Assignments:
Homework problems will be assigned throughout
the duration of the term. Homework will
be collected generally one week from the date assigned. Late homework is subject to an automatic
deduction to be determined by the instructor.
The official class policy is that there is NO MAKE-UP
EXAMS, however in recognition of the occasional personal and/or family
emergency that may occur during the semester, a make-up exam may be granted
provided all the following conditions are met:
1) The instructor is notified of the make-up exam
request by the student on or before
the
scheduled exam date.
2)
A suitable alternate time convenient to the instructor can be
arranged.
2) The missed scheduled exam must be made-up within
one-week of the scheduled
Exam
date.
The granting of make-up exams is NOT an entitlement
but is a courtesy granted to the student by the instructor. If this courtesy is abused by a particular
student or the class as a whole, then the privilege may be revoked.
A missed midterm or final exam will be
assigned a score of zero.
Grading Scale:
A: 92-100 A-: 90-91
B+: 88-89
B: 82-87 B-: 80-81
C+: 78-79
C: 72-77 C-: 70-71 D+: 68-69
D: 62-67 D-: 60-61
F: 59 & below
Class Policy on
Attendance:
Attendance is expected. The quizzes are used as an instrument to
influence attendance and to accumulate points in a way different from the usual
tests. There will be 12 quizzes with
the two lowest scores dropped in the final accounting. This is to allow for times that you are not
able to attend class. MISSED QUIZZES
MAY NOT BE MADE UP. IT IS THE STUDENT'S
RESPONSIBILITY TO CONTACT THE INSTRUCTOR OR ANOTHER STUDENT FOR
INFORMATION/ASSIGNMENTS, ETC. IN MISSED CLASSES. The instructor is more than willing to meet you halfway on this,
but remember that there are TWO halves.
Class Policy on Electronic
Devices:
As a matter of courtesy,
cell phones, beepers, pagers, etc. are generally NOT to be answered in class
and should be switched off. In the
event of necessity, please inform the instructor ahead of time and set the device
to "vibrate" if possible and answer it in the hallway.
Course Outline:
Class Dates: Topics/Assignments:
January 7 Presentation
of Syllabus
Introduction
to Database Processing
Lab
exercise #1
Chapter
1
January 14 Discussion/quiz
Introduction
to Database Development
Lab
exercise #2
Chapter
2
January 21 Discussion/quiz
Data
modeling – The Entity-Relationship
Lab
exercise #3
Chapter
3
January 28 Discussion/quiz
The Relational Model and Normalization
Lab
exercise #4
Chapter
5
February 4 First
Exam
Discussion
Database
Design using Entity-Relation-
Ship model
Chapter 6
February 11 Discussion/quiz
Foundations
of Relational Implementation
Lab
exercise #5
Chapter
8
February 18 Discussion/quiz
Structured
Query Language
Lab
exercise #6
Chapter
9
February 25 Discussion/quiz
Database Application Design
Lab
exercise #7
Chapter
10
March 4 Discussion/quiz
Managing Multi-user Databases
Chapter
11
March 11 Discussion/quiz
Second Exam
Lab
exercise #9
Chapter
13
March 18 Managing
Databases with SQL Server
Discussion/quiz
Lab exercise #10
Chapter
14
March 25 Networks,
Multi-Tier Architectures
Discussion/quiz
Lab
exercise #11
April 1 JDBC,
Java Server Pages
Chapter 16
April 8 Review
for Final Exam
April 15 Final
Exam
Lab
Exercises:
Lab exercises will
include learning Access 2000 and MS SQL Server. In MS SQL Server the DBA, DDL, DML, SQL, Transact-SQL, etc,
functions and components will be explored.
Also a variety of query languages will be learned and explored
including: query-by-example, SQL, and
relational algebra.
Class
Participation:
See “Class Policy on
Attendance” above.
Center
for Academic Excellence:
Tutoring
assistance is free to all students of Calumet College of St. Joseph. Call the
Center for Academic Excellence (CAE), to make an appointment at 473-4287. The
Center has experienced and well-trained tutors in most subject areas to help
students who are struggling in a course or who are doing well and would like to
do better. Regular weekly tutoring sessions are likely to improve your grade.
Statement
of Plagiarism:
If an instructor or other Calumet College of St.
Joseph personnel find that a student has plagiarized or been involved in
another form of academic dishonesty, the instructor or other personnel may elect
to bring the matter up for judicial review. The maximum penalty for any form of
academic dishonesty is dismissal from the College. The procedures for judicial
review are listed under the section of CCSJ handbook that addresses student
grievances. (Academic Planner 2001/2002 p.27)
Citation
Guidelines:
Calumet College
of St. Joseph adheres to citation guidelines as prescribed by the particular
discipline (i.e., MLA, APA, and Chicago Manual of Style or Turabian.). All of these guidelines are available in the
Calumet College of St. Joseph library or bookstore. These texts outline how to cite references from a variety of
sources, including electronic media.
Withdrawal
from Classes Policy:
After the last
day for class changes has passed (see College calendar), students may withdraw
from a course in which they are registered with permission from the faculty
member conducting the course. A written request detailing the reason(s) for the
withdrawal must be filed with the Registrar. Written request for withdrawal
must be received by the Registrar by the last day of classes prior to the final
examination dates specified in the catalogue. Written requests may be mailed to
the Registrar or faxed to the College fax number 219-473-4259. Students are to
make note of the refund schedule when withdrawing from courses. The request is
forwarded to the faculty member, who makes the final determination to accept or
deny the request. If the request is honored, the student will receive
notification of official withdrawal; if denied, the notification will indicate
why the withdrawal is disallowed. Note: Degree Completion Division (DCD)
students should consult the DCD Student Handbook for information on DCD
withdrawals.
An official
withdrawal is recorded as a "W" grade on the student's transcript.
Dropping a course without written permission automatically incurs an
"F" grade for the course (see Refund Schedule).