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:

Entity Relationship Diagram - ERD - Software for Design Crows Foot ER Diagrams →

There are many ways to describe a database structure. One of the most usual is to draw an entity relationship diagram (ERD) using a Crow’s Foot notation to represent database elements. If you don’t want to draw it on paper, you should use an appropriate software. An entity-relationship (ER) diagram is used to show the structure of a business database. ERD represents data as objects (entities) that are connected with standard relationships symbols which Illustrate an association between entities. ERD, there is a wide range of ERD notations used by data bases architects for reflecting the relationships between the data entities. According to the crow’s foot notation relationships are drawn as single labeled lines designating a certain kinds of relationship. Crow foot notation is a most frequently used ERD standard, because of improved readability of diagrams, with a more accurate use of space on the page.Entity Relationship Diagram - ERD - Software for Design  <br>Crows Foot ER Diagrams *
Picture: Entity Relationship Diagram - ERD - Software for Design Crows Foot ER Diagrams
Related Solution:

Martin ERD Diagram →

The vector stencils library Crow's Foot Notation from the solution Entity-Relationship Diagrams (ERD) contains specific symbols of the Crow's foot notation such as relationship symbols and entity symbols for ConceptDraw DIAGRAM diagramming and vector drawing software. The Entity-Relationship Diagrams (ERD) solution is contained in the Software Development area of ConceptDraw Solution Park.Martin ERD Diagram *
Picture: Martin ERD Diagram
Related Solution:

Drawing ER diagrams on a Mac →

Database model is a graphic representation need at the beginning of project development. You won't have any problems with drawing ER diagrams on a Mac anymore with ConceptDraw DIAGRAM application. Special libraries that contain all the symbols of both Chen's and Crow’s foot notation allow you to start database modeling within a few minutes. Creating entity-relationship diagrams on Mac is fun and effortless when you use a software designed for professional ERD drawing tailored to specific characteristics of Apple OS X. ConceptDraw DIAGRAM is a business diagramming software for those using OS X. The Entity-Relationship Diagrams solution for ConceptDraw has 2 libraries containing about 50 vector icons, depicting ERD symbols of the most popular Chen's and Crow’s Foot Notations. The other valuable component of the solution is a collection of ERDs samples and templates that can be opened on Macs and PCs.Drawing ER diagrams on a Mac *
Picture: Drawing ER diagrams on a Mac
Related Solution:

Best Multi-Platform Diagram Software →

ConceptDraw DIAGRAM is a powerful tool for drawing business communication ideas and concepts, simple visual presentation of numerical data in the Mac environment.Best Multi-Platform Diagram Software *
Picture: Best Multi-Platform Diagram Software
Related Solution:

Cross-Functional Flowchart →

There are many tools to manage a process or to illustrate an algorithm or a workflow. Flowcharting is one of those tools. However, it may be difficult to show complex processes that require multiple attributes or several people in a simple flowchart, so a cross-functional flowchart would be a solution for that situation. To create such flowchart, group processes and steps to labeled rows or columns, and divide those groups with horizontal or vertical parallel lines. It is worth mentioning that there are different types of cross-functional flowcharts, like opportunity or deployment flowchart. This diagram shows a cross-functional flowchart that was made for a trading process. It contains 14 processes, distributed through 5 lines depicting the participants who interact with the process. Also there are connectors that show the data flow of information between processes. The cross-functional flowchart displays a detailed model of the trading process, as well as all participants in the process and how they interact with each other. The lines in the flowchart indicates the position, department and role of the trading process participants.Cross-Functional Flowchart
Picture: Cross-Functional Flowchart
Related Solution:

How to Draw a Computer Network Diagrams →

Planning a computer network can be a challenge for a junior specialist. However, knowing how to draw a computer network diagrams isn’t a rocket science anymore. There are a lot of special software for creating such diagrams with predesigned templates and examples. The core for Network Fault Tolerance System presented here, is the equipment of Cisco. You can see here the certified Cisco equipment icons. Generally, ConceptDraw DIAGRAM libraries contain more than half of a thousand objects representing the standardized images of Cisco equipment. ConceptDraw solution for network diagramming is a great network diagramming tool for any level skills - from students to network guru.How to Draw a Computer Network Diagrams
Picture: How to Draw a Computer Network Diagrams
Related Solution:

Process Flow Maps →

What is a Process Flow Map? It is a chart which visually illustrates a business process and how its steps work together. Process Flow Maps help companies define problem areas, inefficient activities for the purpose of further increasing performance and profitability of businesses. ConceptDraw DIAGRAM diagramming and vector drawing software extended with Flowcharts solution from the "Diagrams" area of ConceptDraw Solution Park is efficient and productive software for fast and simple creating professional looking Process Flow Map.Process Flow Maps *
Picture: Process Flow Maps
Related Solution:
ConceptDraw
DIAGRAM 14