Made with
ConceptDraw
DIAGRAM 15

ERD Symbols and Meanings

Modeling your data using entity-relationship diagram (ERD) with Crow's Foot notation which is popular in Structured Systems Analysis, Barker's Notations, Design Methods and information engineering you need the software that is easy in use having all necessary elements for creating the needed flowcharts as well as their examples. You can find all essential ERD symbols and its meanings on our site with tutorials of how to use it and you can always use the already existing layouts for making your own diagrams in our Solution Park. Once you download our application with extension of hundreds of design elements you’ll find it simple to start using it straight away and you’ll be pleasantly surprised of how smart this tool for making the charts is.

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 DIAGRAM

ERD Symbols and Meanings

Example 1. Entity Relationship Diagram symbols and meaning

When you need to describe efficiently a database using the Crow’s Foot notation icons, ConceptDraw DIAGRAM 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 DIAGRAM enhanced with powerful Entity-Relationship Diagram (ERD) solution to draw your own ER diagrams using Chen's notation icons.

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.

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 ConceptDraw STORE

Example 2. Entity Relationship Diagram samples and templates in ConceptDraw STORE

Try it today for saving your time sake not to look for something else once you have great chance to use this excellent product already now!

The following features make ConceptDraw DIAGRAM 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 DIAGRAM 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 DIAGRAM 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.
  6. Using ConceptDraw STORE you can navigate through ConceptDraw Solution Park, managing downloads and updates. You can access libraries, templates and samples directly from the ConceptDraw STORE.
  7. If you have any questions, our free of charge support is always ready to come to your aid.

TEN RELATED HOW TO's:

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 *
Picture: Entity-Relationship Diagram
Related Solution:

UML Class Diagram Example - Buildings and Rooms →

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 shows the structure of the building and can be used by building companies, real estate agencies, at the buying / selling of the realty.UML Class Diagram Example -  Buildings and Rooms *
Picture: UML Class Diagram Example - Buildings and Rooms
Related Solution:

Workflow Diagram Symbols →

A competent delegation of responsibilities between workers guarantees business success in most cases. At first sight, it might seem that workflow diagram symbols are quite similar to a regular flowchart. But workflow diagram is a more accurate way to present working processes. Workflow diagrams are helpful for a working process analyzation, to depict a pathway of process issues, personalize responsibilities and identify resources that will help to optimize a workflow. Generally, Workflow diagram deploys flowchart symbols for displaying work process steps and relationships. But, often it require some additions and improvements to become more professional and illustrative. The Workflow solution for ConceptDraw DIAGRAM provides the user with a big library of symbols that are designed especially for workflow diagrams.Workflow Diagram Symbols *
Picture: Workflow Diagram Symbols
Related Solution:

How to Draw a Good Diagram of a Business Workflow? →

To draw a good diagram of a business workflow you should have a ready-to-use set of pre-designed objects you may drag-and-drop to your document focusing on the workflow structure and meaning, not drawing tools. ConceptDraw DIAGRAM with Workflow Diagrams solution provides complete set of design element you may use to draw a good diagram of a business workflow.How to Draw a Good Diagram of a Business Workflow? *
Picture: How to Draw a Good Diagram of a Business Workflow?
Related Solution:

Electrical Symbols, Electrical Schematic Symbols →

ConceptDraw DIAGRAM diagramming and vector drawing software enhanced with Electrical Engineering Solution from the Industrial Engineering Area of ConceptDraw Solution Park offers you powerful tools and libraries with incredibly large quantity of predesigned electrical symbols as electrical schematic symbols for easy designing professional looking Electrical Schematics.Electrical Symbols, Electrical Schematic Symbols *
Picture: Electrical Symbols, Electrical Schematic Symbols
Related Solution:

Types of Flowchart - Overview →

A flowchart is a powerful tool for examining processes. It helps improving processes a lot, as it becomes much easier to communicate between involved people, to identify potential problems and to optimize workflow. There are flowcharts of different shapes, sizes and types of flowchart vary from quite basic process flowcharts to complex program flowcharts. Nevertheless, all these diagrams use the same set of special symbols like arrows to connect blocks, parallelogram to show data receiving or rectangles for showing process steps. Basic flowcharts are used to represent a simple process algorithm. A basic flowchart notation consists of rectangles (business processes), arrows (the flow of information, documents, etc.). The same notation is used in items such as the "decision", which allow you to do the branching. To indicate the start of the entire business process and its termination can be used the "Terminator" element. The advantages of Basic Flowchart are simplicity and clarity. With it you can quickly describe the business process steps. Creating of Basic Flowchart does not require any special knowledge, as easily understand by employees with different levels of education and IQ.Types of Flowchart - Overview *
Picture: Types of Flowchart - Overview
Related Solution:

Entity Relationship Diagram Examples →

ConceptDraw DIAGRAM diagramming and vector drawing software offers the Entity-Relationship Diagram (ERD) Solution from the Software Development Area for ConceptDraw Solution Park. How many examples contains the Entity-Relationship Diagram (ERD) Solution! All Entity Relationship Diagram examples were designed and saved for ConceptDraw DIAGRAM users. Now they are available from ConceptDraw STORE.Entity Relationship Diagram Examples *
Picture: Entity Relationship Diagram Examples
Related Solution:

Road Transport - Design Elements →

Samples, templates and libraries contain vector clip art for drawing the Road Transport Illustrations.Road Transport - Design Elements *
Picture: Road Transport - Design Elements
Related Solution:
ConceptDraw
DIAGRAM 15