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

ERD Symbols and Meanings

ERD Symbols and Meanings
Entity Relationship Diagram (ERD) is a popular software engineering tool for database modeling and illustration the logical structure of databases, which uses one of two notations - Chen's or Crow’s Foot. Crow's foot notation is effective when used in software engineering, information engineering, structured systems analysis and design. Each of these notations applies its own set of ERD symbols. Crow's foot diagrams use boxes to represent entities and lines between these boxes to show relationships. Varied shapes at the ends of lines depict the cardinality of a given relationship. Chen's ERD notation is more detailed way to represent entities and relationships. ConceptDraw DIAGRAM application enhanced with all-inclusive Entity-Relationship Diagram (ERD) solution allows design professional ER diagrams with Chen's or Crow’s Foot notation on your choice. It contains the full set of ready-to-use standardized ERD symbols and meanings helpful for quickly drawing, collection of predesigned ERD samples, examples and templates. ConceptDraw Pro is a great alternative to Visio for Mac users as it offers more features and can easily handle the most demanding professional needs.
How to Build an Entity Relationship Diagram (ERD)
How to Build an Entity Relationship Diagram (ERD)
"Crow's Foot notation is used in Barker's Notation, 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." [Entity–relationship model. Wikipedia]
The vector stencils library ERD, crow's foot notation contains 18 symbols for creating the ER-diagrams using the ConceptDraw PRO diagramming nd vector drawing software.
The example"Design elements - ERD solution (crow's foot notation)" is included in the Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park.
Crow's foot ERD
Crow's foot ERD, entity,
Used Solutions
"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,
Used Solutions

Martin ERD Diagram

The vector stencils library Crow's Foot Notation from the solution Entity-Relationship Diagrams (ERD) contains specific symbols of the Crow's foot notation such as relationship symbols and entity symbols for ConceptDraw DIAGRAM diagramming and vector drawing software. The Entity-Relationship Diagrams (ERD) solution is contained in the Software Development area of ConceptDraw Solution Park.

Express-G Diagram

The vector stencils library from the solution Information Model Diagrams contains specific data type symbols of the EXPRESS-G notation such as entity data type symbols, simple data type symbols, enumeration data type symbols, defined data type symbols, select data type symbols and specific attribute symbols for ConceptDraw DIAGRAM diagramming and vector drawing software. The Information Model Diagrams solution is contained in the Software Development area of ConceptDraw Solution Park.

Yourdon and Coad Diagram

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 diagramming and vector drawing software. The OOAD solution is contained in the Software Development area of ConceptDraw Solution Park.

ERD, entity-relationship diagram, ER-diagram, Crow’s Foot Notation Crow's Foot Notation

ERD, entity-relationship diagram, ER-diagram, Crow’s Foot Notation
Crow’s Foot Notation solution extends ConceptDraw DIAGRAM software with powerful drawing tools, samples and library of predesigned vector Crow's Foot notation icons to help you easy describe the databases using the Entity-Relationship models and design professional-looking ER diagrams based on the popular Crow's Foot notation.

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

entity-relationship diagram, ER-diagram, database ERD
Entity-Relationship Diagram (ERD) solution extends ConceptDraw DIAGRAM software with templates, samples and libraries of vector stencils from drawing the ER-diagrams by Chen's and crow’s foot notations.

Database Design

ConceptDraw DIAGRAM extended with IDEF Business Process Diagrams solution from the Business Processes area of ConceptDraw Solution Park is an ideal software for effective database design and drawing IDEF diagrams visually representing all steps of database design process.

ORM Diagram

The vector stencils library ORM Diagrams from the solution Software Development contains specific ORM symbols for ConceptDraw DIAGRAM diagramming and vector drawing software. The Software Development solution is contained in the ConceptDraw Solution Park.

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

Wireless Network Drawing

The Wireless Network solution helps users to quickly transition from an idea to the implementation of a wireless computer network. ConceptDraw DIAGRAM is well placed to provide experienced and comprehensive assistance in the workplace. The vector stencils, examples, and templates included to solution is a strong toolset for network engineer.

Pyramid Diagram

The representation of data in a hierarchical or pyramid-like form is one of the most effective and illustrative ways of structuring the data, information, ideas in different fields, among them marketing, management, business, finances, sales, consulting, media, and some others. Pyramid Diagram perfectly suits for this goal, especially if we talk about the representing some marketing strategies, information systems, social strategies. Pyramid Diagram looks like a triangle or reversed triangle that is divided visually on several layers. Each layer can be colored with its own color, this lets visually highlight important moments. ConceptDraw DIAGRAM diagramming and vector graphics software extended with Pyramid Diagrams solution from the Marketing area provides powerful drawing tools, templates, samples, and built-in vector pyramid objects, thus all required tools for equally easy drawing Three level pyramid diagram, Four level pyramid model, Five level pyramid, etc., at this your Pyramid diagrams can have 2D or 3D view as you like.

Chemical Engineering

ConceptDraw DIAGRAM is a powerful diagramming and vector drawing software. Extended with Chemical and Process Engineering Solution from the Industrial Engineering Area of ConceptDraw Solution Park, it became the best Chemical Engineering software.

Property Management Examples

This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the Seven Management and Planning Tools Solution from the Business Productivity area of ConceptDraw Solution Park. This sample shows the Property Management matrix, the ideas are ordered in regards to importance and frequency. This matrix gives the ability to turn the theory into quantifiable data.