Made with
ConceptDraw
DIAGRAM 18

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




TEN RELATED HOW TO's:
The behavior of worker in organization is influences organizational effectiveness. A simple block diagram made with ConceptDraw Block diagrams solution can improve the understanding of expectations of workers regarding what they l contribute to organization and what they wait to obtain. Making block diagram depicting the individual behavior in organization is used in HR management to obtain an optimal and positive overall contribution to the organization. The behavior of worker in organization is influences organizational effectiveness. A simple block diagram made with ConceptDraw Block diagrams solution can improve the understanding of expectations of workers regarding what they l contribute to organization and what they wait to obtain. Making block diagram depicting the individual behavior in organization is used in HR management to obtain an optimal and positive overall contribution to the organization.Basic Diagramming *
Picture: Basic Diagramming
Related Solution:
Fast creating visualization for structured data is the main capability of ConceptDraw DIAGRAM software. With numerous vector stencils from object libraries and the RapidDraw technology this software becomes the best cross-functional flowchart software.Create a Cross-Functional Flowchart *
Picture: Create a Cross-Functional Flowchart
Related Solution:
Value Stream Mapping solution extends ConceptDraw DIAGRAM software with templates, samples and vector shapes for drawing the current state value stream maps.Learn how to create a current <br>state value stream map *
Picture: Learn how to create a current state value stream map
Related Solution:
Venn Diagrams visualize all possible logical intersections between several sets and are widely used in mathematics, logic, statistics, marketing, sociology, philosophy, etc. Using the ConceptDraw DIAGRAM you can create your own professional looking Venn Diagrams quick and easy.Venn Diagram Template for Word
Picture: Venn Diagram Template for Word
Related Solution:
A family evening in a restaurant can be just charming, the problem is to find a one. If you spend an extra day to create a good restaurant floor plan, that will surely brings more clients. By the time your restaurant gets more popular, don’t forget about the quality of service. The restaurant floor plan you see on this page was made with ConceptDraw DIAGRAM in accompanied with Cafe and Restaurant Plans solution. It introduces facilities of the solution and demonstrates the results, you can obtain if you deploy ConceptDraw tools for generating floor plans and interior designs for cafe, restaurants or other catering establishments. A little less than three hundred vector objects, and a set of built-in templates and a set of examples will maintain your creativeness.Restaurant Floor Plans
Picture: Restaurant Floor Plans
Related Solution:
Event-Driven Process chain Diagrams for improvement throughout an organisation. Best software for Process Flow Diagram. The Event-driven Process Chain (EPC) Diagrams allows managers to plan processes and resources.Business process Flow Chart — <br>Event-Driven Process chain (EPC) diagrams *
Picture: Business process Flow Chart — Event-Driven Process chain (EPC) diagrams
Related Solution:
ConceptDraw Pyramid Diagram software allows drawing column charts using predesigned objects or drawing tools.Pyramid Diagram *
Picture: Pyramid Diagram
Related Solutions:
The solution handles designs of any complexity, and the comprehensive library covers all key aspects of a transportation system. To further enhance your map design, there is the option to embed links, that can display station images or other relevant, important information. We have also included a set of samples in the solution, that show the possible real-world application — complex tube systems including the London Tube and New York City Subway show the level of detail possible when using the Metro Map Solution.How to draw Metro Map style infographics
Picture: How to Draw Metro Map style infographics? Moscow, New York, Los Angeles, London
Related Solution:
Electrical Engineering Solution used together with ConceptDraw DIAGRAM drawing facilities makes short a work of drawing various electrical and electronic circuit schemes. A library of vector objects composed from symbols of Analog and Digital Logic elements of electric circuit includes 40 symbolic images of logic gates, bistable switches of bi-stable electric current, circuit controllers, amplifiers, regulators, generators, etc. All of them can be applied in electronic circuit schemes for showing both analog and digital elements of the circuit. Electrical Engineering Solution used together with ConceptDraw DIAGRAM drawing facilities makes short a work of drawing various electrical and electronic circuit schemes. A library of vector objects composed from symbols of Analog and Digital Logic elements of electric circuit includes 40 symbolic images of logic gates, bistable switches of bi-stable electric current, circuit controllers, amplifiers, regulators, generators, etc. All of them can be applied in electronic circuit schemes for showing both analog and digital elements of the circuit.Electrical Diagram Symbols
Picture:
Electrical Diagram Symbols F.A.Q.
How to Use Electrical ConceptDraw Diagram Software
Related Solution:
ConceptDraw DIAGRAM diagramming and vector drawing software extended with tools of Flowcharts Solution from the Diagrams Area of ConceptDraw Solution Park ideally suits for fast and easy Online Flow Chart designing. We propose to verify this right now.Online Flow Chart *
Picture: Online Flow Chart
Related Solution:
ConceptDraw
DIAGRAM 18