UNIVERSITY OF MARYLAND SYSTEM Term I 2000-2001

BOWIE STATE UNIVERSITY Saturday & Sunday 9:00 to 16:00

RHEINMAIN Germany 19/20AUG; 2/3,16/17,30SEP; 1OCT

Lecturer: Manfred Trostmann

IFSM 410 DATABASE PROGRAM DEVELOPMENT

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.

.

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

GRADING: Grades for this course will be based on

Midterm.............................45%

Final...................................55%

and will be assigned as follows:

A 93 to 100

B 84 to 93

C 73 to 84

D 60 to 73

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