Logical Data Modeling-Haughey

Logical Data Modeling

This course is about taking knowledge of the business and its rules and converting these into a stable data model. A practical case study is used throughout the workshop. The case study provides experience with data identification, normalization, detailed data identification and model verification.

Objectives

Learn a rigorous method for defining data.
Learn how to gather the data, define and analyze business rules
Understand basic data modeling concepts
Understand normalization, abstraction, aggregation
Understand how to consolidate models
Learn how to develop and produce data models that are :

Independent of implementation and organizational structure
Accurate representation of the business
Stable
Simple (because they use refinement)
Appropriately scoped
Based on sound theoretical principles
Easy to understand

Learn state of the art refinement techniques like subtyping and recursive relationships
Understand and learn how to do data modeling rapidly.

Duration 2-3 days

Who Should Attend

Business and Systems Managers, Business and Systems Users, Business Systems Analysts, Systems Analysts, Project Managers, Project Team Members, Data/Database Administrators.

Course Format Lecture, group discussion, exercises

Instructor Tom Haughey