Made with
ConceptDraw
DIAGRAM 15

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.

Entity Relationship Diagram

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
ERD Symbols and Meaning - Entity Entity An entity is represented by a rectangle which contains the entity’s name.
ERD Symbols and Meaning - Weak Entity 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.
ERD Symbols and Meaning - Associative 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
ERD Symbols and Meaning - Attribute Attribute In the Chen notation, each attribute is represented by an oval containing atributte’s name
ERD Symbols and Meaning - Key attribute Key attribute An attribute that uniquely identifies a particular entity. The name of a key attribute is underscored.
ERD Symbols and Meaning - Multivalue attribute 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.
ERD Symbols and Meaning - Derived attribute 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
ERD Symbols and Meaning - Relationship 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
ERD Symbols and Meaning - Identifying Relationship 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)
ERD symbol -  Entity relationship Zero or One
ERD symbol -  Entity relationship One or More
ERD symbol -  Entity relationship One and only One
ERD symbol -  Entity relationship Zero or More
Many - to - One
ERD Symbols - Relationship Many to One a one through many notation on one side of a relationship and a one and only one on the other
ERD Symbols - Relationship Many to One a zero through many notation on one side of a relationship and a one and only one on the other
ERD Symbols - Relationship Many to One a one through many notation on one side of a relationship and a zero or one notation on the other
ERD Symbols - Relationship Many to One a zero through many notation on one side of a relationship and a zero or one notation on the other
Many - to - Many
ERD Symbols - Relationship Many to Many a zero through many on both sides of a relationship
ERD Symbols - Relationship Many to Many a zero through many on one side and a one through many on the other
ERD Symbols - Relationship Many to Many a one through many on both sides of a relationship
ERD Symbols - Relationship Many to Many a one and only one notation on one side of a relationship and a zero or one on the other
ERD Symbols - Relationship Many to Many 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;

Entity Relationship Diagram Symbols

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.

Entity relationship diagram

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).

Entity Relationship Diagram ERD Software

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:

Functional Flow Block Diagram →

You need to draw a Functional Flow Block Diagram? You are an artist? Now it doesn't matter. With Block Diagrams solution from the "Diagrams" area for ConceptDraw Solution Park you don't need more to be an artist to design the Functional Flow Block Diagram of any complexity.Functional Flow Block Diagram *
Picture: Functional Flow Block Diagram
Related Solution:

Flowcharts in Word →

To create flowcharts in MS Word, programs designed specifically for the purpose of creating flowcharts are particularly well-suited to the task.Flowcharts in Word *
Picture: Flowcharts in Word
Related Solution:

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.Local area network (LAN) diagram
Picture: Local area network (LAN). Computer and Network Examples
Related Solution:

Building Drawing Software for Design Sport Fields →

It's obvious that any building has a plan, and it is a hard and diligent work to draw one. And it's great that nowadays there are software tools for those purposes. For instance, ConceptDraw Pro contains design elements depicting different parts of sport fields. It's easy to use them and it facilitates your work exponentially. Planning of athletic facilities, playgrounds and Leisure Centers, needs thoughtful and creative approach. Any layout regarding to sport facilities should satisfy the requirements of both athletes and spectators. Well designed sport fields , playgrounds and recreation spaces attract people to sport activities in the cities and countryside. ConceptDraw Sport Field Plans solution is useful and convenient professional drawing tool. It delivers the kit of vector libraries that can be used for representing sport fields, sportgrounds and recreation spaces: football, hockey, volleyball, cricket, basketball , swimming pool, etc.Building Drawing Software for Design Sport Fields
Picture: Building Drawing Software for Design Sport Fields
Related Solution:

How to Make Audio and Video Connections →

Use the ConceptDraw DIAGRAM software that has vector clipart of numerous cable connectors, examples, and templates for drawing different types of audio and video connection diagrams. Paste icon of the receiver or another device to page and layout sockets and plugs. Further connect plugs with each other, and now you have well-designed connection diagram.How to Make Audio and Video Connections *
Picture: How to Make Audio and Video Connections
Related Solution:

Basic Circles Venn Diagram. Venn Diagram Example →

Venn Diagrams visualize all possible logical relations between several sets and are widely used in mathematics, logic, statistics, marketing, sociology, etc. This Venn Diagram shows the relative complement of the set A with respect to the set B. It is the set of the elements in B, but not in A. In other words it is the set-theoretic difference B-A.Venn Diagram Example - Basic Circles Venn Diagram
Picture: Basic Circles Venn Diagram. Venn Diagram Example
Related Solution:

Building Plans with ConceptDraw DIAGRAM →

If it is necessary for you to create the building plan you can draw it manually on the sheet of paper, but also you can use special software. With the help of ConceptDraw you can create the building plan of any difficulty. Thanks to special templates and objects libraries this won't take you much time and won't demand special skills.Building Plans with ConceptDraw DIAGRAM
Picture: Building Plans with ConceptDraw DIAGRAM
Related Solution:

Flow chart Example. Warehouse Flowchart →

If you want to find a way to understand complex things in minutes, you should try to visualize data. One of the most useful tool for this is creating a flowchart, which is a diagram representing stages of some process in sequential order. There are so many possible uses of flowcharts and you can find tons of flow charts examples and predesigned templates on the Internet. Warehouse flowchart is often used for describing workflow and business process mapping. Using your imagination, you can simplify your job or daily routine with flowcharts. Warehouse flowcharts are used to document product and information flow between sources of supply and consumers. The flowchart provides the staged guidance on how to manage each aspect of warehousing and describes such aspects as receiving of supplies; control of quality; shipment and storage and corresponding document flow. Warehouse flowchart, being actual is a good source of information. It indicates the stepwise way to complete the warehouse and inventory management process flow. Also it can be very useful for an inventory and audit procedures.Warehouse Flowchart
Picture: Flow chart Example. Warehouse Flowchart
Related Solution:

How To Draw Building Plans →

Architectural drawing allows to show the location of a building or ensemble of buildings on the ground, indicating the cardinal points. For centuries, people had been studying architecture in universities to learn how to draw building plans and now everyone can do it easily just using appropriate software. While developing the building plan, its graphic part, you can display the part of the floor or the entire floor of a building with an indication of the exact location of the drawn premise. Small-sized apartments does not restrict the advanced interior design opportunities. Here is a detailed and precise floor plan of a pretty small apartment. A furniture objects are added to show possible interior of this home. This plan can be used to help somebody with a floor layout and furniture arrangement. Having this floor plan in a pocket while shopping would be useful to check if there is enough rooms for a new furniture.How To Draw Building Plans
Picture: How To Draw Building Plans
Related Solution:

Data Modeling Tools →

There are many tools that are used within data modeling processes but to make the correct model it is always better to draw it graphically so it becomes more obvious whether it is good enough to use or not. Having the ConceptDraw DIAGRAM diagramming and drawing software may lead to creating the great looking ORM drawings, such as ORM diagrams, especially if you have the Object-Role Modeling (ORM) solution downloaded from the ConceptDraw STORE application — another product of CS Odessa that can be used by all the ConceptDraw DIAGRAM users.Data Modeling Tools *
Picture: Data Modeling Tools
Related Solution:
ConceptDraw
DIAGRAM 15