Graduate | Current Syllabi | Term005 |

UNIVERSITY OF MARYLAND UNIVERSITY COLLEGE

EUROPEAN DIVISION

BOWIE STATE UNIVERSITY

GRADUATE PROGRAM IN MANAGEMENT INFORMATION SYSTEMS

INSS 550 DATABASE MANAGEMENT AND DECISION SYSTEMS

Location : London Education Center

Dates : Term 5 2000/01 Weekends 2/3,16/17 June;7/8,21/22 July 2001

Times : Saturday Sunday 0900-1600 (Lunch 1200-1300)

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. Fourth Edition 2000 ISBN 0-7600-1090-0

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
Weekend #1	1	File Systems and Databases	1
	2	The Relational Database Model	2
	3	SQL	3
	4	Entity-Relationship Modeling	4
Weekend # 2	5	Database Table Normalization	5
	6	Database Design	6
	7	Database Design
	8	Transaction Management	9
Weekend # 3	9	Midterm Exam
	10	Distributed Databases	10
	11	Object-oriented Databases	11
	12	Client-Server Systems	12
Weekend # 4	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/maryland/ ( 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

45 Rockingham Road, Uxbridge, Middlesex UB8 2TZ, UK

Telephone : +44 (0)1895 257627

0771 046 1770 (Mobile)