Notation & Symbols for ERD
Creation of the entity-relationship model is one of the most important stages in the process of creating databases and modeling of business processes. Entity Relationship Diagram (ERD) reflects reality and allows you to get the most complete picture about the actual data requirements that are set at the company.
The entity-relationship model described in form of ERD represents the information that is gathered and used at the conduct of business. It visually shows how the database or application system will look, but doesn't disclose a way of realization. The ERD doesn't depend on the choice of database producer. It groups the data into separate entities and links these entities to each other on the base of business rules. The entity has the contents and represents some object about which is needed to store information. The business rules is a line of conduct and procedures for the business organization, they describe how the company is functioning.
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.

Example 1. Entity relationship diagram (ERD) symbols, Crow's Foot notation
All these ERD symbols are vector, you can drag to the document to construct the ER Diagram, resize any of them without loss of quality, change their color to make your diagram more attractive and colorful.
ERD Chen's notation
Symbol | Shape Name | Symbol Description |
Entities | ||
![]() |
Entity | An entity is represented by a rectangle which contains the entity’s name. |
![]() |
Weak Entity | An entity that cannot be uniquely identified by its attributes alone. The existence of a weak entity is dependent upon another entity called the owner entity. The weak entity’s identifier is a combination of the identifier of the owner entity and the partial key of the weak entity. |
![]() |
Associative Entity | An entity used in a many-to-many relationship (represents an extra table). All relationships for the associative entity should be many |
Attributes | ||
![]() |
Attribute | In the Chen notation, each attribute is represented by an oval containing atributte’s name |
![]() |
Key attribute | An attribute that uniquely identifies a particular entity. The name of a key attribute is underscored. |
![]() |
Multivalued attribute | An attribute that can have many values (there are many distinct values entered for it in the same column of the table). Multivalued attribute is depicted by a dual oval. |
![]() |
Derived attribute | An attribute whose value is calculated (derived) from other attributes. The derived attribute may or may not be physically stored in the database. In the Chen notation, this attribute is represented by dashed oval. |
Relationships | ||
![]() |
Strong relationship | A relationship where entity is existence-independent of other entities, and PK of Child doesn’t contain PK component of Parent Entity. A strong relationship is represented by a single rhombus |
![]() |
Weak (identifying) relationship | A relationship where Child entity is existence-dependent on parent, and PK of Child Entity contains PK component of Parent Entity. This relationship is represented by a double rhombus. |
Example 2. ER Diagram - Chen's Notation
ERD Crow’s Foot notation
Symbol | Meaning | |
Relationships (Cardinality and Modality) | ||
![]() |
Zero or More | |
![]() |
One or More | |
![]() |
One and only One | |
![]() |
Zero or One | |
Many - to - One | ||
![]() |
a one through many notation on one side of a relationship and a one and only one on the other | |
![]() |
a zero through many notation on one side of a relationship and a one and only one on the other | |
![]() |
a one through many notation on one side of a relationship and a zero or one notation on the other | |
![]() |
a zero through many notation on one side of a relationship and a zero or one notation on the other | |
Many - to - Many | ||
![]() |
a zero through many on both sides of a relationship | |
![]() |
a one through many on both sides of a relationship | |
![]() |
a zero through many on one side and a one through many on the other | |
![]() |
a one and only one notation on one side of a relationship and a zero or one on the other | |
![]() |
a one and only one notation on both sides |
Example 3. ER Diagram - Crow's Foot Notation
The samples you see on this page were created in ConceptDraw DIAGRAM using the Entity-Relationship Diagram (ERD) solution from Software Development area of ConceptDraw Solution Park. An experienced user spent 10 minutes creating these samples.
Use the Entity-Relationship Diagram (ERD) Solution for ConceptDraw DIAGRAM software to create quick and easy your own professional looking ERDs using Crow's Foot and Chen notations.
All source documents are vector graphic documents. They are available for reviewing, modifying, or converting to a variety of formats (PDF file, MS PowerPoint, MS Visio, and many other graphic formats) from the ConceptDraw STORE. The Entity-Relationship Diagram (ERD) Solution is available for all ConceptDraw DIAGRAM or later users.
TEN RELATED HOW TO's:
Bubble Chart →
How to design a Bubble Chart? It’s very easy! All that you need is a powerful software. Never before creation of a Bubble Chart wasn’t so easy as now with tools of Business Diagrams Solution from the Management Area for ConceptDraw Solution Park.
Educational Technology Tools →
What are the favorite educational technology tools and techniques for teachers? Of course these are pictures, images and education infographics! ConceptDraw DIAGRAM software supplied with Education Infographics Solution from the Business Infographics Area provides powerful drawing tools to help design the education infographics of any complexity.
Astronomy and Astrology →
Astronomy and astrology require from the specialists permanent drawing wide variety of illustrations, sketches. It’s convenient for astronomers and astrologers to have software that will help design them quick and easy. ConceptDraw DIAGRAM diagramming and vector drawing software extended with Astronomy solution from the Science and Education area is exactly what they need.
Settlement Process Flowchart. Flowchart Examples →
Create your own flow charts of settlement processes using the ConceptDraw DIAGRAM diagramming and vector drawing software extended with the Cross-Functional Flowcharts solution from the Business Processes area of ConceptDraw Solution Park. Download easy flowchart software to create settlement process flowcharts show steps of monthly settlement with your business quickly and easily.
Data Flow Diagram Examples →
Data flow diagrams are the graphical tool, used in the visualization of data flow of some data processing systems. It is the valuable process modeling tool. Also designing DFD is the important component of the initial part of any information system development project. The standard symbols are used to represent the interaction of a system components and how various kinds of components influence on data flow. The ConceptDraw Data Flow Diagrams solution is design to assist professional software engineers in making DFDs according to Gane and Sarson, and Yourdon and Coad notations. Do you imagine yourself as a successful IT specialist? To your mind, they all use data flow diagram examples to learn and to get inspired. Aren’t you still with us?
Electrical Symbols — Transistors →
A transistor is a semiconductor device used to amplify or switch electronic signals and electrical power. It is composed of semiconductor material usually with at least three terminals for connection to an external circuit. A voltage or current applied to one pair of the transistor's terminals changes the current through another pair of terminals. Because the controlled (output) power can be higher than the controlling (input) power, a transistor can amplify a signal. Today, some transistors are packaged individually, but many more are found embedded in integrated circuits. 26 libraries of the Electrical Engineering Solution of ConceptDraw DIAGRAM make your electrical diagramming simple, efficient, and effective. You can simply and quickly drop the ready-to-use objects from libraries into your document to create the electrical diagram.
Data Flow Diagram Example →
ConceptDraw DIAGRAM extended with Data Flow Diagrams solution is the best diagramming and vector drawing software for quick and easy designing the Data Flow Diagram Example of any complexity.