Made with
ConceptDraw
DIAGRAM 18

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.

Notation & Symbols for ERD *

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
ERD Symbols and Meaning - Entity Entity An entity is represented by a rectangle which contains the entity’s name.
ERD Symbols and Meaning - Weak Entity 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.
ERD Symbols and Meaning - Associative 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
ERD Symbols and Meaning - Attribute Attribute In the Chen notation, each attribute is represented by an oval containing atributte’s name
ERD Symbols and Meaning - Key attribute Key attribute An attribute that uniquely identifies a particular entity. The name of a key attribute is underscored.
ERD Symbols and Meaning - Multivalue attribute 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.
ERD Symbols and Meaning - Derived attribute 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
ERD Symbols and Meaning - Relationship 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
ERD Symbols and Meaning - Identifying Relationship 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.

ER Diagram - Chen's Notation

Example 2. ER Diagram - Chen's Notation


ERD Crow’s Foot notation

Symbol Meaning
Relationships (Cardinality and Modality)
ERD symbol -  Entity relationship Zero or More
ERD symbol -  Entity relationship One or More
ERD symbol -  Entity relationship One and only One
ERD symbol -  Entity relationship Zero or One
Many - to - One
ERD Symbols - Relationship Many to One a one through many notation on one side of a relationship and a one and only one on the other
ERD Symbols - Relationship Many to One a zero through many notation on one side of a relationship and a one and only one on the other
ERD Symbols - Relationship Many to One a one through many notation on one side of a relationship and a zero or one notation on the other
ERD Symbols - Relationship Many to One a zero through many notation on one side of a relationship and a zero or one notation on the other
Many - to - Many
ERD Symbols - Relationship Many to Many a zero through many on both sides of a relationship
ERD Symbols - Relationship Many to Many a one through many on both sides of a relationship
ERD Symbols - Relationship Many to Many a zero through many on one side and a one through many on the other
ERD Symbols - Relationship Many to Many a one and only one notation on one side of a relationship and a zero or one on the other
ERD Symbols - Relationship Many to Many a one and only one notation on both sides

ER Diagram - Crow's Foot Notation

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:
It is easy to recreate any informational system structure using diagrams. There are three main components of any ER diagram: entity, attribute and relationship. Basing on these three components, one can define other, less used elements, such as weak entity or relationship, derived attribute, recursive relationship etc. This is the set of graphic elements of ERD Chen's notation. This ERD notation is used to represent an entity–relationship models. It involves the set of geometric forms: rectangles - depicting entities, ovals - representing attributes and diamonds depicting relationships assigned for first-class objects, that can have relationships and attributes of their own. Connections are displayed with arrowed lines. It is known that the Chen's ERD notation is used to show a detailed view of entities and relationships. ConceptDraw Entity-Relationship Diagram solution from the Software Development section of Solution Park provides the ability to create ERD of database structure for software development purposes using the Chen’s notation elements.Components of ER Diagram *
Picture: Components of ER Diagram
Related Solution:
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.Entity Relationship Diagram - ERD - Software for Design  <br>Chen ER Diagrams *
Picture: Entity Relationship Diagram - ERD - Software for Design Chen ER Diagrams
Related Solution:
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.ER Diagram Styles *
Picture: ER Diagram Styles
Related Solution:
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.Educational Technology Tools *
Picture: Educational Technology Tools
Related Solution:
SIPOC is a tool that summarizes the inputs and outputs of one or more processes in table form. You need to draw professional looking SIPOC Diagram quick and easy? Pay please your attention on ConceptDraw DIAGRAM diagramming and vector drawing software. Extended with Business Process Mapping Solution from the Business Processes Area of ConceptDraw Solution Park, it suits ideal for this.SIPOC Diagram *
Picture: SIPOC Diagram
Related Solution:
A team briefing tool is an excellent way to enable communication upwards, downwards and sideways throughout an organisation.How To Conduct Effective Team Briefings *
Picture: How To Conduct Effective Team Briefings
Related Solution:
The Nature Solution addition to ConceptDraw Solution Park for ConceptDraw DIAGRAM includes new libraries that provide a wide range nature objects and it can be used in many areas.Drawing Illustration‎ *
Picture: Drawing Illustration‎
The vector stencils library Yourdon and Coad Notation from the solution OOAD contains specific symbols of the Yourdon and Coad notation such as data store symbol, data process symbol, loop symbol for ConceptDraw DIAGRAM software.Yourdon and Coad Diagram
Picture: Yourdon and Coad Diagram
This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the UML Class Diagram library of the Rapid UML Solution from the Software Development area of ConceptDraw Solution Park. This sample describes the use of the classes, the generalization associations between them, the multiplicity of associations and constraints. Provided UML diagram is one of the examples set that are part of Rapid UML solution.UML Class Diagram Generalization Example<br>UML Diagrams *
Picture: UML Class Diagram Generalization ExampleUML Diagrams
Related Solution:
Business graphic applications show a special knowledge representations and include many features for creating schematic pictures. These graphic tools are known as flowchart maker or flowchart maker software.Flowchart Maker
Picture: Flowchart Maker
Related Solution:
ConceptDraw
DIAGRAM 18