Made with
ConceptDraw
DIAGRAM 15

Entity-Relationship Diagram (ERD)
with ConceptDraw DIAGRAM

Entity-Relationship Diagram (ERD) serves for detailed description of structures and databases. An ERD represents a diagram made up mainly of rectangular blocks (for entities, or data) linked with relationships. The links between the blocks describe relations between these entities. There are three types of relationships:

  • one-to-one,
  • one-to-many,
  • many-to-many.

For example, "driver drives a car". Here, the entity "driver" relates to the entity "car" by means of a one-to-one relationship "drives". One driver drives one car.

ER Diagram: one-to-one

An example of a one-to-many relationship is a sergeant commanding a team of soldiers. Here the entity "sergeant" relates to a number of entities "soldier" by means of a one-to-many relationship.

ER Diagram: one-to-many

Since the many-to-many relationship does not adequately represent the nature of interaction between entities, it is rarely used in diagrams, or is used in diagrams with little detail.

Entities and relationships can both have attributes. Example: a car from the first example has number; the "drives" relation may have quality attributes describing the quality of driving, or time attributes, saying when exactly the driver was driving the car.

ER Diagram: attributes

ERDs are mainly used to describe database structures, though they might be used as diagrams describing a structure of a company, organization, or some business processes.

ConceptDraw DIAGRAM extended with Entity-Relationship Diagram (ERD) solution from the Software Development Area allows you to draw very complex and detailed ERD. It has a number of libraries with objects used in diagrams, which are included in relevant templates and samples available from ConceptDraw STORE.

Entity-Relationship Diagram (ERD) Solution in ConceptDraw STORE

Example 1. Entity-Relationship Diagram (ERD) Solution in ConceptDraw STORE

In actual practice, ERDs employing the method of P.P. Chen are used most. Choose the Chen ERD template in ConceptDraw STORE. A new document will open along with the library with objects necessary to create a diagram. Drag the vector objects representing entities and relationships, and then just connect them between each other in the required order. Use respective library objects to indicate the types of relationships and their attributes.

Entity-Relationship Diagram (ERD) <br>with ConceptDraw DIAGRAM  *

Example 2. ERD WordPressFile Reference. Chen's Notation

One of advantages of ERD diagram drawn in ConceptDraw DIAGRAM is that when you move entities on the diagram, they stay connected and you don't need to move relationships too.

Apart from building a diagram manually, ConceptDraw has a built-in tool for drawing an ERD automatically, from a database.

Entity Relationship Model Diagram. Crow's Foot Notation

Example 3. Entity Relationship Model Diagram. Crow's Foot Notation

The samples you see on this page were created in ConceptDraw DIAGRAM using the Entity-Relationship Diagram (ERD) Solution and demonstrate some of solution's capabilities and the results you can achieve.

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:

Interior Design. Storage and Distribution — Design Elements →

Talking about interior design, we usually mean apartments, houses or establishments. But there’s much more to this, for instance, interiors in warehouses, storage and distribution departments and machine shops also require designing. You can find all the necessary design elements such as cranes and forklifts in Plant Layout Plans solution ConceptDraw Solution Park. This picture represents content of the Storage and Distribution library, providing the collection of vector images designed to plan layouts of industrial storage facilities (warehouses). Warehouse is a premises and equipment intended for the reception, distribution and storage of products manufactured at the plant, as well as to preparation the product for shipment to the consumer. This vector images library is supplied with ConceptDraw Plant Layout Plans solution. it will help to industrial architects and planners to design plans for industrial storage and shipping facilities.Interior Design
Picture: Interior Design. Storage and Distribution — Design Elements
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:

UML Deployment Diagram →

UML Deployment Diagram depicts the physical deployment of artifacts on nodes (nodes are the existing hardware components, artifacts are the software components running on each node); and how the different pieces are connected. Use ConceptDraw DIAGRAM with UML deployment diagram templates, samples and stencil library from Rapid UML solution to model the physical deployment of artifacts on nodes of your software system.UML Deployment Diagram *
Picture: UML Deployment Diagram
Related Solution:

UML Class Diagram Generalization ExampleUML Diagrams →

This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the UML Class Diagram library of the Rapid UML Solution from the Software Development area of ConceptDraw Solution Park. This sample describes the use of the classes, the generalization associations between them, the multiplicity of associations and constraints. Provided UML diagram is one of the examples set that are part of Rapid UML solution.UML Class Diagram Generalization Example<br>UML Diagrams *
Picture: UML Class Diagram Generalization ExampleUML Diagrams
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:

Functional Block Diagram →

You need design the Functional Block Diagram and dream to find the useful tools to draw it easier, quickly and effectively? ConceptDraw DIAGRAM offers the Block Diagrams Solution from the "Diagrams" Area which will help you!Functional Block Diagram *
Picture: Functional Block Diagram
Related Solution:

Multi Layer Venn Diagram. Venn Diagram Example →

To visualize the relationships between subsets of the universal set you can use Venn diagrams. To construct one, you should divide the plane into a number of cells using n figures. Each figure in the chart represents a single set of, and n is the number of represented sets. Splitting is done in a way that there is one and only one cell for any set of these figures, the points of which belong to all the figures from the set and do not belong to others. The plane on which the figures are represented, is the universal set U. Thus, the point which does not belong to any of the figures, belongs only to U.Multi Layer Venn Diagram. <br>Venn Diagram Example *
Picture: Multi Layer Venn Diagram. Venn Diagram Example
Related Solution:

Symboles Organigramme →

Les organigrammes sont parfaits pour représenter visuellement des processus operationnels. Par exemple, si vous avez besoin d'afficher le flux d'un processus d'ordre personnalisé par l'entremise de divers opérateurs au sein de votre organisation, vous pouvez utiliser un organigramme. Voir aussi d'autres symboles organigramme: Symboles ordinogramme standard, symboles du flux de travail, Vérification Les symboles du schéma fonctionnel, sOrganigramme comptables des symboles, Organigramme de vente des symboles, Symboles pour organigramme des RH, Carte des symboles de processus, Diagramme de processus opérationnels, Symboles utilisés dans le schéma IDEF0.Symboles Organigramme
Picture: Symboles Organigramme
Related Solution:
ConceptDraw
DIAGRAM 15