Entity Relationship Diagram (ERD)
An Entity Relationship (ER) Diagram is a type of flowchart that illustrates how “Entities” (usually tables within a database), such as people, objects, or concepts, relate to each other within a system.
ER Diagrams are most often used to design or debug Relational Databases in the fields of software engineering, business information systems, education, and research.
Also known as ERDs or ER Models, they use a defined set of symbols, such as rectangles, diamonds, ovals, and connecting lines, to depict the interconnectedness of entities, relationships, and their attributes. They mirror grammatical structure, with entities as nouns and relationships as verbs.
Source
Wikipedia.
# ERD Tools
# Further Reads
My three part series on Data Modeling and The Unsung Hero of Data Engineering:
- Part 1: An Introduction to Data Modeling | ssp.sh
- Part 2: Modeling Approaches and Techniques | ssp.sh
- Part 3: Architecture Pattern, Tools and the Future | ssp.sh
Others:
Origin: Data Modeling – The Unsung Hero of Data Engineering- An Introduction to Data Modeling (Part 1)
References: More examples at Simon/Sync/3 Resources/Templates/Business Intelligence/ERD