This site will look much better in a browser that supports web standards, but it is accessible to any browser or Internet device.

          Management Training

Logical Data and Process Modeling

Duration: 5 Days (10 am to 5 pm with one hour lunch break)

Cost: $ 1999 + GST

Course Outline

Learn How To

  • Create more accurate and complete requirements
  • Use diagramming to communicate project scope
  • Create a data model to define and describe project requirements
  • Create and use functional decomposition diagrams, entity relationship diagrams and dataflow diagrams
  • Use dataflow diagrams to validate data and process models

 

Course Synopsis

In today's complex business environment, integration of multiple functional areas combined with fuzzy requirements is a fact of life—a picture is truly worth a thousand words. The techniques used in logical data and process modeling focus on presenting a complete picture of the important requirements of the business (and the related project) through significant user involvement in the analysis phase.

This course provides techniques for effectively analyzing and modeling any area of your business and creating logical data and process models that show how data flows and work progresses. The approaches taught in this class are designed to focus the attention on the important requirements of the business that are discovered through significant user involvement during the analysis phase.

Participants will learn how to create models without being limited by technology or organizational structure. The course exercises are designed to reinforce the techniques taught in class—entity relationship diagramming, functional decomposition diagramming and dataflow diagramming.

Reminder: Prior to taking this course, you should have acquired the background as taught in How to Gather and Document User Requirements.

 

Course Topics

  1. Introduction
    1. System development challenges
    2. Benefits of modeling
    3. Components of logical process models: moving from dataflow to process
    4. Characteristics of essential modeling
  2. Approaches to Functional Decomposition
    1. Concepts of Perfect Technology
    2. Top down and bottom up approaches
    3. Event partitioning
    4. Using functional decomposition diagrams
  3. Introduction to Logical Data Modeling
    1. Purpose and components
    2. Data redundancy and derived data
    3. Different levels of data modeling
  4. The Conceptual Data Model
    1. Discovering entities, attributes and relationships
    2. Analyzing attributes and choosing unique identifiers
    3. Relationships and cardinality
  5. The Logical Data Model
    1. Super-types and sub-types
    2. Attributive and associative entities
    3. Documenting data constraints
  6. Normalization and the Physical Data Model
    1. The physical data model
    2. The role of the database designer
  7. The Process Diagram in Context
    1. Purpose and components
    2. Rules and conventions
    3. Leveled data flow diagrams
  8. Verifying and Presenting Models
    1. Accuracy and completeness
    2. Internal verification and external validation
    3. Effective presentation
  9. CASE Tools and Transition to OO/UML
    1. Major functions of CASE tools
    2. Introduction to Object Orientation (OO) and Unified Modeling Language (UML)
    3. Impact of OO/UML on the business analyst

 

For more information on above course, please call us at 416-926-0616 or e-mail to marketing@key2careers.net