Notation & Symbols for ERD
Creation of the entity-relationship model is one of the most important stages in the process of creating databases and modeling of business processes. Entity Relationship Diagram (ERD) reflects reality and allows you to get the most complete picture about the actual data requirements that are set at the company.
The entity-relationship model described in form of ERD represents the information that is gathered and used at the conduct of business. It visually shows how the database or application system will look, but doesn't disclose a way of realization. The ERD doesn't depend on the choice of database producer. It groups the data into separate entities and links these entities to each other on the base of business rules. The entity has the contents and represents some object about which is needed to store information. The business rules is a line of conduct and procedures for the business organization, they describe how the company is functioning.
The ER diagram is constructed from the specific ERD graphic elements. There are used 2 types of ERD notations: Chen and Crow's Foot.
A complete set of work flow shapes, notation & symbols for ERD, entity relationship stencils, included in Entity-Relationship Diagram (ERD) solution for ConceptDraw DIAGRAM software, makes drawing diagrams based on ERD notation as smooth as possible.
Example 1. Entity relationship diagram (ERD) symbols, Crow's Foot notation
All these ERD symbols are vector, you can drag to the document to construct the ER Diagram, resize any of them without loss of quality, change their color to make your diagram more attractive and colorful.
ERD Chen's notation
| 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. |
Example 2. ER Diagram - Chen's Notation
ERD Crow’s Foot notation
| 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 | |
Example 3. ER Diagram - Crow's Foot Notation
The samples you see on this page were created in ConceptDraw DIAGRAM using the Entity-Relationship Diagram (ERD) solution from Software Development area of ConceptDraw Solution Park. An experienced user spent 10 minutes creating these samples.
Use the Entity-Relationship Diagram (ERD) Solution for ConceptDraw DIAGRAM software to create quick and easy your own professional looking ERDs using Crow's Foot and Chen notations.
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:
Android GUI →
Android is an operating system based on the Linux kernel and developed by Google for smartphones, tablet computers, electronic books, netbooks, smartbooks, digital players, watches, game consoles, TV and other devices. ConceptDraw DIAGRAM extended with Android User Interface Solution from the Software Development Area is a powerful software with extensive drawing tools which can help you to build the intelligible, attractive and easy for perception Android GUI for your application.
Biology Symbols →
ConceptDraw DIAGRAM diagramming and vector drawing software extended with Biology solution from the Science and Education area offers a set of useful tools for fast and easy drawing of various biology illustrations and drawings.Biology solution provides 3 libraries with large quantity of vector biology symbols: Biochemistry of Metabolism Library, Carbohydrate Metabolism Library, Citric Acid Cycle (TCA Cycle) Library.
Work Flow Process Chart →
Workflow Diagram - workflow process diagram is a visual representation of a organizational process flow. Often it used as the same visual notation as process flow diagram. Visualising business processes using workflow diagram (workflow process diagram) allows estimate business process efficiency, analyse and optimize the process itself. Workflow diagram helps get focusing on each step and relations between workflow steps. ConceptDraw DIAGRAM is software for making workflow diagram. It contains specific designed graphics to draw workflow diagrams effectively. This is workflow diagram maker which do your work process effective.
IDEF0 standard with ConceptDraw DIAGRAM →
The activity of any organization is more or less branchy network of processes. The description of these processes is a hard technical task which requires definite methodology and standards. According to the IDEF0 standard any process can be described in the form of a block (Activity Box) which has inputs and outputs. The process consists in transformation of inputs into outputs under the influence of the management and in the presence of necessary resources. Outputs of the given process later on can be either inputs for the next process or resources, or management means.
Interior Design. Storage and Distribution — Design Elements →
Talking about interior design, we usually mean apartments, houses or establishments. But there’s much more to this, for instance, interiors in warehouses, storage and distribution departments and machine shops also require designing. You can find all the necessary design elements such as cranes and forklifts in Plant Layout Plans solution ConceptDraw Solution Park. This picture represents content of the Storage and Distribution library, providing the collection of vector images designed to plan layouts of industrial storage facilities (warehouses). Warehouse is a premises and equipment intended for the reception, distribution and storage of products manufactured at the plant, as well as to preparation the product for shipment to the consumer. This vector images library is supplied with ConceptDraw Plant Layout Plans solution. it will help to industrial architects and planners to design plans for industrial storage and shipping facilities.
How To Make the Right Decision in Projects →
A key point of conference success is the ability to see slides in real time, and hold documented discussions during the meeting. Remote Presentation for Skype is a new solution allows real-time presenting that benefits work groups who need collaborate by web meetings.
Geo Map — Europe — Finland →
The vector stencils library Finland contains contours for ConceptDraw DIAGRAM diagramming and vector drawing software. This library is contained in the Continent Maps solution from Maps area of ConceptDraw Solution Park.
Interior Design. Plumbing — Design Elements →
Every interior design project starts from a deep understanding of all the utilities used in the building. In the first place, plumbing projection stage is crucial for the future design because it is very important to fit all the elements in their places correctly. Kitchen interior, for instance, will depend on the plumbing very much. Planning the layout of bathroom facilities, plumbing and sanitary equipment is a critical stage of the interior design of the entire house. Suppose, you do not need to see grill in your bathroom and the toilet in your kitchen, you need to give the proper consideration to the plumbing and piping planning. The ConceptDraw Plumbing and Piping Plans solution delivers the kit of 4 vector libraries containing more than 120 elements as pumps, tanks, pipes, boilers and other bathroom equipment for depicting Plumbing & Piping Plans. Using the Plumbing library, enables designing plumbing and piping interior designs, schemes and blueprints of water supply and sewerage systems.
Electrical Symbols — Switches and Relays →
In electrical engineering, a switch is an electrical component that can break an electrical circuit, interrupting the current or diverting it from one conductor to another. The mechanism of a switch may be operated directly by a human operator to control a circuit (for example, a light switch or a keyboard button), may be operated by a moving object such as a door-operated switch, or may be operated by some sensing element for pressure, temperature or flow. A relay is a switch that is operated by electricity. Switches are made to handle a wide range of voltages and currents; very large switches may be used to isolate high-voltage circuits in electrical substations. 26 libraries of the Electrical Engineering Solution of ConceptDraw DIAGRAM make your electrical diagramming simple, efficient, and effective. You can simply and quickly drop the ready-to-use objects from libraries into your document to create the electrical diagram.
UML Diagram Types List →
Two types of diagrams are used in UML: Structure Diagrams and Behavior Diagrams. Behavior Diagrams represent the processes proceeding in a modeled environment. Structure Diagrams represent the elements that compose the system.