Made with
ConceptDraw
DIAGRAM 14

ConceptDraw DIAGRAM ER Diagram Tool

The main tool of domain modeling at the stage of conceptual design is the Entity-relationship model, also called ER-model. Modeling domain data structures is based on the usage of graphical tools — ER-diagrams (Entity-Relationship diagrams). Simply put, it is a visual representation of relationships between entities.

The core concepts of ER Diagram are entity, attribute and relationship. An entity is an object of the real world that can exist independently. An entity has instances which differ in attribute values and allow unambiguous identification. An attribute is a property of the essence. For example, the entity named Book is characterized by attributes such as author, title, price, publishing house, edition, number of pages. Specific books are instances of the book entity. These instances vary in the values of these attributes and are uniquely identified by the attribute "name". Attribute that uniquely identifies the instance of the entity is called the primary key. It may also be a composite key, which is a combination of several attributes.

A very important feature of the entity-relationship model is that it can be represented as a graphical diagram. This greatly facilitates the subject area analysis. There are several notations used to represent entity-relationship elements, like Crow’s foot notation, or Chen notation, and each has its pros and cons.

ConceptDraw DIAGRAM ER Diagram Tool *

Example 1. ER Diagram

The entity on the ER-diagram is represented in the form of a rectangle, which indicates its name. Relationship is the interaction between entities, which is characterized by degree which counts how many entities are involved in the relation. The relationship between the two entities is called binary, and the relationship between more than two entities is ternary. Attributes, entities and relationships are connected by straight lines. Relation is shown in the form of a diamond. When creating a diagram, you can follow a few obvious steps. First, you need to identify entities and relationships among them. The following step is to identify the semantic information in the sets of relations (for example, whether a certain set of connections is a 1:n relation). Then you should define relationships cardinalities and determine attributes and their values sets. The final step is to organize the data in the form of entity-relationship connections.

As an example, let’s imagine a database designed for storing information about some bank activities. The bank has affiliates, which are controlled by managers. Customers of the bank have different types of accounts — current, term, demand, deposit, card account. Branches handle these accounts. The described domain will be called Bank. Let’s determine four entities: the Affiliate, the Manager, the Account, the Customer and some relations among them: the Manager controls the Affiliate; the Affiliate handles the Account; the Customer has the Account.

ConceptDraw PRO v5 with Entity-Relationship Diagram (ERD) solution serving as ERD software allows you to visually create Entity Relationship diagrams (ERDs) for various database systems, it supports ODBC-compatible databases (Oracle, MS SQL, InterBase, MySQL, MS Access, Firebird and others). The built-in scripting language allows to connect to ODBC-compatible databases and automatically generate the structure of a database (reverse engineering of the database structure).

ConceptDraw DIAGRAM  ER Diagram Tool

Example 2. ConceptDraw ER Diagram Tool

ConceptDraw ER Diagram Tool works across any platform, meaning you never have to worry about compatibility again. ConceptDraw PRO v5 allows you to make Entity-Relationship Diagram (ERD) on PC or macOS operating systems.

When creating an ERD our ERD software considers individual database options such as referential integrity, constraints, domains, triggers, stored procedures, functions, packages, views, sequences, synonyms etc.

ConceptDraw PRO v5 is a very easy-to-use and intuitive database design tool and ER Diagram tool which can save you hundreds hours of work. Entity-Relationship Diagram (ERD) solution contains 2 libraries with 45 predesigned vector graphic elements, collection of professional ERD samples, examples and templates.

ConceptDraw PRO v5 is excellent choice of database designers for modeling, reverse and forward engineering of relational databases. It is not only an excellent tool for ER Diagram, but also the one that allows you to reverse engineer already existing database structures, create detailed HTML, PDF or PPT reports.

ER Diagram (ERD)

Example 3. ER Diagram (ERD)

The ER Diagram samples you see on this page were created in ConceptDraw PRO v5 using the Entity-Relationship Diagram (ERD) Solution. They successfully demonstrate solution's capabilities and professional results you can achieve. An experienced user spent 10 minutes creating every of these samples.

Use the Entity-Relationship Diagram (ERD) Solution for ConceptDraw PRO v5 software to create your own professional looking ER Diagrams quick, easy and effective, and then successfully use them in your scientific or education activity.

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).




NINE RELATED HOW TO's:

Influence Diagram Software →

Influence diagram (ID) is a graphical and mathematical representation of the decision. Influence diagrams are widely used in the decision analysis and in the game theory. They are the alternative to the decision tree. The influence diagram gives to analyst the high-level conceptual view that it can use to build the detailed quantitative model. This sample shows the Influence diagram. It is a directed acyclic graph with three types of nodes: Decision node is drawn as a rectangle, Uncertainty node is drawn as an oval, Value node is drawn as an octagon. The nodes are connected with arcs.Influence Diagram Software *
Picture: Influence Diagram Software
Related Solution:

Best Program to Make Flow Chart Diagrams →

ConceptDraw the best business process modeling tool to make flow chart diagrams. Start creating your own flowchart with ConceptDraw DIAGRAM and accomplish great results in the moment. This is the best program to make flow chart diagrams that gives users the ability to simply draw any type of flowchart. The fast creating visualization for the structural data with the vector stencils from object libraries by using RapidDraw technology makes ConceptDraw DIAGRAM the first program in drawing flow data.Best Program to Make Flow Chart Diagrams *
Picture: Best Program to Make Flow Chart Diagrams
Related Solution:

Organization Structure →

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:

Cisco Telepresence. Cisco icons, shapes, stencils and symbols →

The ConceptDraw vector stencils library Cisco Telepresence contains videoconference equipment symbols for drawing the computer network diagrams.Cisco Telepresence. <br>Cisco icons, shapes, stencils and symbols *
Picture: Cisco Telepresence. Cisco icons, shapes, stencils and symbols
Related Solution:

How to Present a Social Media Response Plan DFD to Your Team →

Interactive tool helps you find the appropriate response to social media mentions quickly. There are materials to help trainers and consultants develop a social media strategy and provide training for social media groups on how to effectively accomplish their daily work.How to Present a Social Media Response Plan DFD to Your Team *
Picture: How to Present a Social Media Response Plan DFD to Your Team
Related Solution:

Context Diagram Template →

This template shows the Context Diagram. It was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the Block Diagrams Solution from the “Diagrams” area of ConceptDraw Solution Park. The context diagram graphically identifies the system. external factors, and relations between them. It’s a high level view of the system. The context diagrams are widely used in software engineering and systems engineering for designing the systems that process the information.Context Diagram Template *

Picture: Context Diagram Template
Related Solution:

How to Make an Accounting Process Flowchart →

Tips on how to make an accounting flowchart. Describing methods and symbols that are used to represent the accounting system.How to Make an Accounting Process Flowchart *
Picture: How to Make an Accounting Process Flowchart
Related Solution:
ConceptDraw
DIAGRAM 14