IFSM 410

UNIVERSITY OF MARYLAND SYSTEM Term VI 2000-2001

UNIVERSITY COLLAGE Saturday & Sunday 9:00 to 16:00

Brussels; Belgium 31 March / 1 April; 21 / 22 April;

5 / 6 May; 19 / 20 May

Lecturer: Manfred Trostmann

Tel. 0617178194; 01715496690

IFSM 410 DATABASE PROGRAM DEVELOPMENT

PREREQUISITE: IFSM 201 or CMIS 102, IFSM 300, or permission of professor. IFSM 310 recommended

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

PROCEDURES

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 SCHEDULE 

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