Products Solutions Samples Buy
✕
This site uses cookies. By continuing to browse the ConceptDraw site you are agreeing to our Use of Site Cookies.

Entity Relationship Diagram Symbols

Entity Relationship Diagram Symbols
Creating an entity-relationship (ER) model is to visually represent the structure of a business database, where data equates to entities (or objects) that are linked by defined relationships expressing dependencies and requirements. By nature it is an abstract visualization, the first step in the design process towards creating a logical and functional database.
ERD symbols used for professional ERD drawing are collected in libraries from the Entity-Relationship Diagram (ERD) solution for ConceptDraw DIAGRAM.

ERD Symbols and Meanings

ERD Symbols and Meanings
Crow's foot notation is used in Barker's Notation, Structured Systems Analysis and Design Method (SSADM) and information engineering. Crow's foot diagrams represent entities as boxes, and relationships as lines between the boxes. Different shapes at the ends of these lines represent the cardinality of the relationship.
The Chen's ERD notation is still used and is considered to present a more detailed way of representing entities and relationships.
To create an ERD, software engineers mainly turn to dedicated drawing software, which contain the full notation resources for their specific database design - ERD symbols and meanings. CS Odessa has released an all-inclusive Entity-Relationship Diagram (ERD) solution for their powerful drawing program, ConceptDraw DIAGRAM.
How to Build an Entity Relationship Diagram (ERD)
How to Build an Entity Relationship Diagram (ERD)

Notation & Symbols for ERD

The ER diagram is constructed from the specific ERD graphic elements. There are used 2 types of ERD notations: Chen and Crow's Foot.
A complete set of work flow shapes, notation & symbols for ERD, entity relationship stencils, included in Entity-Relationship Diagram (ERD) solution for ConceptDraw DIAGRAM software, makes drawing diagrams based on ERD notation as smooth as possible.

Anyone Have an ERD Symbols Quick Reference?

ERD drawing becomes easier with predesigned entity relationship symbols, work flow shapes, entity relationship stencils. All variety of ERD symbols you may need for ERDs design is packed into libraries and templates from Entity-Relationship Diagram (ERD) Solution for ConceptDraw DIAGRAM diagramming and vector drawing software.
But anyone have an ERD symbols quick reference? Detailed reference information for them is represented at the tables.
The vector stencils library "ERD, Chen's notation" contains 13 ERD elements.
Use it for drawing ER-diagrams using Chen's notation in the ConceptDraw PRO diagramming and vector drawing software extended with the Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park.
Entity
Entity, entity,
Weak entity
Weak entity, weak entity,
Relationship
Relationship, relationship,
Identifying Relationship
Identifying Relationship, identifying relationship,
Associative Entity
Associative Entity, associative entity,
Participation
Participation,
Optional participation
Optional participation,
Recursive Relationship
Recursive Relationship,
Attribute
Attribute, attribute,
Key attribute
Key attribute, key attribute,
Weak key attribute
Weak key attribute, weak key attribute,
Derived attribute
Derived attribute, derived attribute,
Multivalue attribute
Multivalue attribute, multivalue attribute,
Used Solutions
The vector stencils library "ERD, Chen's notation" contains 13 ERD elements.
Use it for drawing ER-diagrams using Chen's notation in the ConceptDraw PRO diagramming and vector drawing software extended with the Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park.
Entity
Entity, entity,
Weak entity
Weak entity, weak entity,
Relationship
Relationship, relationship,
Identifying Relationship
Identifying Relationship, identifying relationship,
Associative Entity
Associative Entity, associative entity,
Participation
Participation,
Optional participation
Optional participation,
Recursive Relationship
Recursive Relationship,
Attribute
Attribute, attribute,
Key attribute
Key attribute, key attribute,
Weak key attribute
Weak key attribute, weak key attribute,
Derived attribute
Derived attribute, derived attribute,
Multivalue attribute
Multivalue attribute, multivalue attribute,
Used Solutions

Entity Relationship Diagram Examples

Creating an entity-relationship (ER) model is to visually represent the structure of a business database, where data equates to entities (or objects) that are linked by defined relationships expressing dependencies and requirements. By nature it is an abstract visualization, the first step in the design process towards creating a logical and functional database.
ConceptDraw gives the ability to describe a database using the Entity-Relationship model. Entity-Relationship Diagram solution includes icons advocated by Chen's and Crow’s Foot notation that can be used when describing a database.
How to Build an Entity Relationship Diagram (ERD)
How to Build an Entity Relationship Diagram (ERD)

Entity Relationship Software

Entity Relationship Diagrams (ERD) illustrate the logical structure of databases.
The vector graphic diagrams produced when using the ConceptDraw ERD solution can be used in whitepapers, presentations, datasheets, posters, or any technical materials.
It is convenient to design ER Diagrams using ConceptDraw DIAGRAM software. ConceptDraw DIAGRAM extended with the Entity-Relationship Diagram (ERD) solution supports Chen's and Crow’s Foot notations that are often used to describe database structure.

Entity-Relationship Diagram

Entity Relationship Diagram (ERD) is the world-known way to show the logical structure of databases in visual manner. The best software tool for drawing Entity-Relationship Diagram is ConceptDraw DIAGRAM vector graphics software with Entity-Relationship Diagram (ERD) solution from Software Development area which gives the ability to describe a database using the Entity-Relationship model. The vector graphic diagrams produced using this solution can be successfully used in whitepapers, presentations, datasheets, posters, or any technical materials.

Entity Relationship Diagram - ERD - Software for Design Crows Foot ER Diagrams

Crow's Foot notation was proposed by Gordon Everest. According to this notation, the entity is represented by rectangle, relation is depicted by line which ties two entities involved in a relationship. Entity-relationship diagrams based on both Chen's and Crow's Foot notations, can be easily drawn using the ConceptDraw DIAGRAM ERD diagrams software tools for design element Crow's Foot and Chen from Entity-Relationship Diagram (ERD) solution.
How to Build an Entity Relationship Diagram (ERD)
How to Build an Entity Relationship Diagram (ERD)