Our Workshops

Data Modelling


1-Day Workshop

What is Data Modeling?

Explore data modeling methodologies with the goal of understanding how to choose, apply, and interpret appropriate statistical designs and analyses for practical data problems.

How do business managers and their staff find data and information they need for decision-making?

  • Ask the end-users of the data. But who are they?
  • And what if the data exists in different versions? Which version is correct?

A data model is the "Corporate Street Directory".  It includes data maps and data details in a repository. It is comparable to the city map and details of streets. A data model, therefore:

  • Depends on business rules and business conditions
  • Depends on the time requirements, and performance
  • Depends on the technology used

A data model should be based on an organisation's strategic, tactical and operational business plans, if information systems are to be built that are aligned with the corporate goals.

Most organisations have not, until recently, recognised the importance of data models - which are as vital to the construction of an information system as an architect's plans are for the construction of a house or a skyscraper.

A data model is an essential prerequisite for development of application databases, data warehouses, for internet/intranet systems and for business transformation to take advantage of the Internet and corporate Intranet technologies.

On completion of this workshop the learner will

  • Have completed exercises which will guide them through the process of data modelling.
  • Have thought critically about the data requirements and processes of a scenario used in class.
  • Know the three phases of data modelling and their outcomes.
  • Have set up Conceptual and Logical models describing the data in the scenario used in class.
  • Understand the notation of different Entity-Relationship diagrams.
  • Understand Relational Database Management systems.
  • Understand and applied Data Normalisation to the data in the scenario.

Workshop Outline

The Data Modelling Process

Potential shortcomings of the model produced

Considerations during the data modelling process

The Scenario:

Describe the Information for the Conceptual model

Defining the Business Rules

Three Schemas

Conceptual Schema

Modelling approaches

Activity Diagrams

Sample Activity/Workflow Diagram

Activity Diagrams

Concept Mapping

Construct a Concept Map

Add Business Rules

Data Dictionary

Data Dictionary

Logical Schema

Data Modelling Notations

Entity-Relationship Model (Chen)

Entity-Relationship Model (Barker/Crow’s Foot)

Foot notation

Entity-Relationship Model (IDEF1X)

IDEF1X Entity Relationship Matrix

Relational Database Management System RDBMS

Relations or Tables (Entity)

Table Structure

Keys and Constraints

Construct Tables (Entities)

Database Normalisation

Modification Side Effects (Anomalies) addressed by Normalisation

Other optimisation delivered through Normalisation

Normal Forms


On-Site Workshops

  • All workshops are offered in-house at your offices to a minimum of 5 delegates
  • You provide the venue and refreshments, Front Foot supply all the workshop material – including laptops for computer-based training sessions

 Remote Workshops

  • All workshops are offered remotely to a minimum of 5 delegates
  • Front Foot supply all the electronic workshop material


Workshop Dates