Made with
ConceptDraw
DIAGRAM 14

Anyone Have an ERD Symbols Quick Reference?

ERD drawing becomes easier with predesigned entity relationship symbols, work flow shapes, entity relationship stencils. We are glad to offer you all variety of ERD symbols you may need for ERDs design, they are packed into libraries and templates from Entity-Relationship Diagram (ERD) Solution for ConceptDraw DIAGRAM diagramming and vector drawing software.

But anyone have an ERD symbols quick reference? Detailed reference information for them is represented at the tables below on this page.

Anyone Have an ERD Symbols Quick Reference? *

Sample 1. Anyone Have an ERD Symbols Quick Reference?

There are two notations used for ERDs: Chen and Crow's Foot. Variety of symbols offered by two libraries of Entity-Relationship Diagram (ERD) Solution covers both these notations.


Crow’s Foot notation ERD symbols

Symbol Meaning
Relationships (Cardinality and Modality)
ERD symbol -  Entity relationship Zero or More
ERD symbol -  Entity relationship One or More
ERD symbol -  Entity relationship One and only One
ERD symbol -  Entity relationship Zero or One
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 one 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 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


Chen's notation ERD symbols

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.

Collection of samples and examples included to Entity-Relationship Diagram (ERD) solution and represented at ConceptDraw STORE is an excellent illustration of the ease of application of ready-to-use objects for designing Entity-Relationship diagrams and models.

ERD Example

Example 2. ERD Example

This sample was created in ConceptDraw DIAGRAM using the vector objects from the ERD Chen's Notation library of Entity-Relationship Diagram (ERD) Solution and illustrates the Entity Relationship Diagram. An experienced user spent 15 minutes creating this sample.

Use the Entity-Relationship Diagram (ERD) Solution for ConceptDraw DIAGRAM software to create your own professional looking ER Diagrams quick, easy and effective.

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:

ER Diagram Programs for Mac →

ConceptDraw DIAGRAM compatible Mac OS X software extended with powerful Entity-Relationship Diagram (ERD) Solution from the Software Development Area for ConceptDraw Solution Park is one of the famous ER Diagram Programs for Mac. It gives the perfect ability to draw ER diagrams for visually describing databases with Chen's and Crow's Foot notation icons.ER Diagram Programs for Mac *
Picture: ER Diagram Programs for Mac
Related Solution:

Electrical Diagram Software →

Beginning from the 19th century, people tried to tame electricity. Nowadays, electrical engineering covers a wide range of applications starting from providing illumination in our homes to developing space technologies. Considering the fact that every project needs documentation, engineers use electrical diagram software to develop these projects. Standard electrical symbols of electrical components are recognizable all around the world. This illustration represents the 26 libraries that are supplied by the ConceptDraw Electrical Engineering solution. The Electric Engineering libraries contains about a thousand objects enabling you to draw various charts depicting electrical connections and circuits, along with schemes of different equipment and devices. The electric engineering libraries delivered with ConceptDraw solution meet the standards adopted in the image to electrical circuits. So they can be used by professionals along with amateurs in electrical engineering.Electrical Diagram Software *
Picture: Electrical Diagram Software
Related Solution:

Reflective Ceiling Plan →

You need create Reflective Ceiling Plan? What can be easier with ConceptDraw DIAGRAM diagramming and vector drawing software extended with Reflected Ceiling Plans Solution from the Building Plans Area.Reflective Ceiling Plan *
Picture: Reflective Ceiling Plan
Related Solution:

Cisco Security. Cisco icons, shapes, stencils and symbols →

The ConceptDraw vector stencils library "Cisco Security" contains 16 symbols of security devices and equipment for drawing the computer network diagrams using the ConceptDraw DIAGRAM diagramming and vector drawing software.Cisco Security. <br>Cisco icons, shapes, stencils and symbols *
Picture: Cisco Security. Cisco icons, shapes, stencils and symbols
Related Solution:

ER Diagram Tool →

Creating of Entity-Relationship Diagrams (ERDs) is a complex process that requires convenient, automated tools. ConceptDraw DIAGRAM diagramming and vector drawing software offers a powerful ER Diagram Tool - the Entity-Relationship Diagram (ERD) Solution from the Software Development Area.ER Diagram Tool *
Picture: ER Diagram Tool
Related Solution:

Electrical Symbols — Rotating Equipment →

Electrical rotating machines, such as motors and generators, are vital assets for any power plant or large industrial company. An electric motor is an electrical machine that converts electrical energy into mechanical energy. The reverse of this would be the conversion of mechanical energy into electrical energy and is done by an electric generator. In normal motoring mode, most electric motors operate through the interaction between an electric motor's magnetic field and winding currents to generate force within the motor. In certain applications, such as in the transportation industry with traction motors, electric motors can operate in both motoring and generating or braking modes to also produce electrical energy from mechanical energy. 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 — Rotating Equipment *
Picture: Electrical Symbols — Rotating Equipment
Related Solution:

Electrical Symbols — Lamps, Acoustics, Readouts →

Wiring and circuit diagrams use special symbols recognized by everyone who uses the drawings. The symbols on the drawings show how components like resistors, capacitors, inductors, switches, lamps, acoustic devices, measuring devices and other electrical and electronic components are connected together. 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 — Lamps, Acoustics, Readouts *
Picture: Electrical Symbols — Lamps, Acoustics, Readouts
Related Solution:

Interior Design. Office Layout Plan Design Element →

Sometimes, when it is difficult to create a functional space plan or to rearrange existing one, the art of interior design comes in. It doesn't matter, if you need a cozy bedroom or an office layout plan, you should use appropriate tools to make your design great. While making a floor plan of a new office it could be useful to apply some design elements such as furniture and office equipment. This diagram presents an office furniture objects that can be used for office interior design planning, or making office furniture and equipment layouts. This vector stencils library is supplied with ConceptDraw Office Layout Plans solution. It contains more then 30 vector objects of office interior for making office floor plans including an office space layout plans and furniture arrangement.Office Layout Plan Design Element
Picture: Interior Design. Office Layout Plan Design Element
Related Solution:

E-R Diagrams →

Complexity of databases increases day by day, due to this the Entity relationship models and E-R diagrams become more and more popular, and now are an important part of database design. E-R diagrams created at ConceptDraw DIAGRAM allow visually and graphically represent structure and design of databases.E-R Diagrams *
Picture: E-R Diagrams
Related Solution:

What Is a Circle Spoke Diagram →

What Is a Circle Spoke Diagram? It is a diagram which has a central item surrounded by other items in a circle. The Circle Spoke Diagrams are often used to show the features or components of the central item in marketing and management documents and presentations. ConceptDraw DIAGRAM extended with Business Diagrams Solution from the Management Area is the best software for creating Circle-Spoke Diagrams.What Is a Circle Spoke Diagram *
Picture: What Is a Circle Spoke Diagram
Related Solution:
ConceptDraw
DIAGRAM 14