Objectives

The objectives of the course are to:

• Demonstrate to managers and executives the concepts and processes used in logical data modeling

• Explain how analyst approach an enterprise or business area, identifying data components and relationships among them

• Show how analysts model data for an enterprise and represent it via entity-relationship diagrams

• Understand design compromises among flexibility, performance, ease of use and cost

• Understand considerations for the physical database design

Seminar Content

Course Topics

I. Roles, Definitions and Key Principles

• Critical role of the business analyst / data analyst in the enterprise

• Creating and adopting a formal enterprise modeling strategy

• Roles and mutual expectations among team members of an enterprise data modeling project

II. Capturing Requirements for Data Modeling

• Identify critical consumers

• Understand the structure of a Data Model

III. Types of Requirements

• Attributes and types of enterprise requirements versus application requirements

IV. Review of Data Modeling Concepts and Principles

• Phases of application development

• Importance of building data models

• Overview of the types of data models

V. The Data Modeling Process, An Overview

• Relationship types

• E-R diagrams and how to read them

• Keys in Enterprise Data Modeling

• Normalization for the enterprise

• Patterns in Data Modeling

• Addressing missing data and data redundancy

• Issues and Challenges for Data Modeling and Data Analysis

• Workshop Summary, Additional Exercises and Reference Materials