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:
Internal medicine is a field of medicine devoted to the study of etiology, also pathogenesis and clinical manifestations of a number of diseases of human internal organs, as well as their prevention, diagnosis and treatment with subsequent rehabilitation. The benefits of use the ConceptDraw ready-made design elements and symbols when drawing medical and health diagrams, infographics and illustrations are obvious. They allow to visualize the generally accepted laws in a given area, as well as innovations, ideas and developments, in a shortest possible interval of time and with minimal efforts.
Picture: Internal Medicine
Related Solution:
This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the Seven Management and Planning Tools Solution from the Business Productivity area of ConceptDraw Solution Park.
This sample shows the Property Management matrix, the ideas are ordered in regards to importance and frequency. This matrix gives the ability to turn the theory into quantifiable data.
Picture: Property Management Examples
Related Solution:
Still concerned about fire safety in your establishment? Be sure that all the necessary elements like registers, drills and diffusers are present on your plan. Otherwise, you have to put them on it immediately.
Here you can see the Registers, Drills and Diffusers library that contains vector graphical objects depicting various, drills, diffusers and registers that are used in HVAC systems and reflected ceilings. ConceptDraw had solutions designed to support both. You can use it to create effortlessly Reflected Ceiling plans, HVAC plans and other interior design and building plans related issues. ConceptDraw DIAGRAM provides a complete set of tools for creating graphical documents in compliance with all requirements of modern design of technical documentation.
Picture: Interior Design. Registers, Drills and Diffusers — Design Elements
Related Solution:
The vector stencils library Activity diagrams from the solution Rapid UML contains specific data modeling symbols for ConceptDraw DIAGRAM software.
Picture: Data Modeling Diagram
ConceptDraw DIAGRAM is a chemistry drawing software that is ideal for designing of various: chemistry drawings, scientific and educational chemistry illustrations, schemes and diagrams of chemical and biological lab set-ups, images with chemical formulas
Picture: Chemistry Drawings
Related Solution:
Use ConceptDraw DIAGRAM software as powerful electrical engineering software and apply switches and relays electrical symbols in ✔️ electrical circuit diagrams, ✔️ electrical drawings, ✔️ electrical schematics, ✔️ wiring diagrams, ✔️ electrical blueprints
Picture: Electrical Symbols — Switches and Relays
Related Solution:
You need design the Functional Block Diagram and dream to find the useful tools to draw it easier, quickly and effectively? ConceptDraw DIAGRAM offers the Block Diagrams Solution from the Diagrams Area which will help you!
Picture: Functional Block Diagram
Related Solution:
When talking about engineering, one should define all the terms used, so anybody could understand the topic. Typical network glossary contains definitions of numerous network appliances, types of networks and cable systems. The understanding of basic is crucial for server management, network administration and investigating problems.
The network glossary defines terms related to networking and communications. The most of glossary items has their visual representation in ConceptDraw DIAGRAM libraries of the Computer Network Diagrams solution. This illustration presents a local area network (LAN) diagram. It designed to show the way the interaction of network devices in a local network. The diagram uses a library containing symbols of network equipment, connections and the end-point devices such as network printer, hubs, server, modem and finally computers (PC, mac, laptop). This diagram depicts a physical LAN topology.
Picture: Network Glossary Definition
Related Solution:
There are a lot of structured analysis and design technique methodologies used to describe systems and data sources. To visualize data structures, data flow diagrams can be used for various purposes in the area of software engineering. Nowadays these diagrams are also used in the area of business analysis and information system analysis.
This data flow diagram depicts an account processing system of a typical account department of a small manufacturing enterprise. It shows the data transmission through the order processing to shipping verification. This data flow diagram was created according to standard of Yourdon and Coad notation. The vector graphic objects of Yourdon/Coad notation symbols was delivered by ConceptDraw Data Flow Diagrams solution. The current DFD can be employed as an example of a business process model, representing the set of business events and interactions commonly engaged in a accounts receivable process.
Picture: Data Flow Diagrams
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:
ConceptDraw
DIAGRAM 18