CIS 370
DATABASE MANAGEMENT SYSTEMS
Syllabus
Term: Spring, 2006
Instructor: Kurt Jordan
Office Phone: 473-4290
E-mail: kjordan@ccsj.edu
Office
Hours:
Monday 9:00 am - 1:30 pm, 5:00 pm - 7:00 pm
Tuesday
9:00 am - 1:30 pm
Wednesday
9:00 am - 12 noon, 6:00 pm - 7:00 pm
Thursday
9:00 am - 1:30 pm, 5:00 pm - 7:00 pm
Friday by appointment only
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:
After completing this course, students will:
Describe what a database is, how one is used, and what its components are
Understand and apply the principles of data modeling and database design
Learn to access 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, 10/E, David Kroenke, ISBN: 0-13-167267-3, Publisher: Prentice Hall
Learning Strategies:
The format of the course will be lecture and lab. Due to the technical nature of the subject matter, the course material is presented mainly through lecturing and in-class demonstrations. Students are encouraged to participate by asking questions. Students demonstrate the course competencies in part by completing assignments and projects in the lab.
A short research paper (one or two pages) will be turned in
on the last week of classes. Topics must be approved in advance by the
instructor. You will choose a topic related to some feature, function,
capability or component of a relational database management system. Your paper
should describe the feature, function, capability, or component, explain when
or why you might use it, describe some of the most frequently used parameters
or settings, and give an example of its use. If you follow the outline described
in the previous sentence, there is no reason why you should not get an A on the
research paper.
Assessment:
Exams 60%
Labs/homework/paper 40%
Class Policy for Assignments:
Homework and lab problems will be assigned throughout the duration of the term. Homework and labs will be collected generally one week from the date assigned. Late homework will be marked 50% off.
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
will be taken each meeting for administrative and grading purposes. You are
expected to attend every class. You are
responsible for any material you miss.
Make-up exams will be given only if prior arrangements are made with the
instructor. The instructor reserves the right to change these policies in
extreme circumstances.
Class Policy on Electronic Devices:
As a matter of courtesy, cell phones, beepers, pagers, etc. are generally NOT to be answered in class. Please set the device to non-audio notification if possible and answer it in the hallway.
Course Outline:
Week 1 Introduction to course Chapter 1
Week 2 Chapter 3
Homework 1 due
Week 3 Chapter 3 Homework 3
Week 4 Chapter 4 Homework 4
Homework 3 due
Week 5 Chapter 5
Homework 4 due
Week 6 Chapter 5 Homework 5
Paper topics due
Week 7 Exam, Chapters 1, 3-5
Homework 5 due
Week 8 Chapter 6 Homework 6
Week 9 Chapter 2
Homework 6 due
Week 10 Chapter 2 Homework 2
Week 11 Chapter 7 Homework 7
Homework 2 due
Week 12 Chapter 8 Homework 8
Homework 7 due
Week 13 Chapter 9 Homework 9
Homework 8 due
Week 14 Open lab Paper due Review for Final Exam
Homework 9 due
Week 15 Exam chapters 2, 6-9
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.
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.