Calumet College of St. Joseph

SYLLABUS FOR DATABASE MANAGEMENT SYSTEMS

(Directed Study)

Term: Fall, 2002-2003 (021) (Sept. 3 – Dec. 14)

Course Number: CIS 370

Instructor: Mr. Darren Henderson

Office: Room 411

Office Phone: (219) 473-4346

E-mail: dhenderson@ccsj.edu

Office Hours: Monday 3:00 p.m.- 7:00 p.m.

Tuesday 4:00 p.m.- 7:00 p.m.

Thursday 4:00 p.m.- 7:00 p.m.

Saturday 12:00 p.m.- 2:00 p.m.

Instructor Background:

Darren Henderson earned a B. S. in Engineering from Purdue University Calumet and a M. S. in Electrical Engineering from Purdue University with a specialty in Communications and Signal Processing. His undergraduate curriculum was characterized by a strong emphasis in mathematics and physics including courses in Advanced Calculus, Partial Differential Equations, Complex Analysis, Advanced Analysis, Electromagnetic Field Theory, Optics, and Quantum Mechanics. As his undergraduate senior design team project, Darren worked on a prototype for a home security and convenience system that provided a speech synthesis capability. His task was to write the assembly language software for the Motorola HC11 microcontroller and to work with the Texas Instruments speech synthesis chip. Darren’s graduate coursework included courses in Digital Communications, Digital Signal Processing, Image Processing, Computer Networks, and Estimation Theory.

Darren joined the Computer Information Systems Program at Calumet College of St. Joseph in 1995. He regularly teaches the courses C Programming I and II, Hardware and Software Concepts, and Data Communications and Networking Theory. In addition to his teaching activities, Darren has worked for CCSJ's Computer Services Department. He used his engineering background and skills to help lay the groundwork for the school's existing computer network and services. He was responsible for initially creating the faculty and staff e-mail accounts and for making the school's computers (faculty, staff, and 4^th floor computer labs) Internet accessible. His duties involved Unix/Linux and Windows NT System Administration and TCP/IP Network Administration in support of DNS, DHCP, WWW, and e-mail services. He was also responsible for implementing an early firewall to protect the school's Univers database system from unauthorized access. He currently is working on ways of integrating the Blackboard 5 e-learning environment into his courses at CCSJ.

Before his tenure at CCSJ, Darren was an adjunct instructor in the Electronics Technology Department at Ivy Tech State College in Valparaiso. He taught a multitude of courses including: Circuits I and II, Solid State I and II, Digital Principals, Digital Applications, and Electricity for HVAC.

His current research interests are in C++ programming, software engineering for Internet applications, and network security.

Course Time: ARRANGED (see "Schedule of Meeting Times" below)

Course Description: This course will introduce the student to integrated databases, architecture of database systems, storage structures, database management systems, and on-line processing. Students will gain theoretical experience in developing application programs in a database environment as well as accessing a database through a query language.

Prerequisite: CIS 255, CIS 125.

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 either Oracle or SQL Server

· Understand and apply technology and products for publishing databases using Internet technology

Textbook:

Database Processing: Fundamentals, Design, and Implementation, 8^th ed., Kroenke, David M., Prentice Hall, Upper Saddle River, NJ, 2002. (Textbook ISBN 0-13-064839-6) (Oracle version ISBN 0-13-065628-3)

Learning Strategies:

With a directed study mode of delivery, the directed study student is responsible for learning the subject material during the time constraints specified in the “Course Outline” below. Due to the technical nature of the subject matter, supplemental course material (e.g. instructor class notes, assessment exercises ) will be provided as required to the directed study student in either hard copy form or available in downloadable form (e.g. Adobe PDF files or Word documents) on the CIS 370 Blackboard supplement for the directed study student to printout. Periodic consultation sessions will be held throughout the duration of the term. Meeting/session times will be arranged in advance in order to best accommodate the schedules of the Instructor and/or the directed study student. Instructor-Student consultations are also available via electronic mail (e-mail) where deemed appropriate. The purpose of the sessions will be to address questions on reading assignments, supplemental material, homework problems/projects, and exam preparation. However, the sessions should NOT be construed as a formal lecture as with a regularly scheduled class. Students demonstrate the course competencies in part by completing periodic assignments and projects.

