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:
The vector stencils library Chen ERD from the solution Entity-Relationship Diagrams (ERD) contains specific symbols of the Chen ERD notation including entity symbols and relationship 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.
Picture: Chen ERD Diagram
Related Solution:
Functional modeling allows to make complex business processes simple. One of the basic methods is IDEF0 and one of the most effective also. To create a business model, use flowchart symbols.
The IDEF0 library, supplied with ConceptDraw IDEF0 Diagrams solution contains 18 IDEF0 basic notation symbols. All symbols are the vector graphic images what means, that one can customize their size preserving the stable quality. Another library of IDEF0 symbols can be find out in the the Business Process Diagrams solution, included to the Business Processes section of ConceptDraw Solution Park. These libraries composed from just vector objects and are totally compatible. You can apply the IDEF0 symbols from both libraries at your flowcharts, if needed.
Picture: IDEF0 Flowchart Symbols
Related Solution:
Computer networks nowadays are spread all across the world. The large number of parameters, such as geographic scale or communication protocols, can divide networks. One of the most common types of networks is called local area network (LAN). It convenient to represent network examples by means of diagrams.
This local area network (LAN) diagram provides an easy way to see the way the devices in a local network are interacted. The diagram uses a library containing specific symbols to represent network equipment , media and the end-user devices such as computers (PC, mac, laptop) , network printer, hubs, server and finally a modem. There are two types of network topologies: physical and logical. The current diagram represents precisely a physical type of LAN topology because it refers to the physical layout of a local network equipment.
Picture:
What is a Local Area Network?
Examples of LAN Diagrams
Related Solution:
Use the set of special professionally developed swim lane flowchart symbols - single, multiple, vertical and horizontal lanes from the Swimlanes and Swimlanes BPMN 1.2 libraries from the Business Process Diagram solution, the Swim Lanes library from the Business Process Mapping solution as the perfect basis for your Swim Lane Flowcharts of processes, algorithms and procedures.
Picture: Swim Lane Flowchart Symbols
Related Solution:
ConceptDraw DIAGRAM software is a great assistant in electrical engineering and electrical design. It is efficient in creating ✔️ complex and simple electrical designs, ✔️ power generation, transmission, and distribution electrical schematics, ✔️ transformers diagrams, ✔️ electrical schematics with transformers
Picture: Electrical Symbols — Transformers and Windings
Related Solution:
The Rapid UML solution from Software Development area of ConceptDraw Solution Park includes 13 vector stencils libraries for drawing the UML 2.4 diagrams using ConceptDraw DIAGRAM diagramming and vector drawing software.
Picture: Design Elements for UML Diagrams
Related Solution:
This sample shows the Flowchart that displays the layout and work flow of the cloud marketing platform. This diagram has a style of the marketing brochure. This style displays the central product that is related to the other issues.
Using the ready-to-use predesigned objects, samples and templates from the Flowcharts Solution for ConceptDraw DIAGRAM you can create your own professional looking Flowchart Diagrams quick and easy.
Picture: Flowchart Marketing Process. Flowchart Examples
Related Solution:
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.
Picture: Entity-Relationship Diagram
Related Solution:
It doesn’t matter what kind of business you have, a bar or a gym, there are common concepts for any of them. One of those concepts is accounting, and to facilitate the work with the figures, you can use accounting flowchart symbols and create a clear and representative scheme. You can create flowchart for auditing, tax accounting and even for planning your own budget.
A graphical tool for displaying successive processes is flowchart. This method is mostly suited to represent an accounting process. The sequence of steps in the accounting process usually consists of standard accounting procedures, that can be depicted by using a minimal number of symbols, applied for the basic flowcharting. The advanced opportunity to create professional Accounting Flow charts is provided by ConceptDraw Accounting Flowcharts solution. It includes contains a library of accounting flowchart symbols used when drawing the accounting process flow.
Picture: Accounting Flowchart Symbols
Related Solution:
ConceptDraw
DIAGRAM 18