UNIVERSITY SYSTEM OF MARYLAND

BOWIE STATE UNIVERSITY

Location : RAF Lakenheath

Dates : Term 1 2000/01 Aug. 21 - Oct 11 2000

Times : Mon - Wed 1800-2100

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

Midterm exam 35%

Final exam 35%

Project 30%

SCHEDULE OF TOPICS

Session

1 

File Systems and Databases 

Ch. 1 

2 

The Relational Database Model

Ch. 2 

3 

SQL

Ch. 3 

4 

Entity-Relationship Modeling

Ch. 4

5 

Database Table Normalization

Ch. 5 

6 

Database Design Methods

Ch. 6

7 

Transaction Management

Ch. 9 

8 

Midterm Examination

9 

Distributed Databases

Ch. 10

10 

Object-Oriented Databases

Ch. 11

11 

Client-Server Systems

Ch. 12

12 

Data Warehouses and Data Mining

Ch. 13

13 

Databases and the Internet

Ch. 14

14 

Data Administration

Ch. 15

15 

Course Review

16 

Final Examination and Project Hand-in

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

Biography There is a short instructor biography at http://www.uomd.freeserve.co.uk/

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

Email : chris_payne@uomd.freeserve.co.uk

100737.2314@compuserve.com

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) 01895 257627

041 046 1770 (Mobile)

Return to: Graduate Programs Syllabi