ERD Symbols and Meanings

ConceptDraw PRO
Discover the World of Visual Communication

Design elements Crow’s Foot notation

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.

Entity-Relationship model making possibility to describe a database in which in the tables data can be the point to data in other tables - for instance, your entry in the database could point to several entries.

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 PRO.

Example 1. Entity Relationship Diagram symbols and meaning (Mac OS X and Windows)

When you need to describe efficiently a database using the Crow’s Foot notation icons, ConceptDraw PRO gives you the ability to draw Entity Relationship diagram (ERD) fast and easy.

Design elements Chen's notation

The Chen's ERD notation is still used and is considered to present a more detailed way of representing entities and relationships.

Use also ConceptDraw PRO enhanced with powerful Entity-Relationship Diagram (ERD) solution to draw your own ER diagrams using Chen's notation icons.

Symbol Shape Name Symbol Description
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
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.
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.

In addition to the vector stencil image libraries with full standardized Chen and Crow’s foot notations included, the Entity-Relationship Diagram (ERD) solution contains a number of ERD templates and samples added to the solution pack. They will help users quick start representing their own ideas.

Entity Relationship Diagram samples and templates in Solution Browser

Example 2. Entity Relationship Diagram samples and templates in Solution Browser

The following features make ConceptDraw PRO the best Entity Relationship Diagram ERD Software:

  1. You don't need to be an artist to draw professional looking diagrams in a few minutes.
  2. Large quantity of ready-to-use vector objects (entity relationship diagram symbols and meaning) makes your drawing diagrams quick and easy.
  3. Great number of predesigned templates and samples give you the good start for your own diagrams.
  4. ConceptDraw PRO provides you the possibility to use the grid, rules and guides. You can easily rotate, group, align, arrange the objects, use different fonts and colors to make your diagram exceptionally looking.
  5. All ConceptDraw PRO documents are vector graphic files and are available for reviewing, modifying, and converting to a variety of formats: image, HTML, PDF file, MS PowerPoint Presentation, Adobe Flash, MS Visio XML.
  6. Using ConceptDraw Solution Browser v2 you can navigate through ConceptDraw Solution Park, managing downloads and updates. You can access libraries, templates and samples directly from the ConceptDraw Solution Browser.
  7. If you have any questions, our free of charge support is always ready to come to your aid.

Use Product:

  • Software Development Tool
  • Diagram Software
  • Technical Diagramming Tool
  • Business Diagramming Tool
  • Professional Business Graphics Tool
  • ERD Diagrams Software
  • Cross Platform Compatibility
  • ConceptDraw PRO native Mac app
  • Easier to use than Microsoft Visio® and more powerful
  • With free support and thousands of templates

Use Solution:

Entity-Relationship Diagram (ERD)
  • Describing a database
  • Illustrate the logical structure of databases
  • Chen's notation
  • Crow’s Foot notation
  • Quick-Start ERD templates and samples
  • Entity Relationship Diagram examples
  • ERD vector elements
  • Import/Export Microsoft Visio™
  • Export to graphics files and PDF
  • Export to PPT™
  • Make Presentation

See also samples:

Entity Relationship Diagram Examples:

Entity Relationship Diagram
Entity Relationship Diagram

ERD Example - Crows-Foot notation
ERD Crows-Foot notation

ERD Example - Students and Teachers
Students and Teachers

ERD diagram example
Entity-Relationship Diagram

ERD diagram example
ERD Diagram Example

ERD diagram example
Entity-Relationship Diagram

ERD diagram example
ERD Diagram Example

ERD Example - Entity Relationship Model Diagram
Entity Relationship Model Diagram

Compatibility: Apple® OS X 10.10 or later
Microsoft® Windows® 7/8.1/10

Price: ConceptDraw PRO US$199
Download ConceptDraw PRO
Free 21 Trial for Mac and PC
Buy Now
1 Diagram Software
Professional business graphics tool for drawing schemes, diagrams and illustrating business documentation
1 Mind Map Software
Excellent tool for Mind Mapping, Planning, Brainstorming, and Building Processes
1 Project Management Software
The full complement of features needed to successfully plan and execute projects, including task and resource management, reporting, and change control