contact us for details
Duration & Location
2 days - online and onsite*
*min of 8 for onsite delivery
Participants should have worked on the analysis, development, maintenance or enhancement of at least one business ‘product’, whether it is software, business processes, services, etc.
This seminar is designed for business analysts, application developers/analysts, project leaders and data/database administrators.
This course introduces people to the principles and processes of logical data modelling, which is to translate business data requirements into a graphical representation. It teaches people how to analyze business requirements that should be incorporated into a logical data model, how to create the components of a logical data model, how to diagram/explain them, and how to normalize data and handle complex relationships. In short, participants will learn proven, practical skills for analyzing and modelling data requirements, and make them ready to be transformed into a relational database.
Knowledge Areas Covered
PMBOK Knowledge Areas
Project Stakeholder Management | Project Scope Management | Project Quality Management
BABOK Knowledge Areas
Requirements Analysis and Design Definition
Key Learning Objectives
- describe some of the benefits and advantages of performing logical data modelling
- explain the distinction between logical data modelling and physical database design
- identify the components of a data model, including entities, relationships and attributes
- normalize entities to fifth normal form and select proper unique identifiers (primary keys)
- handle complex relationships:
- sub-types and super-types
- recursive/’bill of materials’
- document the data model with an entity/relationship diagram and walk through portions of a data model with people to validate it