INFORMATION SYSTEMS --- IS-623 DATABASE MANAGEMENT

Fall, 2004

Dates: Wednesdays, August 24 through December 8

Place: GC Room 136 – South Charleston

Time: 6:30 – 9:00 pm

Texts: “Database Processing: Fundamentals, Design & Implementation”

David M. Kroenke Prentice Hall (9^th Edition)

Facilitator: John R.Biros

Office: GC 331 South Charleston

Office Hours: By Appointment

Phone: (304) 746-1941

E-mail: jbiros@marshall.edu

Credits: 3 Semester Hours

Prerequisites: IS-622 or Instructor’s Permission

Course Description:

This course is directed towards advanced students in the Information Systems program. It assumes the student is familiar with the basic concepts of information systems, has a firm grasp of the concepts covered in the Information Structures courses, has a good programming background, understands file structures and understands file processing techniques.

The course is designed to cover the concepts of designing a database, normalizing the data structures, implementing the database and being able to retrieve data with effective database queries.

While the course is a theory course designed to cover the concepts of database management, there will be a significant number of projects that will require hands-on experience. For the personal databases, the class will use Microsoft Access. For larger databases, the class will use Microsoft SQL Server. In addition, there may be some hands-on with other database systems.

Each student is expected to select a system to analyze, document and implement during the course of this semester. The system results will be presented to the rest of the class as part of the final exam.

Attendance at class is not mandatory but highly recommended. Class discussion will be a significant part of the course and all students are encouraged to participate in the discussion.