Made with
ConceptDraw
DIAGRAM 14

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:

Good Flow Chart app for Mac →

The ConceptDraw DIAGRAM is a good flow chart app for Mac. Numerous vector stencils, samples and templates created by designers allows you to draw any type of flowchart.Good Flow Chart app for Mac *
Picture: Good Flow Chart app for Mac
Related Solution:

Entity Relationship Diagram Software for Mac →

ER-modeling nowadays is a very popular approach for database design. If you are tired of looking for a good entity relationship diagram Software for Mac, then your search is almost over. ConceptDraw DIAGRAM is a great tool for creating diagrams of any complexity with tons of editable samples and templates. This diagram represents the vector library of the Chen’s and Crow’s Foot notation icons for drawing ERD (entity-relationships diagram). ConceptDraw Entity Relationship Diagram solution delivers the ability to visualize databases structure on both Mac and PC. The "bricks" entity-relationships models are the entity, and the relation. An entity is represented by a rectangle comprising the entity name. It means an object, information about which should be available and stored. A relation is intended to show a relations between two entities. There are several types of relations between entities. To show there are a number of different symbols for the types of relationships.Entity Relationship Diagram Software for Mac *
Picture: Entity Relationship Diagram Software for Mac
Related Solution:

Detail Specifications Exchanging Mind Maps with Evernote →

ConceptDraw Note Exchange Solution permits users to develop and organize notes and tasks in ConceptDraw MINDMAP. Your work can be accessed later, just with one click, regardless of preferred platform.Detail Specifications Exchanging Mind Maps with Evernote *
Picture: Detail Specifications Exchanging Mind Maps with Evernote
Related Solution:

Business Process Workflow Diagram →

Business Process Workflow Diagram is a professional visual tool that is widely applied for business development, business analysis, business process optimization and documenting business processes. Business Process Workflow Diagram lets depict in details the steps of business processes and flow of tasks between them, the execution of business processes, transfer of data and documents. The workflows on the Business Process Workflow Diagram are represented using the set of common symbols which let easy illustrate business processes and process flows, depict the start, all major steps and end of the process, what data are used by the process, how the data flow through the business areas within scope of our project, how the tasks are executed and by who, and how workers interact with each other.Business Process Workflow Diagram *
Picture: Business Process Workflow Diagram
Related Solution:

Swim Lane Diagrams →

Job duties in small companies are usually spread randomly among workers, causing lots of problems and misunderstanding. One of the ways to restore order in business processing is to create a cross-functional flowchart with swim lanes that would represent every step in production system. Another advantage of using swim lanes flowchart is that it represents not only processes, but people responsible for them. Swim lane diagram is a kind of a process flow diagram. Its special feature is that it joins the features of process flow diagrams with organizational charts. Thus, a swim lane diagram display a participant of the business process in a conjunction with general flow of the business system. A swim lane diagram is looks similar to a swimming pool's lanes. Lanes can be horizontal and vertical. The lanes are pointed out relatively to resource name, which is assigned on implementation of the given part of the business process. ConceptDraw Business Process Mapping solution delivers the ability to design develop swim lanes flowcharts using the vector graphic objects of Swim Lanes library.Swim Lane Diagrams *
Picture: Swim Lane Diagrams
Related Solution:

Onion Diagram Maker →

The onion diagram is a type of diagram which shows the dependencies among parts of an organization or process. The items are displayed at the concentric circles, where the items at the bigger rings depend on the items at the smaller rings. ConceptDraw DIAGRAM diagramming and vector drawing software extended with Stakeholder Onion Diagrams Solution from the Management Area of ConceptDraw Solution Park is a professional Onion Diagram Maker.Onion Diagram Maker *
Picture: Onion Diagram Maker
Related Solution:

Ice Hockey Rink Dimensions →

Meeting ice hockey rules one should learn ice hockey rink terms, lines, zones etc. ConceptDraw DIAGRAM is an advanced drawing software that allows you produce ice hockey rink depiction of any complexity, from simple sketch drawing to detailed one as on example below.Ice Hockey Rink Dimensions *
Picture: Ice Hockey Rink Dimensions
Related Solution:

Business process Flow Chart — Event-Driven Process chain (EPC) diagrams →

Event-Driven Process chain Diagrams for improvement throughout an organisation. Best software for Process Flow Diagram. The Event-driven Process Chain (EPC) Diagrams allows managers to plan processes and resources.Business process Flow Chart — <br>Event-Driven Process chain (EPC) diagrams *
Picture: Business process Flow Chart — Event-Driven Process chain (EPC) diagrams
Related Solution:
ConceptDraw
DIAGRAM 14