Click here to send this to a colleague or friend.

Data Modelling

Finding the data and information in your business for decision-making

Microsoft Office version 2010; 2013 or 2016

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.
Today, 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.



Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the South African Qualification Authority Act

Our Microsoft workshop presenters are Microsoft Certified Trainers and Microsoft Certified Technology Specialists

Front Foot is a Majority Black-Owned Level 2 EME – 125% Recognition

Register now for this workshop

Prerequisite knowledge

Delegates attending this course should have completed:

Microsoft Access Level 1
Microsoft Visio Level 1

The Data Modelling Process
Potential shortcomings of the model produced
Considerations during the data modelling process
The Scenario:
Three Schemas
Conceptual Schema
Modelling approaches
Activity Diagrams
Sample Activity/Workflow Diagram
Concept Mapping
Add Business Rules
Data Dictionary
Logical Schema

Data Modelling Notations
Entity-Relationship Model (Chen)
Entity-Relationship Model (Barker/Crow’s Foot)
Entity-Relationship Model (IDEF1X)
Relational Database Management System RDBMS
Relations or Tables (Entity)
Table StructureKeys and Constraints
Database Normalisation
Modification Side Effects (Anomalies) addressed by Normalisation
Other optimisation delivered through Normalisation
Normal Forms Logical Schema

On completion of this course the learner will

Have completed 5 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 3 different Entity-Relationship diagrams.

Have set up 3 different Entity-Relationship diagrams using Microsoft Visio.

Understand Relational Database Management systems.

Understand and applied Data Normalisation to the data in the scenario.

shadow shadow

Who should attend?

  • Users of data
  • Managers
  • Anyone revising their information system
  • Developers
  • Business analysts

Training approach

Our courses use interactive tools that allow learners to learn by doing.

The experience for learners is fun, rewarding, lasting and integrative, whilst employers are assured of a high return on investment in training.

Front Foot courses are compiled and presented by subject matter experts
and industry specialists to ensure the highest and most current standard of excellence in all our workshops and training
Event Information:
Date: 5th May 2020 at Benvenuto Conference Centre in Randburg

20th August 2020 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

Map: View map
Duration: 1 Day
Cost: R 2500.00 excl VAT
R 2875.00 incl VAT
Surcharge: Strict Halaal and Kosher meals carry an additional R200 surcharge

Upcoming Events:
Visit our events calendar for more information.

Upcoming Workshops:
Visit our workshops calendar for more information.

10% discount for two or more delegates

10% discount if you attend two or more workshops

15% discount for four or more delegates

In-house at your offices
discount for 5 or more delegates

30% discount for 8 or more delegates

35% discount for 10 or more delegates

We provide laptops for in-house computer-based training sessions



Contact Adele on
011 867 7299 or email

Bookings and Enquiries
Website | Email