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:
ConceptDraw DIAGRAM is a software for simplу depicting the business processes based on BPMN 2.0.
Business Process Diagrams Cross-Functional-Flowcharts, Workflows, Process Charts, IDEF0 and IDEF2, Timeline, Calendars, Gantt Charts, Business Process Modeling, Audit and Opportunity Flowcharts and Mind Maps (presentations, meeting agendas).
Picture: Business Process Modeling Notation
Related Solution:
Engineering students usually have huge amount of homework. Learning how to develop a technical drawing is one of the necessary skills. Luckily, at the present time, there’s no need to draw it on paper, because there a lot of software tools for it.
This drawing represents the Bearing symbols library, that is the part of the ConceptDraw Mechanical Engineering solution. Bearings are the important components of any movable mechanism. The function of bearing is to align, guide, and support the moving parts in any mechanical construction. Usually they are located between moving and stationary parts, it works as a connection point between them. Using Mechanical Engineering solution and ConceptDraw DIAGRAM one can effortlessly draw engineering diagrams of any complexity.
Picture: Technical Drawing Software
Related Solution:
The Workflow diagrams are the specialized type of flowcharts which allow to visualize any sorts of step-by-step processes. They are usually created as flowcharts, with objects that represent in a simple visual manner the steps in the process connected by arrows that indicate the next step. The ability easily create Workflow diagrams visually describing the tasks, documents associated with the tasks, people which are responsible for execution at each stage of workflow is made possible with Workflow Diagrams solution. This solution extends ConceptDraw DIAGRAM with a Workflow Diagram library that contains large collection of predesigned workflow flowchart symbols.
Picture: Workflow Flowchart Symbols
Related Solution:
If you ever tried programming, you could face a lot of problems as a beginner. To help yourself, create a flowchart to follow an algorithm logic. Flowchart represents a program as a sequence of steps depicted in special symbols for each type of action.
This image of the interactive diagram made in ConceptDraw DIAGRAM applying the Live Objects technology. The diagram shows the effect of Selection Sort algorithm. The left part of the chart is the input area. The diagram in the central part of the drawing is a flow chart showing of the selection sort algorithm. The flowchart includes basic flowchart symbols, that represent various stages of algorithm. The flowchart symbols are connected with arrows ended lines, that depict the direction of the process flow. On the right side — the result is displayed.
Picture: What Is a Flowchart? Definition, Symbols, Examples and How to Create One
Related Solution:
The HR Management Software is an incredibly powerful tool for those who need to analyze or present human resource process flows in a visually effective manner.
Picture: HR Management Software
Related Solution:
ConceptDraw DIAGRAM is a professional software for building of great-looking Flowcharts ✔️ of various types and any degree of complexity, ✔️ in a few simple steps, ✔️ even if you have no experience, ✔️ using RapidDraw technology, ✔️ to perform different tasks in different fields
Picture: How to Build a Flowchart
Related Solution:
Data base diagrams describes inter-related data and tables. It describes roles and relationships, internal and external dependencies, data exchange conventions and structures of knowledge domain.
ConceptDraw Software provides number of data-base chart libraries including major 49 vector symbols. Use these DFD flowchart symbol libraries to design data-base structure and models, use it to design data base process-oriented models, or simple data-oriented models. The are special drawing tools for making data flowcharts, data process diagrams, structured analysis diagrams, and information flow diagrams.
Picture: Database Flowchart Symbols
Related Solution:
There are numerous articles about the advantages of flowcharting, creating business graphics and developing different charts. Nevertheless, these articles are almost useless without the main component - the examples of flowcharts, org charts and without a fine example, it is difficult to get all the conveniences of creating diagrams. You can find tons of templates and vivid examples on Solution Park.
This illustration shows a variety of business diagrams that can be created using ConceptDraw DIAGRAM. It comprises a different fields of business activities: management, marketing, networking, software and database development along with design of infographics and business illustrations. ConceptDraw DIAGRAM provides a huge set of sample drawings including business process modeling diagrams,, network diagrams, UML diagrams, orgcharts, DFD, flowcharts, ERD, geographical maps and more.
Picture: Examples of Flowcharts, Org Charts and More
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:
The ConceptDraw vector stencils library Cisco LAN contains symbols for drawing the computer local area network diagrams.
Picture: Cisco LAN. Cisco icons, shapes, stencils and symbols
Related Solution:
ConceptDraw
DIAGRAM 18