Products Solutions Samples Buy
✕
Made with
ConceptDraw
DIAGRAM 18
Download ConceptDraw Trial

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:
An organization structure reflects the composition and hierarchy of an organization, determines the distribution of authorities and responsibilities. ConceptDraw DIAGRAM diagramming and vector drawing software extended with 25 Typical Orgcharts solution from the Management area of ConceptDraw Solution Park allows effectively represent the organization structure of the company in the form of Organizational Chart.Organization Structure *
Picture: Organization Structure
Related Solution:
25 Typical Orgcharts
When you prepare professional-looking presentation, you need to use ConceptDraw MINDMAP software for the amazing result.Create Captivating Presentations Easily
Picture: Create Captivating Presentations Easily
Related Solution:
Presentation Exchange
Online collaboration tool for workgroups that extends Skype conference call possibilities. This professional solution makes meetings more powerful and discussions more lively. Great way to engage your audience.How To Collaborate via Skype *
Picture: How To Collaborate via Skype
Related Solution:
Remote Presentation for Skype
Interactive tool helps you find the appropriate response to social media mentions quickly.Organizing and Selecting Social Media Response Action *
Picture: Organizing and Selecting Social Media Response Action
Related Solution:
Social Media Response
Total quality management is the one known to be consisting of some organization-wide efforts put in order to install and to make some climate in which this organization can continuously improve its ability to deliver the high-quality products and services to its customers permanently.Total Quality Management Definition *
Picture: Total Quality Management Definition
Related Solution:
Total Quality Management TQM Diagrams
This method of problem analysis is widely used in IT, manufacture industries and chemical engineering. If you want to take a fresh look on your problem, you can draw a fishbone diagram with ConceptDraw DIAGRAM software, which supports both MAC OS and Windows. You can see and download fishbone diagram samples and templates in ConceptDraw Solution Park. This Fishbone (Ishikawa) diagram can be applied as template for performing the cause and effect analysis of a service industry problems. It can help to determine factors causing problems. Causes in this diagram are categorized according to the 4S’s principle that means Surroundings, Suppliers, Systems and Skills. Grouping causes allows to reveal main interactions between different events. This diagram was made using ConceptDraw Fishbone diagrams solution. It can help to reveal the causes effected a complicated issue. Of course it can be used together with other methods of approaching to the problem solving.Draw Fishbone Diagram on MAC Software *
Picture: Draw Fishbone Diagram on MAC Software
Related Solution:
Fishbone Diagrams
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:
HR Flowcharts
Communication is the main challenge and the key success factor for remote project management. Communicating visually via Skype you bring all team and customers onto the one page. Remote Presentation for Skype solution for ConceptDraw MINDMAP helps communicate with remote team and customers in visual manner on wide range of issues. Using this solution for regular status meetings allows you to push your team on tasks and keep task statuses up to date.Communication Tool for Remote Project Management *
Picture: Communication Tool for Remote Project Management
Related Solution:
Remote Presentation for Skype
ConceptDraw
DIAGRAM 18
Buy it Now