Data Modeling

Audience

Application systems analysts & database analysts responsible for organizing and documenting logical data structures to satisfy user data requirements.

Description

The purpose of this class is to objectively present the Computer Associates product, ADS/0 and how to apply it to a basic application.  The seminar is designed to provide an understanding of how ADS/0 works so that students can write the most effective dialogs. 

Benefits

       Understand the advantages of a shared database system over a traditional file processing system.

       Utilize entity and relationship modeling techniques to originate logical data structures.

       Apply the principles of data normalization to generate data element groupings with minimal data redundancy.

       Document data volumes and data usage by procedures to accommodate the subsequent physical implementation on some database management system.

Outline/Table of Contents

Entity Identification & Classification

Relationship between Entities

Data Modeling Notation

Data Element Naming Guidelines

Relational Concepts

Data Normalization

Primary & Foreign Keys

Entity Volumes & Relative Frequencies

Process Definition/Data Usage