Description:
This course introduces the concepts and techniques associated with construction and design of database management systems. The topics to be explored include various database processing environments, access methods, data modeling, relational algebra, and database design.

Course Objectives:
Upon completion of the course the student will be able to:

1. Understand the impact that database designs have on user interfaces and application program structure;
2. Design and implement a relational database and supporting applications;
3. Design and implement a data dictionary for a relational database;
4. Understand multi-user database processing on LANs in client-server systems.

Required Materials:
Textbooks:
Database Systems Design, Implementation, and Management
Peter Rob, Carlos Coronel
Course Technologies

Delphi 2 Unleashed
Charles Calvert
Borland Press

Materials:
(5) 3 1/2" diskettes

Methods of Instruction:

1. Lecture
2. Laboratory Assignments
3. Programming Examples

Minimum Course Requirements:

1. The reading of all assigned textbook chapters;
2. Participation in class discussions;
3. The completion of database design project.

Method of Evaluation:
Passing average on all quizzes and examinations (75% or better); passing average on database design project and homework assignments (70% or better); and passing grade on the final examination (75% or better).

Course Content Outline:

1.File Systems and Databases

1.1 File Systems
1.2 Database Systems
1.3 Database Models

2.1 Logical View of Data
2.2 Integrity Rules
2.3 Relational Database Operators
2.4 Relational Database Software Classification
2.5 Data Redundancy

3.1 Data Definition Commands
3.2 Data Management
3.3 Queries
3.4 Advanced Data Management Commands

4.1 Conceptual Model
4.2 Internal Model
4.3 External Model
4.4 Physical Model

5.1 The E-R Model
5.2 Developing an E-R Diagram

6.1 Normalization
6.2 First Normal Form
6.3 Second Normal Form
6.4 Third Normal Form
6.5 Boyce-Codd Normal Form

7.1 Systems Development Life Cycle
7.2 Database Life Cycle

8.1 Conceptual Design
8.2 Logical Design and Implementation

9.1 Client/Sever Environment
9.2 Client/Sever Architecture
9.3 Managerial Expectations