IS 623 - Database Management
CRN
 2699-101
Semester
 Fall - 2002
Dates
 Thursdays, August 29 through December 12
Location/Times
 6:30 to 9:00 PM, Room GC 217, South Charleston

Texts and Study Materials
Required Text(s)
Ramakrishnan and Gehrke
Database Management Systems (2nd Ed)
McGraw-Hill
ISBN: 0-07-232206-3

Instructor
Name
 Jonathan Thompson
Office GH109A
1 John Marshall Drive
Huntington, WV 25755
Office Hours
 By Appointment
Phone
 304-696-6349
E-mail
 thompsonj@marshall.edu

Course Description
Review of information structures and of relationships among data elements and objects. Relational database theory; design and organization of databases, retrieval structures, and query mechanisms.
Credits 3 semester hours
Prerequisites IS-622 or consent

Course Discussion

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 Information Structures, has a good programming background, and understands file structures and file processing techniques.

The course covers the concepts of designing a database, normalizing the data structures, implementing the database and retrieving data (using stand-alone files, a database management system, and XML technologies), and understanding several of the core design issues that confront database management system developers.

The emphasis of the course this semester is to gain hands-on experience in the design and implementation of databases. To that end, most class time will be devoted to lab exercises that will either demonstrate or implement the reading and lecture material.

Grading

Grades will be based on homework assignments, lab exercises, and exams done individually or in small groups. Grading will necessarily be somewhat subjective. The quality and professionalism of your written material will be major factors in your grades.

In assigning grades I use the following guide: An 'A' indicates work of distinction at the graduate level; 'B' indicates competent and acceptable work, and a grade of 'C' indicates work below the expected standards for graduate students.

Relative Weights
Mid-Term
20%
Final
20%
Lab Exercises
 50%
Homework
 10%

Schedule of Topics (Subject to Change)
No Date

Read Before Class

 Topic(s)
1 29-Aug   Course Introduction
2 05-Sep 1, 2 E/R Model
3 12-Sep 5 SQL: Retrieving Data
4 19-Sep 3 SQL: Tables and Views
5 26-Sep 15 and WebCT Normalization
6 03-Oct 17, 19 Client-Server and Security
7 10-Oct   Project A
8 17-Oct   Project B
9 24-Oct   Midterm
10 31-Oct 7 Disks and Files
11 07-Nov 8 File Organization
12 14-Nov 9 Tree-Structured Indexing
13 21-Nov 22 and Handout XML and XSL
  28-Nov   Thanksgiving Break
14 05-Dec

Handout

 XML and SQL
15 12-Dec   Final Exam