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)

Entity Relationship Diagram Symbols

Creating an entity-relationship (ER) model is to visually represent the structure of a business database, where data equates to entities (or objects) that are linked by defined relationships expressing dependencies and requirements. By nature it is an abstract visualization, the first step in the design process towards creating a logical and functional database.
ERD symbols used for professional ERD drawing are collected in libraries from the Entity-Relationship Diagram (ERD) solution for ConceptDraw DIAGRAM.

Entity-Relationship Diagram

Entity Relationship Diagram (ERD) is the world-known way to show the logical structure of databases in visual manner. The best software tool for drawing Entity-Relationship Diagram is ConceptDraw DIAGRAM vector graphics software with Entity-Relationship Diagram (ERD) solution from Software Development area which gives the ability to describe a database using the Entity-Relationship model. The vector graphic diagrams produced using this solution can be successfully used in whitepapers, presentations, datasheets, posters, or any technical materials.

Entity Relationship Diagram Software Engineering

Entity Relationship Diagram (aka ERD, ER Diagram, E-R Diagram) is a well-tried software engineering tool for data modeling, system design and illustrating the logical structure of databases.
Professional ERD drawing is an essential software engineering method for database modeling. ConceptDraw DIAGRAM as a powerful Entity Relationship Diagram Software Engineering offers the tools of Entity-Relationship Diagram (ERD) solution from Software Development area of ConceptDraw Solution Park.

Entity Relationship Diagram Software for Mac

One of the most popular semantic data models is the "entity-relationship" model (often called ER-model). Most of the modern approaches to the database (mainly relational) design are based on the usage of different versions of ER- model. Domain modeling is based on the use of graphic charts, including a small number of heterogeneous components. The simplicity and the presentation clarity of the conceptual basis of these ER-model schemes led to its widespread deployment in the CASE-systems that support automatic design of relational databases.
A relation is a graphically depicted association between two entities. As well as the entity, a relation is a typical concept, all instances of the linked entity types are subject to the rules established by the connecting. Therefore, it is more correct to speak about the relationship type made between types of entities and about the instances of relationship types made between instances of the entity type. In common ER-model this association is a

Design Element: Crows Foot for Entity Relationship Diagram - ERD

Creating an ERD requires choosing a specific set of notations that best serve the specific database being designed. ConceptDraw DIAGRAM software extended with Entity-Relationship Diagram (ERD) solution from Software Development area of ConceptDraw Solution Park allows you to draw ER diagrams for depicting a database using the ERD diagram design element Crow's Foot - Crow′s Foot notation icons.

Entity Relationship Diagram Examples

Create an Entity-Relationship (ER) model is to visually represent the structure of a business database, where data equates to entities (or objects) that are linked by defined relationships expressing dependencies and requirements. By nature it is an abstract visualization, the first step in the design process towards creating a logical and functional database.

ConceptDraw DIAGRAM diagramming and vector drawing software gives the ability to describe a database using the Entity-Relationship model. Entity-Relationship Diagram(ERD) solution from the Software Development area supplies the ConceptDraw DIAGRAM with icons advocated by Chen's and Crow’s Foot notation that can be used when describing a database.
How to Build an Entity Relationship Diagram (ERD)
How to Build an Entity Relationship Diagram (ERD)

Components of ER Diagram

ConceptDraw gives the ability to draw ER diagram (ERD) for visual describing database using the entity relationship symbols, work flow shapes, entity relationship stencils. Entity-Relationship model making possibility to describe a database using the components of ER Diagram 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.

ER Diagram for Cloud Computing

The entity–relationship (ER) model is a data model that lets graphically represent the information system and depict the relationships between people, objects, concepts, places, and events within a given system. It is also convenient to use the ER Diagram for Cloud computing representation and description the Cloud computing architecture, design them with pleasure using the extensive tools of the Cloud Computing Diagrams solution from the Computers and Network area of ConceptDraw Solution Park.
The vector stencils library "UML class diagrams" contains 38 symbols for the ConceptDraw PRO diagramming and vector drawing software.
"... classes are represented with boxes which contain three parts:
(1) The top part contains the name of the class. It is printed in Bold, centered and the first letter capitalized.
(2) The middle part contains the attributes of the class. They are left aligned and the first letter is lower case.
(3) The bottom part gives the methods or operations the class can take or undertake. They are also left aligned and the first letter is lower case. ...
To indicate a classifier scope for a member, its name must be underlined. ...
An association can be named, and the ends of an association can be adorned with role names, ownership indicators, multiplicity, visibility, and other properties. ...
Aggregation ... is graphically represented as a hollow diamond shape on the containing class end of the tree with a single line that connects the contained class to the containing class.
... graphical representation of a composition relationship is a filled diamond shape on the containing class end of the tree of lines that connect contained class(es) to the containing class.
... graphical representation of a Generalization is a hollow triangle shape on the superclass end of the line (or tree of lines) that connects it to one or more subtypes.
... graphical representation of a Realization is a hollow triangle shape on the interface end of the dashed line (or tree of lines) that connects it to one or more implementers. A plain arrow head is used on the interface end of the dashed line that connects it to its users.
Multiplicity ... representation of an association is a line with an optional arrowhead indicating the role of the object(s) in the relationship, and an optional notation at each end indicating the multiplicity of instances of that entity (the number of objects that participate in the association).
Entity classes ... are drawn as circles with a short line attached to the bottom of the circle. Alternatively, they can be drawn as normal classes with the «entity» stereotype notation above the class name." [Class diagram. Wikipedia]
The example "Design elements - UML class diagrams" is included in the Rapid UML solution from the Software Development area of ConceptDraw Solution Park.
UML class diagram symbols
UML class diagram symbols, template class, self association, package, object, note, interface, frame, component, class, NARY, N-ary association,
"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,