Made with
ConceptDraw
DIAGRAM 14

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:

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:

SDL Flowchart Symbols →

Drawing the diagrams we try to find in help the powerful software and now we have the ConceptDraw DIAGRAM. The ability easily create the SDL diagrams is made possible thanks to unique Specification and Description Language (SDL) Solution from the Industrial Engineering Area of ConceptDraw Solution Park. This solution extends ConceptDraw DIAGRAM 2 libraries - SDL Connectors and SDL Diagrams that contain 70 predesigned SDL flowchart symbols.SDL Flowchart Symbols *
Picture: SDL Flowchart Symbols
Related Solution:

ConceptDraw DIAGRAM Comparison with Omnigraffle Professional and MS Visio →

ConceptDraw DIAGRAM Comparison with Omnigraffle Professional and MS Visio. All source ConceptDraw 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 graphics formats.ConceptDraw DIAGRAM Presentation
Picture: ConceptDraw DIAGRAM Comparison with Omnigraffle Professional and MS Visio
Related Solution:

UML Deployment Diagram Example - ATM SystemUML diagrams →

This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the UML Deployment Diagram library of the Rapid UML Solution from the Software Development area of ConceptDraw Solution Park. This sample shows the work of the ATM (Automated Teller Machine) banking system that is used for service and performing of the banking transactions using ATMs. System engineers can use comprehensive UML diagrams solution.UML Deployment Diagram Example - ATM System<br>UML diagrams *
Picture: UML Deployment Diagram Example - ATM SystemUML diagrams
Related Solution:

Local area network (LAN). Computer and Network Examples →

Computer networks nowadays are spread all across the world. The large number of parameters, such as geographic scale or communication protocols, can divide networks. One of the most common types of networks is called local area network (LAN). It convenient to represent network examples by means of diagrams. This local area network (LAN) diagram provides an easy way to see the way the devices in a local network are interacted. The diagram uses a library containing specific symbols to represent network equipment , media and the end-user devices such as computers (PC, mac, laptop) , network printer, hubs, server and finally a modem. There are two types of network topologies: physical and logical. The current diagram represents precisely a physical type of LAN topology because it refers to the physical layout of a local network equipment.Local area network (LAN) diagram
Picture: Local area network (LAN). Computer and Network Examples
Related Solution:

UML Collaboration Diagram (UML2.0) →

UML Collaboration Diagram depicts the interactions between objects or parts in terms of sequenced messages and describes both the static structure and dynamic behavior of a system. Rapid UML solution provides templates, examples and libraries of stencils for quick and easy drawing all the types of system and software engineering diagrams according to UML 2.4 and 1.2 notations.UML Collaboration Diagram (UML2.0) *
Picture: UML Collaboration Diagram (UML2.0)
Related Solution:

UML Use Case Diagram Example. Services UML Diagram. ATM system →

Services UML Diagram. ATM system. This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the UML Use Case Diagram library of the Rapid UML Solution from the Software Development area of ConceptDraw Solution Park. This sample shows the scheme of the servicing using the ATMs (Automated Teller Machines) and is used at the working of ATM banking systems, at the performing of the banking transactions.UML Use Case Diagram Example. <br>Services UML Diagram.  ATM system *
Picture: UML Use Case Diagram Example. Services UML Diagram. ATM system
Related Solution:
ConceptDraw
DIAGRAM 14