Made with
ConceptDraw
DIAGRAM 17

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:
Tools to deliver presentations remotely via SkypeHow To Share Presentation via Skype *
Picture: How To Share Presentation via Skype
Related Solution:
ConceptDraw DIAGRAM diagramming and vector drawing software extended with Cisco Network Diagrams Solution from the Computer and Networks Area is the best for creating Cisco Network Diagrams thanks to numerous predesigned Cisco network icons.Cisco Network Icons *
Picture: Cisco Network Icons
Related Solution:
SIPOC is a tool that summarizes the inputs and outputs of one or more processes in table form. You need to draw professional looking SIPOC Diagram quick and easy? Pay please your attention on ConceptDraw DIAGRAM diagramming and vector drawing software. Extended with Business Process Mapping Solution from the Business Processes Area of ConceptDraw Solution Park, it suits ideal for this.SIPOC Diagram *
Picture: SIPOC Diagram
Related Solution:
UML Deployment diagram describes the hardware used in system implementations and the execution environments and artifacts deployed on the hardware. ConceptDraw has 393 vector stencils in the 13 libraries that helps you to start using software for designing your own UML Diagrams. You can use the appropriate stencils of UML notation from UML Deployment library.UML Deployment Diagram. Design Elements *
Picture: UML Deployment Diagram. Design Elements
Related Solution:
Two types of diagrams are used in UML: Structure Diagrams and Behavior Diagrams. Behavior Diagrams represent the processes proceeding in a modeled environment. Structure Diagrams represent the elements that compose the system.UML Diagram Types List *
Picture: UML Diagram Types List
Related Solution:
ConceptDraw DIAGRAM is a software for simplу depicting the business processes based on BPMN 2.0. Business Process Diagrams Cross-Functional-Flowcharts, Workflows, Process Charts, IDEF0 and IDEF2, Timeline, Calendars, Gantt Charts, Business Process Modeling, Audit and Opportunity Flowcharts and Mind Maps (presentations, meeting agendas).Business Process Modeling Notation *
Picture: Business Process Modeling Notation
Related Solution:
Engineering students usually have huge amount of homework. Learning how to develop a technical drawing is one of the necessary skills. Luckily, at the present time, there’s no need to draw it on paper, because there a lot of software tools for it. This drawing represents the Bearing symbols library, that is the part of the ConceptDraw Mechanical Engineering solution. Bearings are the important components of any movable mechanism. The function of bearing is to align, guide, and support the moving parts in any mechanical construction. Usually they are located between moving and stationary parts, it works as a connection point between them. Using Mechanical Engineering solution and ConceptDraw DIAGRAM one can effortlessly draw engineering diagrams of any complexity.Technical Drawing Software *
Picture: Technical Drawing Software
Related Solution:
Human resource management (HRM) is a professional discipline which oversees and manages an organization's human resources, and aspires maximize employee performance for an employer's strategic objectives. The HR Management Software is an incredibly powerful tool for those who need to analyze or present human resource process flows in a visually effective manner.HR Management Software *
Picture: HR Management Software
Related Solution:
The ConceptDraw DIAGRAM is a professional software for quick creating great looking flowcharts. The vector stencils from object libraries allows you to use RapidDraw technology. By the clicking on direction arrows one can add new object to flowcharts. This technology gives to users the ability to fast creating visualization for the structural data. Learn the basics of flowcharting and see how to build create a flowchart using ConceptDraw automatic drawing tools.How to Build a Flowchart *
Picture: How to Build a Flowchart
Related Solution:
ConceptDraw
DIAGRAM 17