UNIVERSITY OF MARYLAND UNIVERSITY COLLEGE

EUROPEAN DIVISION

BOWIE STATE UNIVERSITY

GRADUATE PROGRAM IN MANAGEMENT INFORMATION SYSTEMS

INSS 550 DATABASE MANAGEMENT AND DECISION SYSTEMS

 

Location         : Education Center, Stuttgart

Dates               : Term 2 2002/2003 28th. October - 20th December 2002

Times              : Tuesday/Thursday 1830-2130

Lecturer          : Chris Payne PhD

Prerequisites  : Either INSS 510, INSS 520,INSS 530 or instructor permission.

Text                 : Database Systems, Design, Implementation and Management

                          by Peter Rob and Carlos Coronel

                          Published by Course Technology Fifth Edition 2002

                           ISBN 0-619-06269-X

Course Description   

This course examines database concepts and practices as they relate to business environments. Various database structures, including relational and object-oriented are discussed. Concepts of distributed database architecture are explored. Design, development and implementation of databases are examined. Organizational issues concerning the implementation of databases are also examined. The role of data in the decision-making process is examined. Decision support system architecture is reviewed with an emphasis on the database component. Issues of intelligent databases are discussed. A database project is required.

 

Course Description

      At the conclusion of this course, the student will demonstrate :

            1. An understanding of the terminology of database technology;

2. An ability to normalize database tables and an understanding of its importance;

3. An ability to write accurate SQL statements;

4. A facility with data modeling;

5. An appreciation of modern trends in database usage including intelligent databases, object-oriented databases and distributed databases;

6. An understanding of how databases are used in the World Wide Web.

 

Grading         

      Grades for this course will be assigned as follows.

            A    92%+

            B    80 - 91%

            C    70 - 79%

            F     Below 70% or regular non-attendance

           

Course Requirements

            Midterm exam              35%

            Final exam                    35%

            Project                         30%

 

 

	SCHEDULE OF TOPICS
Session	Subject	Reading
1.	File Systems and Databases	Ch. 1
2.	The Relational Database Model	Ch. 2
3.	Entity-Relationship Modeling	Ch. 3
4.	Database Table Normalization	Ch. 4
5.	SQL	Ch. 5
6.	Database Design Methods	Ch. 6
7.	Transaction Management	Ch. 9
8.	Midterm Exam
9.	Distributed Databases	Ch. 10
10.	Object-Oriented Databases	Ch. 11
11.	Client-Server Systems	Ch. 12
12.	Data Warehouses	Ch. 13
13.	Databases and the Internet	Ch. 14
14.	Web Database Development	Ch. 15
15.	Database Administration	Ch. 16
16.	Final Examination and Project Hand-in

 

                                   

The Project    

 Students will work on an individual project to develop an application from user requirements through data modeling to implementation and testing. The project details will be distributed in the first class session when details of its scope and the grading of it will also be discussed.    

 

Instructor  Contact

 

Office Hours   : Before or after class or by appointment at other times.

Email              : chris_payne60@hotmail.com

                          chris-payne60@wanadoo.fr

                          cpayne@faculty.ed.umuc.edu

Telephone       : 0033 296 13 10 70 (Out of term time only)

                          Local phone number TBA

Addresses        : Graduate Program, University of Maryland, Unit 29126, APO AE 09102

                          Graduate Program, University of Maryland, Im Bosseldorn 30,

                                    69126 Heidelberg, Germany

                           5 Kerbouret-Izellan, 22720 Plésidy, France

 

Dr. Chris Payne

SHAPE, Belgium

September 2002