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.
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) | ||
 |
Zero or More | |
 |
One or More | |
 |
One and only One | |
 |
Zero or One | |
| Many - to - One | ||
 |
a one through many notation on one side of a relationship and a one and only one on the other | |
 |
a zero through many notation on one side of a relationship and a one and only one on the other | |
 |
a one through many notation on one side of a relationship and a zero or one notation on the other | |
 |
a zero through many notation on one side of a relationship and a zero or one notation on the other | |
| Many - to - Many | ||
 |
a zero through many on both sides of a relationship | |
 |
a one through many on both sides of a relationship | |
 |
a zero through many on one side and a one through many on the other | |
 |
a one and only one notation on one side of a relationship and a zero or one on the other | |
 |
a one and only one notation on both sides | |
Chen's notation ERD symbols
| Symbol | Shape Name | Symbol Description |
| Entities | ||
 |
Entity | An entity is represented by a rectangle which contains the entity’s name. |
 |
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. |
 |
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 | ||
 |
Attribute | In the Chen notation, each attribute is represented by an oval containing atributte’s name |
 |
Key attribute | An attribute that uniquely identifies a particular entity. The name of a key attribute is underscored. |
 |
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. |
 |
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 | ||
 |
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 |
 |
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.
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:
ConceptDraw DIAGRAM is a very easy-to-use and intuitive database design tool which can save you hundreds of work hours. See database diagram samples created with ConceptDraw DIAGRAM database modeling database diagram software.
Picture: ConceptDraw DIAGRAM Database Modeling Software
Diagrams are a very important part of modern life. With the help of flow diagram software, a lot of companies can promote their ideas at the market. Its usefulness is totally doubtless.
This is a flow chart of the invoice payment flow. This flowchart details decrypts all stages of the process of obtaining and paying bills. It is a description of the universal process - such steps performs accounting departments of almost any organization. Since every business no matter what it does is a consumer of some goods or services. The given flow chart was made using ConceptDraw DIAGRAM software and the Diagrams solution for making flowcharts of any kind.
Picture: Flow Diagram Software
Related Solution:
A Telecommunications network is a network of nodes, links, trunks and telephone switches that are connected, operated by telephone companies and realize telephone, audio, visual and data communications among the users. The telecommunications network can also include Internet, microwave, wireless equipment.
This example was created in ConceptDraw DIAGRAM using the Computer and Networks Area of ConceptDraw Solution Park and shows the Telecommunications network.
Picture: Telecommunication networks. Computer and Network Examples
Related Solution:
It's no secret that there is a list of skills that every average system administrator should have. And it's important to be able to manage domains via active directory technologies. The best way to keep all the details in mind is to draw a diagram representing users, groups and domains.
This diagram represents an Active Directory Services (Active Directory Domain Services). It can be helpful for system and network administrators to organize a network physical and logical elements (domains, data bases, servers, network equipment, end-user computers etc.) into a secure and logical structure. The logical structure of Active Directory is a hierarchical organization of all network components. The data that is stored in Active Directory comes from some diverse sources. The Active Directory diagram created using ConceptDraw Active Directory Diagram solution. It shows allocating group policies and functions assigned to end users. It helps to plan, manage and maintain the certain user access scenario.
Picture: Active Directory Diagram
Related Solution:
Tools to deliver presentations remotely 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.
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.
Picture: SIPOC Diagram
Related Solution:
Business People Clipart - Business and Finance solution from Illustration area of ConceptDraw Solution Park.
Use it to quick draw illustrations, diagrams and infographics for your business documents, presentations and websites.
The vector stencils library Business People Clipart includes 12 images.
Picture: Business People Clipart
Related Solution:
It’s not easy to plan all the details of your landscape at once. Therefore, you can use a bubble diagram to create a draft of the future project. You can develop any bubble diagrams and use them in your landscape design project with ConceptDraw DIAGRAM and it’s predesigned templates.
This bubble diagram can be applied while initiating the development of garden and landscape design. The bubble diagrams used for this purpose are different from the classic bubble diagrams. Being used in landscape and garden design, they obtain the quite another understanding. Bubbles in this diagram visualize some captured areas, which define the general spaces of a future garden: lawn, flower garden, pool, built-up area, lighting, etc. The bubble diagram represents the landscape project without any special expenses on its creation. It is better to make such simple sketch before you drill down into detailed project and cost estimates.
Picture: Bubble diagrams in Landscape Design with ConceptDraw DIAGRAM
Block diagrams solution extends ConceptDraw DIAGRAM software with templates, samples and libraries of vector stencils for creating the block diagram.
Create block diagrams, electrical circuit diagrams, schematics, and more in minutes with ConceptDraw DIAGRAM.
Picture: Create Block Diagram
ConceptDraw
DIAGRAM 18