Anyone Have an ERD Symbols Quick Reference?
ERD drawing becomes easier with predesigned entity relationship symbols, work flow shapes, entity relationship stencils. We are glad to offer you all variety of ERD symbols you may need for ERDs design, they are packed into libraries and templates from Entity-Relationship Diagram (ERD) Solution for ConceptDraw DIAGRAM diagramming and vector drawing software.
But anyone have an ERD symbols quick reference? Detailed reference information for them is represented at the tables below on this page.
Sample 1. Anyone Have an ERD Symbols Quick Reference?
There are two notations used for ERDs: Chen and Crow's Foot. Variety of symbols offered by two libraries of Entity-Relationship Diagram (ERD) Solution covers both these notations.
Crow’s Foot notation ERD symbols
| Symbol | Meaning | |
| Relationships (Cardinality and Modality) | ||
 |
Zero or More | |
 |
One or More | |
 |
One and only One | |
 |
Zero or One | |
| Many - to - One | ||
 |
a one through many notation on one side of a relationship and a one and only one on the other | |
 |
a zero through many notation on one side of a relationship and a one and only one on the other | |
 |
a one through many notation on one side of a relationship and a zero or one notation on the other | |
 |
a zero through many notation on one side of a relationship and a zero or one notation on the other | |
| Many - to - Many | ||
 |
a zero through many on both sides of a relationship | |
 |
a one through many on both sides of a relationship | |
 |
a zero through many on one side and a one through many on the other | |
 |
a one and only one notation on one side of a relationship and a zero or one on the other | |
 |
a one and only one notation on both sides | |
Chen's notation ERD symbols
| Symbol | Shape Name | Symbol Description |
| Entities | ||
 |
Entity | An entity is represented by a rectangle which contains the entity’s name. |
 |
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. |
 |
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 | ||
 |
Attribute | In the Chen notation, each attribute is represented by an oval containing atributte’s name |
 |
