ER Diagram Symbols and Their Usage

Extensive pre-drawn ER diagram symbols are provided with vector format, including entity, user, relationship, attribute, aggregation, line connector, etc. Customizable and with high quality, these symbols will help you make professional ER diagrams in a few minutes.

When you need to create an ER diagram to document a database, it will be much easier using pre-made symbols and icons. This page gathers a large quantity of useful symbols that often used in ER diagrams, Chen ERD, Express-G diagram, ORM diagram, Martin ERD and database model diagram.

Entity Relationship Symbols

Below are pre-drawn entity relationship symbols in the software, including entity, view, parent to category, category to child, dynamic connector, line connector, strong entity, weak entity, strong relationship, weak relationship, attribute, derived attribute, constraint and participation, etc.

Database Model Diagram Symbols

Entity

Entity in a database could be a single person, place, or thing about which data can be stored.

Relationship

Relationship provides useful information that could not be discerned with just the entity types. Relationships are meaningful associations between or among entities like assigning, associating, or tracking.

Category

Categories are tables that are subtypes of a parent table. In relation to a database , an entity is a single person, place, or thing about which data can be stored.

Strong entity

Strong entity is one that exists on its own, independent of other entities.

Weak entity

Weak entity is one whose existence depends on another entity. A weak entity cannot be uniquely identified by its attributes alone.

Strong relationship

Strong relationships are connections that exist between a strong entity type and its owner.

Weak relationship

Weak relationships are connections that exist between a weak entity type and its owner.

Attribute

Attribute is a piece of information which determines the properties of a field or tag in a database or a string of characters in a display.

When you use the category symbols, you may notice that there is a floating button on the shape. Click the floating button, you may set the property of the category.

set the property of the category

Some people may be confused how to use connector to connect entity symbols. Actually, it is easy, you can move the connector towards the shape, then you can find that the entity shape has lots of green marks. when the red mark appear, it means the two has connected.

Connect the entity

Object Relationship Symbols

The following picture is the object relationship symbols including entity, relationship, view, parent to category, category to child, table inheritance, type, type inheritance and dynamic connector.

Database Model Diagram Symbols 2

Type and type inheritance

Type of a relationship is created depends upon how related objects are defined.

Type inheritance is an additional property offered by hierarchy within structured complex data.

Chen ERD Symbols

Chen ERD Symbols

Entity

Entity in a database could be a single person, place, or thing about which data can be stored.

Attribute

Attribute is a piece of information which determines the properties of a field or tag in a database or a string of characters in a display.

Aggregation

Aggregation is a special type of association in which objects are assembled or configured together to create a more complex object. An aggregation describes a group of objects and how you interact with them.

One-to-many

One to many (N) is by far the most common relationship type.

One-to-many

Many to many (M) lets you relate each row in one table to many rows in another table, and vice versa. Many-to-many relationships often hide meaning.

Relationship Symbols

Chen ERD Symbols 2

Composition

Composition relationship, which was named composition association relationship in UML 1.4, represents whole-part relationships and is a form of aggregation. A composition relationship specifies that the lifetime of the part classifier is dependent on the lifetime of the whole classifier.

Inheritance

Inheritance relationship helps to communicate structure and inheritance of an object model. Inheritance relationships organize classes into generalization-specialization (superclass-subclass) hierarchies; they provide a basic re-use mechanism for sharing attributes and operations.

Dependency

Dependency relationship is a relationship in which one element, the client, uses or depends on another element, the supplier.

Association

Association is a relationship between two classifiers, such as classes or use cases, that describes the reasons for the relationship and the rules that govern the relationship.

Need fresh looking Chen ERD symbols for your design? These Chen ERD symbols are a cinch to pop in. And their crisp, fine detail will make spectacular, easy-to-understand diagrams and presentations to your customers.

Express-G Symbols

Express-G Symbols

Entity

Entity in a database could be a single person, place, or thing about which data can be stored.

Defined Type

Defined type is the most important datatype in Express-G.

Select Type

Select type defines a choice or an alternative between different options. Most commonly used are selects between different entity types.

Tree Structure

Tree structure is a structure in which there are successive branchings or subdivisions.

Schema

Schema is a way to logically group objects such as tables, views, stored procedures, etc.

Page Reference

Page reference is a reference to an instantiation of a page.

Martin ERD Symbols

Martin ERD Symbols

Data Entity

Data entity is an object, event, or phenomenon about which data is stored in a database.

Data Item

Data item is a unit of data contained in a record, describing a particular attribute, and it requires one or several bits, bytes, or words to represent an entity.

Connection

Connection is the setting up of resources so that a particular object such as a database or file can be read or written to.

Event

Events with different colors represent different events.

ORM Diagram Symbols

ORM Diagram Symbols

Entity ORM

Entity in a database could be a single person, place, or thing about which data can be stored.

Unary ORM

Unary means consisting of or involving a single component or element.

Ternary ORM

Ternary means "composed of three items".

Index Annotation

Index annotation defines an index for the class as a whole (typically a composite index).

Links:

ER Diagram Symbol Legend

Database Model Diagram Symbols

Express-G Diagram Symbols

Martin ERD Symbols

ORM Diagram Symbols

Share the page:

Get Started! You Will Love This Easy-To-Use Diagram Software.

Edraw Max is perfect not only for professional-looking flowcharts, organizational charts, mind maps, but also network diagrams, floor plans, workflows, fashion designs, UML diagrams, electrical diagrams, science illustration, charts and graphs... and that is just the beginning!

Top