This site uses cookies. By continuing to browse the ConceptDraw site you are agreeing to our Use of Site Cookies.

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)

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.
This example was designed on the base of the Wikimedia Commons file: Weak entity ER-example.svg.
[commons.wikimedia.org/ wiki/ File:Weak_ entity_ ER-example.svg]
This file is licensed under the Creative Commons Attribution-Share Alike 3.0 Unported license. [creativecommons.org/ licenses/ by-sa/ 3.0/ deed.en]
"In a relational database, a weak entity is an entity that cannot be uniquely identified by its attributes alone; therefore, it must use a foreign key in conjunction with its attributes to create a primary key. The foreign key is typically a primary key of an entity it is related to.
In entity relationship diagrams, ER diagrams a weak entity set is indicated by a bold (or double-lined) rectangle (the entity) connected by a bold (or double-lined) type arrow to a bold (or double-lined) diamond (the relationship)." [Weak entity. Wikipedia]
The entity-relationship diagram example "Weak entity ERD" was drawn using ConceptDraw PRO software extended with the Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park.
Entity-relationship diagram
Entity-relationship diagram, week key attribute, weak entity, relationship, key attribute, identifying relationship, entity, attribute,

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.

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)

entity-relationship diagram, ER-diagram, database ERD Entity-Relationship Diagram (ERD)

