UNIVERSITY OF MARYLAND SYSTEM Term I 2000-2001

BOWIE STATE UNIVERSITY Saturday & Sunday  9:00 to 16:00  19/20AUG; 2/3,16/17,30SEP; 1OCT

RHEINMAIN Germany

Lecturer: Manfred Trostmann

INSS 550 DATABASE MANAGEMENT AND DECISION SYSTEMS

PREREQUISITE: INSS 510, 520, 530 or permission of professor.

CREDIT: Three (3) semester hours.

PURPOSE: The fundamental purpose of this course is to increase the student’s understanding of how data resources can be managed to effectively support information systems in organizations

COURSE OBJECTIVE: This course enables students to understand:

1) Data as a valuable organizational resource requiring management to further the objectives of the organization.

2) The use of automated systems to manage this valuable resource.

3) Basic concepts of database architecture, database design and administration, and database implementation

TOPICS

• Database Environment
• Database Concepts, Characteristics and Planning
• Physical Data Organization
• Data Structures
• Data Models
• Introduction to Database Design
• Conceptual design Tradeoffs
• Implementation and Physical Design
• Database Administration
• Database Systems, Hierarchical/Network
• Relational Implementations
• Database Management, Opportunities/Issues

The course will consist of a series of lectures, as shown in the outline. Students are expected to read appropriate sections of text and handouts before coming to class.

COURSE REQUIREMENTS

There will be two examinations. These exams will be designed to help you improve your under standing of the basic concepts discussed in the course. As such, these exams will be a mix of short answers as well as essay questions.

RESEARCH PROJECT

The class will be organized into teams for the project completion. Both team and individual grades will be awarded for the project. The purpose of the project is to give the student an opportunity to bring the information and concepts learned in the course to bear on a topic of the students interest.

TEXT. DATABASE SYSTEMS by Peter Rob Carlos Coromel Third Edition.

GRADING: Grades for this course will be based on

Midterm.............................25%

Final...................................35%

Project……………………40%

and will be assigned as follows:

A 93 to 100

B 84 to 93

C 60 to 84

F less than 60
 
 

SESSION                      SUBJECT                            TEXT READING ASSIGNMENT

1                  File Systems and Databases                                            Ch 1

2                  The Relational Database Model                                      Ch 2

3                  An Introduction to Structured Query Language (SQl)     Ch 3

4                  Entity Relationship                                                         Ch 4

5                  Normalization of Database Tables                                  Ch 5

6                  Database Design                                                            Ch 6

7                  The University Lab: Conceptual Design                         Ch 7

8                                              MIDTERM

9                  The University Lab: Conceptual Design Verification, Logical

                    Design, and Implementation                                            Ch 8

10                Transaction Management and Concurrency Control        Ch 9

11                Distributed Database Management Systems                    Ch 10

12                Object-oriented Databases                                              Ch 11

13                Client/Server Systems                                                     Ch 12

14                The Data Warehouse                                                      Ch 13

15                Database Administration                                                 Ch 14

16                                            FINAL