The module explains the conceptual, logical and physical data models with industry examples of each given.
The relationship types between the attributes contained within a model is also explained.
The key roles of data modelling such as a database administrator (DBA) and data modeller are detailed in the module.
Learn what a conceptual data model is.
Learn what a logical data model is.
Learn what a physical data model is.
Learn what one to one (1:1), one to many (1:M) and many to many (M:M) relationships are.
Learn the role of a Database administrator (DBA).
Learn the role of a data modeller.
Who is Suitable?
Knowledge of what Data Modelling is would be advantageous.
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.
- Why do we have 3 types of models?
- Can you give an example of a 1 to 1, 1 to M and M to M relationship?
- In what order are the data models created and why?
- What are Primary and foreign keys?
- What does the DBA do?
An Interactive Presentation
10+ Interactive Questions
3 Final Practice Tests – 30 questions over 30 minutes
Final Examination – 60 questions over 30 minutes