2 days - Please call for a quote

The Data Modelling training course is designed to be both practical and participative. Introductory ‘input’ sessions are interspersed with practical exercises to illustrate the points discussed and there is a continuing case study where participants can apply their knowledge to a practical scenario.

Data Modelling Course Objectives

At the end of this Data Modelling training course participants will be able to:

• Describe the basic principles of data modelling
• Define and identify entities, attributes, relationships and keys
• Define, explain and use the concepts of data relationships
• Build a logical data model using advanced concepts including sub-types, super-types and entity aspects
• Describe the theory and application of relational data analysis
• Use relational data analysis (‘third normal form’) to identify data relations and build a data model based upon them
• Create a composite data model from the logical data model and the relational data model
• Validate a data model against defined access and navigation requirements

Data Modelling Course Content

1. Principles of data modelling

• Entities
• Attributes
• Relationships
• Keys
• Entity descriptions

2. Data relationships

• Cardinality
• Optionality
• Exclusivity
• Recursion
• Naming relationships
• Relationship descriptions

3. Data modelling – further concepts

• Attribute descriptions
• Domain descriptions
• Sub-types, super-types
• Partitioning data models
• Transferable and non-transferrable relationships
• Entity aspects

4. Relational data analysis

• Relations
• Primary and candidate keys
• Third normal form analysis

5 . Drawing third normal form models

• Rationalising the results of relational data analysis
• Representing relations and keys
• Rules for building the TNF model
• Comparing the TNF model with the data model

6 . Validating the data model

• Validating against requirements
• Access paths
• Entry points and input attributes
• Navigation
• Volumetrics

Data Modelling recommended reading

Data Modeling Made Simple: A Practical Guide for Business and Information Technology Professionals by Steve Hoberman - buy from amazon
Data Modeling Essentials by Graeme C. Simsion - buy from amazon

Download course outline as pdf.

Share This