entity-relationship diagram, ER-diagram, database ERD
An Entity-Relationship Diagram (ERD) is a visual presentation of entities and relationships. That type of diagrams is often used in the semi-structured or unstructured data in databases and information systems. At first glance ERD is similar to a flowch

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.
"Chen's notation for entity–relationship modeling uses rectangles to represent entity sets, and diamonds to represent relationships appropriate for first-class objects: they can have attributes and relationships of their own. If an entity set participates in a relationship set, they are connected with a line.
Attributes are drawn as ovals and are connected with a line to exactly one entity or relationship set.
Cardinality constraints are expressed as follows:
- a double line indicates a participation constraint, totality or surjectivity: all entities in the entity set must participate in at least one relationship in the relationship set;
- an arrow from entity set to relationship set indicates a key constraint, i.e. injectivity: each entity of the entity set can participate in at most one relationship in the relationship set;
- a thick line indicates both, i.e. bijectivity: each entity in the entity set is involved in exactly one relationship.
- an underlined name of an attribute indicates that it is a key: two different entities or relationships with this attribute always have different values for this attribute.
Attributes are often omitted as they can clutter up a diagram; other diagram techniques often list entity attributes within the rectangles drawn for entity sets." [Entity–relationship model. Wikipedia]
The vector stencils library ERD, Chen's notation contains 13 symbols for drawing entity-relatinship diagrams using the ConceptDraw PRO diagramming and vector drawing software.
The example "Design elements - ER diagram (Chen notation)" is included in the Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park.
Chen's ERD
Chen's ERD, week key attribute, weak entity, relationship, multivalue attribute, key attribute, identifying relationship, entity, derived attribute, attribute, associative entity,
"In software engineering, an entity–relationship model (ER model) is a data model for describing a database in an abstract way.Chen's notation for entity–relationship modeling uses rectangles to represent entity sets, and diamonds to represent relationships appropriate for first-class objects: they can have attributes and relationships of their own. If an entity set participates in a relationship set, they are connected with a line.
Attributes are drawn as ovals and are connected with a line to exactly one entity or relationship set." [Entity–relationship model. Wikipedia]
This sample Chen's ER-diagram illustrates the structure of a typical MMORP game.
"Massively multiplayer online role-playing game (MMORPG) mixes the genres of role-playing video games and Massively multiplayer online games, possibly in the form of web browser-based games, in which a very large number of players interact with one another within a virtual world.
As in all RPGs, players assume the role of a character (often in a fantasy world or science-fiction world) and take control over many of that character's actions. MMORPGs are distinguished from single-player or small multi-player online RPGs by the number of players, and by the game's persistent world (usually hosted by the game's publisher), which continues to exist and evolve while the player is offline and away from the game." [Massively multiplayer online role-playing game. Wikipedia]
This ERD example was redrawn using the ConceptDraw PRO diagramming and vector drawing software from the Wikipedia file: ER Diagram MMORPG.png. [en.wikipedia.org/ wiki/ File:ER_ Diagram_ MMORPG.png]
This file is licensed under the Creative Commons Attribution-Share Alike 3.0 Unported license. [creativecommons.org/ licenses/ by-sa/ 3.0/ deed.en]
This Chen's ERD example is included in the Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park.
Chen's ERD
Chen's ERD, weak key attribute, weak entity, relationship, multivalue attribute, key attribute, identifying relationship, entity, derived attribute, attribute,
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,
"In software engineering, an entity–relationship model (ER model) is a data model for describing a database in an abstract way.Chen's notation for entity–relationship modeling uses rectangles to represent entity sets, and diamonds to represent relationships appropriate for first-class objects: they can have attributes and relationships of their own. If an entity set participates in a relationship set, they are connected with a line.
Attributes are drawn as ovals and are connected with a line to exactly one entity or relationship set." [Entity–relationship model. Wikipedia]
This sample Chen's ER-diagram illustrates the structure of a typical MMORP game.
"Massively multiplayer online role-playing game (MMORPG) mixes the genres of role-playing video games and Massively multiplayer online games, possibly in the form of web browser-based games, in which a very large number of players interact with one another within a virtual world.
As in all RPGs, players assume the role of a character (often in a fantasy world or science-fiction world) and take control over many of that character's actions. MMORPGs are distinguished from single-player or small multi-player online RPGs by the number of players, and by the game's persistent world (usually hosted by the game's publisher), which continues to exist and evolve while the player is offline and away from the game." [Massively multiplayer online role-playing game. Wikipedia]
This ERD example was redrawn using the ConceptDraw PRO diagramming and vector drawing software from the Wikipedia file: ER Diagram MMORPG.png. [en.wikipedia.org/ wiki/ File:ER_ Diagram_ MMORPG.png]
This file is licensed under the Creative Commons Attribution-Share Alike 3.0 Unported license. [creativecommons.org/ licenses/ by-sa/ 3.0/ deed.en]
This Chen's ERD example is included in the Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park.
Chen's ERD
Chen's ERD, weak key attribute, weak entity, relationship, multivalue attribute, key attribute, identifying relationship, entity, derived attribute, attribute,
This ERD example was designed on the base of the entity-relationship diagram on the webpage "IS480 Team wiki: 2015T1 WhitePinnacle Documentation" from the Singapore Management University website. [wiki.smu.edu.sg/ is480/ IS480_ Team_ wiki%3A_ 2015T1_ WhitePinnacle_ Documentation]
This is ERD from the documentation of the High School Emergency Medical Responder (HS EMR) information system.
"Emergency medical responders are people who are specially trained to provide out-of-hospital care in medical emergencies. There are many different types of emergency medical responders, each with different levels of training, ranging from first aid and basic life support. Emergency Medical Responders have a very limited scope of practice and have the least amount of comprehensive education, clinical experience or clinical skills of EMS personnel. The Emergency Medical Responder (EMR) is not meant to replace the roles of Emergency Medical Technicians, Emergency Medical Technologists or Paramedics and their wide range of specialities. Emergency Medical Responders typically assist in rural regions providing basic life support where pre-hospital health professionals are not available due to limited resources or infrastructure." [Emergency medical responder. Wikipedia]
The example "Entity-Relationship Diagram" was drawn using ConceptDraw PRO software extended with the Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park.
ERD
ERD, weak entity, entity,

ER Diagram Styles

When creating ER diagrams, you can apply different color ER diagram styles and also notation styles. ConceptDraw DIAGRAM enhanced with Entity-Relationship Diagram (ERD) Solution gives the ability to draw visual and attractive ER Diagrams using the style icons from Crow’s Foot notation and Chen's notation professionally designed and offered by ERD Chen's Notation and ERD Crow’s Foot Notation libraries.

Design Element: Chen for Entity Relationship Diagram - ERD

Entity-relationship diagrams (ERDs) are intended for the development of data models and provide a standard method for determining data and relationships between them. The first notation for ERD was introduced by Chen. Entity-Relationship Diagram (ERD) solution from Software Development area of ConceptDraw Solution Park provides the libraries with predesigned set of ERD diagram design element Chen corresponding entities and relationships.
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,

Entity Relationship Diagram Examples

ConceptDraw DIAGRAM diagramming and vector drawing software offers the Entity-Relationship Diagram (ERD) Solution from the Software Development Area for ConceptDraw Solution Park. How many examples contains the Entity-Relationship Diagram (ERD) Solution! All Entity Relationship Diagram examples were designed and saved for ConceptDraw DIAGRAM users. Now they are available from ConceptDraw STORE.

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.

Developing Entity Relationship Diagrams

When you need to visually represent the structure of relational database, Entity relationship diagram (ERD) is a type of diagram for that case.
Most entity-relationship diagrams can be built with objects from Flowchart solution or ERD Solution which contains inbuilt templates. Follow these steps to create your own custom ERD diagram.
Don't be frightened if it looks complex, ConceptDraw DIAGRAM makes it easy to create an ERD, and hundreds of other diagrams, in minutes.

ER Diagram Tool

Creating of Entity-Relationship Diagrams (ERDs) is a complex process that requires convenient, automated tools. ConceptDraw DIAGRAM diagramming and vector drawing software offers a powerful ER Diagram Tool - the Entity-Relationship Diagram (ERD) Solution from the Software Development Area.

Entity Relationship Diagram - ERD - Software for Design Chen ER Diagrams

The Entity-Relationship Diagram (ERD) solution from ConceptDraw Solution Park extends ConceptDraw DIAGRAM vector graphics and diagramming software with the ability to describe a database using the Entity-Relationship (Chen) model. Use it for design your ERDs and verify that ConceptDraw DIAGRAM offers the best ERD diagrams software tools for design element Chen notation.