Graduate | Current Syllabi | Term015 |

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, Menwith Hill, Harrogate, N. Yorks. UK

Dates : Term 5 2001/02 June 3rd - July 26th. 2002

Times : Tuesday/Thursday 1630-1930

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 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 Objectives At the conclusion of the 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 comprehensive SQL statements;
4. A facility with data modeling;
5. An appreciation of all 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

The grade of ‘I’ -Incomplete is rarely awarded

Course Requirements

Midterm exam 35%

Final exam 35%

Project 30%

SCHEDULE OF TOPICS

Session

Class #	Subject	Chapter
1	File Systems and Databases	1
2	The Relational Database Model	2
3	SQL	3
4	Entity-Relationship Modeling	4
5	Database Table Normalization	5
6	Database Design	6
7	Database Design
8	Transaction Management	9
9	Midterm Exam
10	Distributed Databases	10
11	Object-oriented Databases	11
12	Client-Server Systems	12
13	Data Warehouses and Data Mining	13
14	Databases and The Internet	14
15	Database Administration	15
16	Final Examination

The Project Students will work on a project either singly or in groups of no more than two people. The project will develop an application from user requirements through data modeling to implementation and testing. The project will be distributed in the first session of the class when details of the scope and grading of it will be discussed.

Instructor Contact

Website : http://www.uomd.freeserve.co.uk/ ( Includes a short instructor biography. )

Office Hours : Before or after class or by appointment outside class hours.

Email : chris_payne@uomd.freeserve.co.uk

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

Graduate Program, University of Maryland, Im Bosseldorn 30, 69126 Heidelberg , Germany

Telephone : 0771 046 1770 (Mobile)

Dr. Chris Payne

Feltwell, Norfolk, UK

April 2002