Assessment:

The student’s grade is computed using the weights shown below:

Homework Assignments 50%

Semester Project 25%

Final Exam 25%

------

100%

Class Policy for Assignments/Exams:

Homework problems will be assigned throughout the duration of the term. Homework will be collected generally two weeks from the date assigned unless otherwise directed. Late homework is subject to an automatic deduction to be determined by the instructor.

Failure to submit a required homework assignment and/or the semester project by the instructor-specified deadlines will result in an assigned score of zero. Failure to take the Final exam before the conclusion of the term will result in an assigned score of zero.

Exams are typically closed book and closed notes.

The FINAL EXAM is comprehensive!

The function of the homework assignments is that they serve as exam preparation. The function of the final exam is to confirm that the student has achieved the required level of proficiency in the subject material.

Grading Scale:

A: 93-100 A-: 90-92 B+: 87-89 B: 83-86 B-: 80-82 C+: 77-79

C: 73-76 C-: 70-72 D+: 67-69 D: 63-66 D-: 60-62 F: 59 & below

Class Policy on Attendance:

Periodic consultation sessions will be held throughout the duration of the term. Meeting/session times will be arranged in advance in order to best accommodate the schedules of the Instructor and/or the Directed Study student(s). Instructor-Student consultations are also available via electronic mail (e-mail) where deemed appropriate. The purpose of the sessions will be to address questions on reading assignments, homework problems, and exam preparation. However, the sessions should NOT be construed as a formal lecture as with a regularly scheduled class.

Course Outline:

	Topics/Assignments:
WEEK 1	Syllabus/Directed Study Orientation
WEEK 2	Chapter 1 – Introduction to Database Processing
WEEK 3	Chapter 2 – Introduction to Database Development
WEEK 4	Chapter 3 – The Entity-Relationship (ER) Model
WEEK 5	Chapter 5 – The Relational Model and Normalization
WEEK 6	Chapter 6 – Database Design Using ER Models
WEEK 7	Chapter 8 – Foundations of Relational Implementation
WEEK 8	Chapter 9 – Structured Query Language
WEEK 9	Chapter 10 – Database Application Design
WEEK 10	Chapter 11 – Managing Multi-User Databases
WEEK 11	Chapter 12 – Managing Databases with Oracle OR Chapter 13 – Managing Databases with SQL Server 2000
WEEK 12	Chapter 14 – Networks, Multi-Tier Architectures, and XML
WEEK 13	Chapter 15 – ODBC, OLE DB, ADO, and ASP OR Chapter 16 – JDBC, Java Server Pages, and MySQL
WEEK 14	Final Exam Review
WEEK 15	Final Exam

Schedule of Meeting Times: (Tentative)

	Day	Date	Time/Agenda
WEEK 1	Thursday	9/5/2002	5:00 P.M. - 6:00 P.M. ROOM 411
WEEK 2	Monday	9/09	E-Mail Consultation
WEEK 3	Monday	9/16	5:00 P.M. - 6:00 P.M. ROOM 411
WEEK 4	Monday	9/23	E-Mail Consultation
WEEK 5	Monday	9/30	5:00 P.M. - 6:00 P.M. ROOM 411
WEEK 6	Monday	10/07	E-Mail Consultation
WEEK 7	Monday	10/14	5:00 P.M. - 6:00 P.M. ROOM 411
WEEK 8	Monday	10/21	E-Mail Consultation
WEEK 9	Monday	10/28	5:00 P.M. - 6:00 P.M. ROOM 411
WEEK 10	Monday	11/04	E-Mail Consultation
WEEK 11	Monday	11/11	5:00 P.M. - 6:00 P.M. ROOM 411
WEEK 12	Monday	11/18	E-Mail Consultation
WEEK 13	Monday	11/25	5:00 P.M. - 6:00 P.M. ROOM 411
WEEK 14	Monday	12/02	E-Mail Consultation
WEEK 15	Monday	12/09	4:00 P.M. - 6:00 P.M. ROOM 411 Final Exam

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).