Made with
ConceptDraw
DIAGRAM 15

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:

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:

Components of ER Diagram →

It is easy to recreate any informational system structure using diagrams. There are three main components of any ER diagram: entity, attribute and relationship. Basing on these three components, one can define other, less used elements, such as weak entity or relationship, derived attribute, recursive relationship etc. This is the set of graphic elements of ERD Chen's notation. This ERD notation is used to represent an entity–relationship models. It involves the set of geometric forms: rectangles - depicting entities, ovals - representing attributes and diamonds depicting relationships assigned for first-class objects, that can have relationships and attributes of their own. Connections are displayed with arrowed lines. It is known that the Chen's ERD notation is used to show a detailed view of entities and relationships. ConceptDraw Entity-Relationship Diagram solution from the Software Development section of Solution Park provides the ability to create ERD of database structure for software development purposes using the Chen’s notation elements.Components of ER Diagram *
Picture: Components of ER Diagram
Related Solution:

Sales Process Flowchart. Flowchart Examples →

Process mapping helps with sharing business results and reorganizing workflow. In almost every case, after creating a sales process flowchart the steps that are redundant become obvious for a manager. It's easy to find a flowchart examples that will help in developing one for your business. This sales process flowchart consists of a sequence of steps that represent a simple sale process. Each step is shown graphically by a rectangle representing processing steps or an activity, or a diamond representing a decision. These rectangles are linked by arrows, that indicate the direction of the sales workflow. ConceptDraw Sales Flowcharts solution delivers a the full set of classical flowchart notation symbols, along with sales-related icons and pictograms.Sales Process Flowchart. <br>Flowchart Examples *
Picture: Sales Process Flowchart. Flowchart Examples
Related Solutions:

Software and Database Design with ConceptDraw DIAGRAM  →

Using diagrams, you can visualize the flow of the information or build a detailed data structure. There's no need to have a degree in software and database design with ConceptDraw DIAGRAM , because this software has all the tools needed in developing models and diagrams. Project planning, designing and prototyping was never so easy. This UML diagrams can be used to visualize a model of the data base development process. A UML diagram shows a graphical view of a structure of software system: components and relationships. Using Unified Modeling Language helps to depict logical and physical elements of a data base, visually represent requirements and sub-systems. UML diagrams allows developers to organize and predict critical issues, as well as collaborate data base information.Software and Database Design with ConceptDraw DIAGRAM  *
Picture: Software and Database Design with ConceptDraw 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:

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:

Entity Relationship Diagram Examples →

ConceptDraw DIAGRAM diagramming and vector drawing software offers the Entity-Relationship Diagram (ERD) Solution from the Software Development Area for ConceptDraw Solution Park. How many examples contains the Entity-Relationship Diagram (ERD) Solution! All Entity Relationship Diagram examples were designed and saved for ConceptDraw DIAGRAM users. Now they are available from ConceptDraw STORE.Entity Relationship Diagram Examples *
Picture: Entity Relationship Diagram Examples
Related Solution:
ConceptDraw
DIAGRAM 15