Mindavation > Data Modelling

Data Modelling

Course Cost:

$1500 per/person + GST

Duration & Location

2 days - online and onsite*
*min of 8 for onsite delivery

Development Units

14

Pre-Requisites

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.

Audience

This seminar is designed for business analysts, application developers/analysts, project leaders and data/database administrators.

Description

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:
    • many-to-many
    • 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