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 erd-example.svg.

More examples at Simon/Sync/3 Resources/Templates/Business Intelligence/ERD

• Data Modeling Tools

Origin: Data Modeling – The Unsung Hero of Data Engineering- An Introduction to Data Modeling (Part 1)