Unit Title: H3BB 04 Data Modelling
Unit Purpose
Introduce the techniques of data modelling which allow you to take real world data and analyse it to produce a model that will help you create a relational database. It introduces data analysis terms and relational database terms, along with Entity Relationship Diagrams and Data Dictionaries which are key aids in database design.
Outcomes
Outcome 1
1. Understand the concepts of logical data modelling
1.1 Describe entities and the types of attributes which can be assigned to them
1.2 Describe the type of relationships which can exist between entities
1.3 Explain the objectives of data normalisation and describe the Third Normal Form (3NF)
1.4 Explain the types of keys and their use
1.5 Describe an application where un-normalised or de-normalised data may be used
1.6 Describe the types of standard notation which can be used to represent data sets as logical data models
Outcome 2
2. Use logical data modelling techniques
2.1 Identify and name entities, assigning the correct attributes
2.2 Identify and represent entity relationships, assigning the correct type
2.3 Normalise a data set to Third Normal Form (3NF)
This module is completed by proceeding through a series of Workbooks which will be progressively be added to this portal. When each workbook have been completed, they should be uploaded to the data modelling folder on the server.
Data Modelling Workbook Part 1
Data Modelling Workbook Part 2
Data Modelling Workbook Part 3
Data Modelling Workbook Part 2
Data Modelling Workbook Part 3
The powerpoint below will assist with the completion of part 1 of the workbook.
A series of videos will assist with the concepts covered in outcome 1 and help you to complete the initial part of the workbook.
https://youtu.be/o3CYcksvZZchttps://youtu.be/B_AfyVwf_Owhttps://youtu.be/brO4_AIiNJghttps://youtu.be/id9OG6kEKCghttps://youtu.be/y_5Ob2AsQVAhttps://youtu.be/kHTT55Upa_0