Entity Relationship Model
- The data layer of the hierarchy structure will likely include entity relationship models
- provide valuable information to the teams that are required to protect and store data
- give the data governance team a bird’s eye view into the systems with data
- so they can more easily apply data classifications
Model Types
Conceptual data model is the conceptual view of what should exist in a data system and how it could be related.
Logical data model is a more detailed view of the conceptual model that includes data fields and the relationships between them.
Physical data model is the actual data system with tables, relationships, fields, and attributes.
- should lay out what version of the database you currently have in production
Entity Relationship Diagram (ERD)
Entity relationship diagram (ERD) is the pictorial representation of a database model that shows how entities (like people or objects) relate to each other through the data.
- often developed for a single system
- these diagrams provides visibility into the relationships and connections of each data set
- tools:
- Lucidchart
- diagram can directly tell you what fields you use for joins
- help you to troubleshoot information
- give you a source to verify against
The Unified Modeling Language (UML) is a general development and modeling language in software and database engineering.
Example Entity Relationship Diagram
- Diagram of The Digital High School Student Information System
- This is a physical model
- describes the exact layout of this database
- before you have access to the database itself
- it is important to see how the database is designed to store the data
- critical that you understand:
- the rules of storing data effectively
- the rules of analyzing it effectively
- key questions ask yourself when backend data designs change:
- Have any fields been added or deleted?
- Has someone added or deleted tables/queries?
- Did the design/schema have any changes in structure where it was furthered normalized?
- Did we have any changes in the joins or relationships of the tables used in the underlying data set?
