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)
"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,
"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,

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

A four level pyramid model of different types of Information Systems based on the different levels of hierarchy in an organization.

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.