SYLLABUS FOR DATABASE
MANAGEMENT SYSTEMS
Term: Spring, 2004-2005
(042) (January 10 – April 23)
Course Number: CIS 370X
Instructor: Br. Jerry Hall
Office
Phone: 473-4268
E-mail: jhall@ccsj.edu
Office
Hours: MR 10:30 AM to 12:00 Noon
M 1:00 PM to 1:50 PM
TW 9:00 AM to
12:00 Noon
T 1:00 PM
to 3:00 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
Description:
This course will
introduce the student to integrated databases, 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, 9th ed.
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:
|
Grade |
Points |
|
A |
100-92 |
|
A- |
91-90 |
|
B+ |
89-88 |
|
B |
87-82 |
|
B- |
81-80 |
|
C+ |
79-78 |
|
C |
77-72 |
|
C- |
71-70 |
|
D+ |
69-68 |
|
D |
67-62 |
|
D- |
61-60 |
|
F |
59 and 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.
A student missing more than 9 hours of class time will be asked to
withdraw from the class.
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 13 Presentation
of Syllabus
Introduction
to Database Processing
Lab
exercise #1
Chapter
1
January 20 Discussion/quiz
Entity-Relationship
Data Modeling Lab
exercise #2
Chapter
2
January 27 Discussion/quiz
Data
modeling – The Entity-Relationship
Lab
exercise #3
Chapter
3
February 3 Discussion/quiz
The Relational Model and Normalization
Lab
exercise #4
Chapter
4
February 10 First
Exam
Lab exercise
February 17 Introduction
to SQL Lab
exercise #5
Chapter
6
February 24 Discussion/quiz
Structured
Query Language
Lab
exercise #6
Chapter
6 Continued
March 3 Discussion/quiz
Database
Design
Lab
exercise #7
Chapter
5
March 10 Discussion/quiz
Using SQL in Applications
Chapter
7
March 17 Second
Exam
Lab
exercise # 9
March 31 Managing
Multi-user Databases
Discussion/quiz
Lab
exercise #10
Chapter
9
April 7 Managing
Databases with SQL Server 2000
Discussion/quiz
Lab
exercise #11
Chapter
11
April 14 ODBC,
JDBC, Java Server Pages
Chapters 12, 13, 14
Review
for Final Exam
April 21 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.
Please note:
Calumet College of St. Joseph subscribes to Turnitin.com and all papers can and
may be submitted for checks on plagiarism from the Internet/Electronic
sources/Databases.
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. The Registrar must receive written
request for withdrawal 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.
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).
Administrative Withdrawal
To protect a student from failing a course, a faculty member may initiate an
administrative withdrawal of a student who misses two or more consecutive weeks
of classes.
Academic Alerts
In an effort to keep you informed of serious problems affecting your ability to
pass this course, students who are in jeopardy of not passing may receive an
Academic Alert to notify them of the situation and the remedial actions they
should take to put them in good academic standing.
School Closing
Information:
Internet: http://www.ccsj.edu
http://www.EmergencyClosings.com
Facility:
Calumet College of St. Joseph
Phone:
219.473.4770
Radio:
WAKE
– 1500 AM
WGN - 720 AM
WIJE
– 105.5 FM
WLS
– 890 AM
WZVN
– 107.1 FM
WBBM
NEWS RADIO 78
TV Channels: 2,
5, 7, 9, 32