Key attribute | An attribute that uniquely identifies a particular entity. The name of a key attribute is underscored. |
 |
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. |
 |
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 | ||
 |
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 |
 |
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. |
Collection of samples and examples included to Entity-Relationship Diagram (ERD) solution and represented at ConceptDraw STORE is an excellent illustration of the ease of application of ready-to-use objects for designing Entity-Relationship diagrams and models.
Example 2. ERD Example
This sample was created in ConceptDraw DIAGRAM using the vector objects from the ERD Chen's Notation library of Entity-Relationship Diagram (ERD) Solution and illustrates the Entity Relationship Diagram. An experienced user spent 15 minutes creating this sample.
Use the Entity-Relationship Diagram (ERD) Solution for ConceptDraw DIAGRAM software to create your own professional looking ER Diagrams quick, easy and effective.
All source documents are vector graphic documents. They are available for reviewing, modifying, or converting to a variety of formats (PDF file, MS PowerPoint, MS Visio, and many other graphic formats) from the ConceptDraw STORE. The Entity-Relationship Diagram (ERD) Solution is available for all ConceptDraw DIAGRAM or later users.
TEN RELATED HOW TO's:
A flowchart is a simple but very functional tool when it comes to understanding a workflow or to removing unnecessary stages from a process. When drawing flowcharts, keep in mind that there are four common types of flowcharts, like document flowcharts and data flowcharts that show control over a data or document flow over a system. To show controls on a physical level, use system flowcharts. In addition, to show controls in a program, you can draw a program flowchart.
This flowchart diagram represents the piece of an article editing process, that involves the author and editor. It was created using the Basic Flowchart notation that consists from the basic flowchart symbols. The start and the end of the process are indicated with "Terminator" symbols. The "Process" symbols show the action steps consisting from making edits and searching for a compromise, when the author does not agree with the suggestions of the editor. The "Process" symbol is the general symbol in process flowcharts. The "Decision" symbol indicates a branching in the process flow. There are two branches indicated by a Decision shape in the current flowchart (Yes/No, Disagree/Agree). This basic flowchart can be used as a repeating unit in the workflow diagram describing the working process of some editorial office.
Picture: Types of Flowcharts
Related Solution:
An abstract representation is usually the first thing you will need while developing a database. To understand the ways that databases are structured, you should look through entity-relationship diagram examples and see the notations features and attributes. With an entity-relationship model you can describe a database of any complexity.
This Entity-relationship diagram is a tool for software developers. It enables every element of database to be managed, communicated and tested before release. This ERD was created using symbols advocated by Chen's notation. Because of a linguistic origin of the Chen’s notation, the boxes representing entities could be interpreted as nouns, and the relationships between them are in verb form, shown on a diagram as a diamond.
Picture: Entity Relationship Diagram Examples
Related Solution:
Entity Relationship Diagram (ERD) is an acknowledged method to visualize the logical structure of databases. Using special symbols described in ERD notations you can depict a database of any complexity.
The vector graphic ER diagrams produced when using ConceptDraw ERD solution can be used in whitepapers, presentations, datasheets, posters, or any technical materials.
Picture: What is Entity-Relationship Diagram
Related Solution:
Chemistry solution offers 6 libraries with large collection of vector chemistry symbols and meanings, chemistry equation symbols, organic chemistry symbols, and chemical clipart.
Picture: Chemistry Symbols and Meanings
Related Solution:
Offering the stencil libraries as well as the pre-made templates and examples of the medical illustrations, the Medical Illustrations solution may be chosen in order to simplify the work of creating the medicine-related drawings. Having the mentioned tools, any ConceptDraw DIAGRAM user can draw a professionally-looking medical illustration based on the already created templates.
Picture: Medical Imaging
Related Solution:
Desbloquee el lenguaje de los diagramas de flujo con nuestra guía de símbolos de diagramas de flujo. 🔸 Todo lo que necesita saber sobre los conceptos básicos del diagrama de flujo, desde ✔️ puntos de decisión hasta ✔️ pasos del proceso, explore el significado detrás de cada símbolo y domine el arte de crear representaciones visuales claras y efectivas de sus procesos.
Picture: Symboles Organigramme
Related Solution:
To maintain big and complex mechanical systems, you need an appropriate education and tools. It’s needless to say that mechanical drawing is important part of any industrial project. There are a lot of standard symbols depicting valves, pumps, motors, etc.
This drawing illustrates the content of the Fluid Power Equipment library provided by the ConceptDraw Mechanical Engineering solution. The solution is composed from the 8 libraries, containing about 500 elements related to mechanical engineering visualization. it will be helpful for drawing various schemes, charts and blueprints of pneumatic, and hydraulic equipment or other drawing related mechanical engineering. All drawings can be freely resized without loss of quality due to the vector graphics components of its facilities.
Picture:
Mechanical Drawing Symbols F.A.Q.
How to Use Mechanical Engineering Design Software
Related Solution:
The critical importance of house electrical plans. 🔸 Learn how to create efficient electrical layouts using the ConceptDraw DIAGRAM app. Enhance ✔️ safety, ✔️ functionality, and ✔️ compliance with electrical codes in your home projects with our comprehensive guide
Picture:
Importance of House Electrical Plans
How to Create Electrical Layouts
with ConceptDraw DIAGRAM App
Related Solution:
While creating flowcharts and process flow diagrams, you should use special objects to define different statements, so anyone aware of flowcharts can get your scheme right. There is a short and an extended list of basic flowchart symbols and their meaning. Basic flowchart symbols include terminator objects, rectangles for describing steps of a process, diamonds representing appearing conditions and questions and parallelograms to show incoming data.
This diagram gives a general review of the standard symbols that are used when creating flowcharts and process flow diagrams. The practice of using a set of standard flowchart symbols was admitted in order to make flowcharts and other process flow diagrams created by any person properly understandable by other people. The flowchart symbols depict different kinds of actions and phases in a process. The sequence of the actions, and the relationships between them are shown by special lines and arrows. There are a large number of flowchart symbols. Which of them can be used in the particular diagram depends on its type. For instance, some symbols used in data flow diagrams usually are not used in the process flowcharts. Business process system use exactly these flowchart symbols.
Picture: Flowchart Symbols: Meaning and Examples
Related Solution:
Electrical Engineering Solution used together with ConceptDraw DIAGRAM drawing facilities makes short a work of drawing various electrical and electronic circuit schemes. A library of vector objects composed from symbols of Analog and Digital Logic elements of electric circuit includes 40 symbolic images of logic gates, bistable switches of bi-stable electric current, circuit controllers, amplifiers, regulators, generators, etc. All of them can be applied in electronic circuit schemes for showing both analog and digital elements of the circuit.
Electrical Engineering Solution used together with ConceptDraw DIAGRAM drawing facilities makes short a work of drawing various electrical and electronic circuit schemes. A library of vector objects composed from symbols of Analog and Digital Logic elements of electric circuit includes 40 symbolic images of logic gates, bistable switches of bi-stable electric current, circuit controllers, amplifiers, regulators, generators, etc. All of them can be applied in electronic circuit schemes for showing both analog and digital elements of the circuit.
Picture:
Electrical Diagram Symbols F.A.Q.
How to Use Electrical ConceptDraw Diagram Software
Related Solution:
ConceptDraw
DIAGRAM 18