Relational Structure Discovery and Data Modelling (ER Diagram and Key Design)
Covers modeling the relationships between tables, key fields and master data standards in organizational databases using ER diagrams.
Training content
- Relationships between tables
- Keys
- Data integrity
- Common field standard
- Master data approach and creating an internal relationship dictionary
At the end of this training, participants
- Will be able to link datasets by establishing the basic relational logic in organizational databases.
- Will be able to make data from different systems analysable together by defining common key fields.
- Will be able to identify data integrity and consistency issues from a modeling perspective.
- Will be able to strengthen the documentation of the corporate data architecture by producing an ER diagram and a relationship dictionary.
- Will be able to bind critical reference data to standards using a master data approach.
In this way, continuity and accuracy in data integration and cross-analyses will increase.