Entity Relationship Diagram Symbols
About Entity-relationship Diagram
The so-called semantic modeling method nowadays is commonly used in database structure design. Semantic modeling is modeling data structures, based on the meaning of these data. Different variants of the entity-relationship diagrams are used as a tool for the semantic modeling. ER-model based diagrams have three main components: an entity, a relation and attributes. An entity is a class of similar objects, information about which should be taken into account in the model. Each entity must have a name, expressed by a noun in the singular. Examples of entities can be such classes of objects as "Supplier", "Employee", "Invoice". Each entity in the model is depicted in the form of a rectangle with the name.
While determining the type of entity it is necessary to be sure that each instance of an entity may be indistinguishable from any other instance of the same entity.
Relation is presented in the form of non-directional line connecting two entities or leading from the entity to itself. In the place of "docking" an entity uses:
- three-point entry to the entity rectangle, if many instances of the entity may be used for this relation
- single-point entry, if relation can (or should) participate in only one instance of the entity.
Relation between entities "ticket" and "passenger" connects passengers and tickets. One side of the relation with a label "for" is a many-to-many relation which allows to relate more than one ticket to a passenger, and each ticket must be linked to any passenger. Another side of the relation with a label "have" is a zero or one relation, which shows that each ticket can belong to only one passenger, and the passenger is not obliged to have at least one ticket.
Attribute of an entity is a detail or feature that is used for verification, identification, classification, numerical characteristics or expressing status of the entity. Attribute names are recorded in the rectangle representing an entity under entity name. For instance, an entity "human being" may have such attributes as gender, year of birth, first name, etc.
It is the specialized Entity Relationship diagram symbols, and the meanings of those symbols
Entity Relationship Diagram Symbols — Chen 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. |
Entity Relationship Diagram Symbols — Crow’s Foot notation
| Symbol | Meaning | |
| Relationships (Cardinality and Modality) | ||
 |
Zero or One | |
 |
One or More | |
 |
One and only One | |
 |
Zero or More | |
| 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 zero through many on one side and a one through many on the other | |
 |
a one through many on both sides of a relationship | |
 |
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 | |
There are many notation styles that express cardinality:
- Information Engineering Style;
- Chen Style;
- Bachman Style;
- Martin Style;
Example 1. Entity relationship diagram symbols, Chen's and Crow’s Foot notation
Entity-Relationship model making possibility to describe a database by abstract way. The data in database tables can be the point to data in other tables - for instance, your entry in the database could point to several entries.
Example 2. Entity Relationship Diagram (ERD) Software (Windows)
ConceptDraw DIAGRAM software thanks to the included Entity-Relationship Diagram (ERD) solution gives the ability to describe visually a database using the Chen's and Crow’s Foot notation icons for drawing ER diagrams (ERD).
Example 3. Entity Relationship Diagram (ERD) Software (macOS)
Very commonly used in the database structure design, the sematic modelling method is one the ways of describing data structures as well as its modelling, based on the meaning of this data. ER-model based diagrams (ERD) consist of these main components: relation, entity and attributes. To be able to create such diagram, you have to mention the entities with their names presented in a form of a rectangle and the relations in a way of non-directional line connecting two entities. To help you to create this chart, we developed ConceptDraw STORE product full of libraries with vector elements you can use for your flowchart. Also we provide you with Solutions section on this site where you can find the numerous stencil libraries, samples and examples to simplify your work with software called ConceptDraw DIAGRAM which is the only one offering that many symbols and templates for making professionally looking smart and mature diagrams.
TEN RELATED HOW TO's:
Wireless Network Drawing →
The Wireless Network solution helps users to quickly transition from an idea to the implementation of a wireless computer network. ConceptDraw DIAGRAM is well placed to provide experienced and comprehensive assistance in the workplace. The vector stencils, examples, and templates included to solution is a strong toolset for network engineer.
Local area network (LAN). Computer and Network Examples →
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.
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.
Electrical Symbols — Transformers and Windings →
A transformer is an electrical device that transfers electrical energy between two or more circuits through electromagnetic induction. Electromagnetic induction produces an electromotive force within a conductor which is exposed to time varying magnetic fields. Transformers are used to increase or decrease the alternating voltages in electric power applications. 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.
Introductory Guide to Rapid UML Solution →
The ability to develop UML diagrams as quickly as the ideas come. The solution uses ConceptDraw RapidDraw techniques. The result is a vector graphic document.
Flow Chart Symbols →
If you need to describe some process, diagramming is a perfect tool for almost any imaginable purpose. The set of the most commonly used flow charts symbols is quite wide and includes symbols for operations, processes, data inputs and outputs. You can see the full list of all the symbols used for flowcharting in Flowcharts solution from Diagrams area in ConceptDraw Solution Park. A flow chart is often used for visual representation of a sequential process flow. The flowchart approach to any process is to divide it into some sequential actions. What makes a flow chart so popular and clear to make out is the set of standard flowchart symbols that has the same reading independently from processes described with their applying. The current drawing represents the vector library containing the pack of standard flowchart symbols. This library is supplied with ConceptDraw Flowcharts solution.
Fishbone Diagram Problem Solving →
The Ishikawa diagram, Cause and Effect diagram, Fishbone diagram — all they are the names of one and the same visual method for working with causal connections. Originally invented by Kaoru Ishikawa to control the process quality, the Ishikawa diagram is well proven in other fields of management and personal scheduling, events planning, time management. It is a chart in the form of a fish, whose head is a problem, the fins are variants for its causes. To design easily the Fishbone diagram, you can use a special ConceptDraw DIAGRAM vector graphic and diagramming software which contains the powerful tools for Fishbone diagram problem solving offered by Fishbone Diagrams solution for the Management area of ConceptDraw Solution Park.
Process Flow Chart Symbols →
Process Flow Chart is a visual diagram which shows the processes and relationships between the major components in a system, and uses for this the special process flow chart symbols: special shapes to represent different types of actions and process steps, lines and arrows to represent relationships and sequence of steps. It often named process flow diagram, it use colored flowchart symbols. It is incredibly convenient to use the ConceptDraw DIAGRAM software extended with Flowcharts Solution from the "Diagrams" Area of ConceptDraw Solution Park for designing professional looking Process Flow Charts.
Maps and Directions →
ConceptDraw DIAGRAM diagramming and vector drawing software extended with Directional Maps Solution from the Maps Area of ConceptDraw Solution Park is a powerful maps and directions design software. Let's review the tools of this solution.