Skip to content.

Sections
Home » World-Class Training » World-Class Enterprise Information Management Training » Conceptual Data Modeling – Resisting the Urge to go Physical

Conceptual Data Modeling – Resisting the Urge to go Physical

Objectives

The objectives of the course are to:

  • Understand what a Conceptual Data Model is and how it is used
  • Understand the problems caused by foregoing Conceptual Data Modeling
  • Understand how Conceptual Data Models will improve data and information quality and improve project success
  • Learn how to develop CDM’s
  • Learn how to use CDM’s to understand business requirements and validate understanding with the business

You will:

  • Analyze a real-life example of a problematic data model and understand the impact of not identifying proper relationships and cardinality
  • Learn how a Conceptual Data Models differs from other types of data models
  • Understand best practices for a phased modeling approach
  • Learn a common modeling notation and develop CDM’s for a class exercise in a small team environment
  • Learn how to utilize CDM’s to validate business understanding and to develop downstream logical and physical models
  • Learn about the different types of Conceptual Data Models
  • Learn why an Enterprise Conceptual Data Model is a critical enabler of enterprise-wide endeavors, e.g. data governance and stewardship, ERP, SOA, DW/BI, etc.

Seminar Content

  • Introduction
  • Discuss problems that happen when an organization does not “resist the urge” to develop physical and logical models before completing a Conceptual Data Model
  • Identify causes leading to this common (not best) practice
  • Analyze sample real-world models not developed after a Conceptual Data Model
  • Define what a Conceptual Data Model is and is not
  • Conceptual Data Models and data/information quality
  • Learn top-down, bottom-up methodology for developing Conceptual Data Models
  • Information Engineering notation review
    • Entity types
    • Relationship notation
    • Cardinality notation
    • Subtyping
  • Data Model types
    • Subject Area Model
    • Types of Conceptual Data Models
      1. Scoping CDM
      2. Business CDM
      3. Application CDM
      4. Enterprise CDM
    • Logical Data Model (LDM)
    • Physical Data Model (PDM)
  • Converting a CDM into a LDM
  • Logical Data Model to a Physical
  • CDM and LDM nomenclature, including discussion of ISO11179 Part 5
  • Review of ISO11179 Part 4 regarding data definition
  • Meta data and Conceptual Data Models
  • Phased modeling approach
  • Data model presentations for different types of audiences
  • Class exercises
  • Workshop summary, additional exercises and reference materials

To learn more about how EWSolutions can provide our World-Class Training for your company or to request a quote, please feel free to contact David Marco, our Director of Education at DMarco@EWSolutions.com or call him at 630.920.0005 ext. 103.

/>