About This Event

This data modelling workshop by Alec Sharp introduces Entity-Relationship modelling from a non-technical perspective, provides tips and guidelines for the analyst, and explores contextual, conceptual, and detailed modelling techniques that maximize user involvement.

This workshop introduces entity-relationship modelling from a non-technical perspective, thoroughly covering the basic components of a data model – entities, relationships, attributes, and identifiers.  In addition to showing how and when to use these components in developing a data model, it includes far more advice on the process of developing a data model than other courses, including specific methods for getting subject matter experts involved and maintaining their commitment. The content is presented within the context of a clearly-defined, three-phase data modelling methodology that supports progressive detail and precision.

Learning objectives

On workshop completion, participants will be able to:

  • Use entity-relationship modelling to depict facts and rules about business entities at different levels of detail, including conceptual (overview) and logical (detailed) models
  • Use top-down and bottom-up approaches to initiating development of a data model
  • Recognize the four basic patterns in data modelling, and when to use them
  • Effectively use definitions and assertions (“rules”) as part of data modelling
  • Use an intuitive approach to data normalization within an entity-relationship model
  • Apply various techniques for discovering and meeting additional requirements
  • Read a data model, and communicate with specialists using the appropriate terminology.