The Data Modelling module explains how entities, attributes and relationships can be used to build data models and the benefits that these data models bestow on an organisation.
Normalisation of data from 1st to 3rd normal form along with illustrated examples showing the transformations from each form is also detailed.
An introduction to the 3 different types of data models; the conceptual, the logical and the physical are also described.
Learn what data modelling is.
Learn how data entities, attributes and relationships relate to data models.
Learn the benefits of data modelling.
Learn what un-normalised data is.
Learn how data is normalised.
Understand the three common types of data models.
Who is Suitable?
This module would be useful for a wide range of data roles; including but not exclusive to data owners, data stewards, data architects and data lineage analysts.
As this is a data understanding module it is especially useful for data analysts and data modellers.
- What is a Database Management System (DBMS)?
- What is meant by a “Fit for Purpose” database?
- What is meant by a “Primary Key”?
- Why is it important to normalise data?
- Why is it helpful to create data models?
- Why are we interested in entities?
- Why are we interested in attributes?
- Why are we interested in relationships?
- Why is a data model helpful for business users prior to building a new system?
- Why are CDE’s defined at the logical level?
An Interactive Presentation
10+ Interactive Questions
3 Final Practice Tests – 30 questions over 30 minutes
Final Examination – 60 questions over 30 minutes