Book a Demo
Prev Next

Entity Relationship Diagram

Getting to know the Entity Relationship Diagram

Introducing the Entity Relationship Diagram

The Entity Relationship diagram is a visual device used to model information or data and is used as a schema that is a precursor to database modeling. There are a number of different representations that can be used but the style used in Enterprise Architect uses rectangles to represent Entities, ellipses to represent Attributes and diamonds to represent connections between Entities.

This Entity Relationship diagrams show how to model Entities (represented by rectangles) and their Attributes (represented by ellipses) and their relationships (represented by diamonds).

Where to find the Entity Relationship Diagram

Ribbon: Design > Diagram > Add Diagram > Database Engineering > Entity Relationships > Entity Relationship Diagram > ERD_DP

Browser window Toolbar : New Diagram icon > Database Engineering > Entity Relationships > Entity Relationship Diagram > ERD_DP

Browser window context menu | Add Diagram... > Database Engineering > Entity Relationships > Entity Relationship Diagram > ERD_DP

Usage of the Entity Relationship Diagram

They are used by some data modelers as a way of ensuring independence from the physical data models that are used to represent the schema of a given Relational Database Management System database. They also provide a more appealing means of communicating with non technical stakeholders.

Options for the Entity Relationship Diagram

Entity Relationship diagrams can be drawn to include all of the Entities in a given domain in a single diagram or, alternatively, a number of diagrams can be created for different aspects of the domain. Diagram Filters can be used in presentations to focus on specific parts of a diagram that are of interest to the audience. The Documentation Generator can also be used to produce a data dictionary describing the Entities, their Attributes and their relationships with other Entities.

Entity Relationship Diagram (ERD) toolbox in Sparx Systems Enterprise Architect.

The Diagram Toolbox contains a range of elements, relationships and Patterns for creating Entity Relationship diagrams.

The Entity Relationship diagram (like any diagram) can be viewed as an element list, which makes working with the element's properties easier.

Diagram Filters can also be used when presenting the diagrams to draw attention to parts of the diagrams, and the diagrams can be presented as hand drawn or in a whiteboard style by changing the properties of the diagram.

Learn more about the Entity Relationship Diagram

Entity Relationship Diagrams (ERDs)