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




TEN RELATED HOW TO's:

UML Use Case Diagram Example - Estate Agency →

UML Diagram Estate Agency. This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the UML Use Case Diagram library of the Rapid UML Solution from the Software Development area of ConceptDraw Solution Park. This sample shows the work of the estate agency and is used by the estate agencies, building companies, at the trainings of the estate agencies, for understanding the working processes of the estate agencies.UML Use Case Diagram Example - Estate Agency *
Picture: UML Use Case Diagram Example - Estate Agency
Related Solution:

Android GUI →

Android is an operating system based on the Linux kernel and developed by Google for smartphones, tablet computers, electronic books, netbooks, smartbooks, digital players, watches, game consoles, TV and other devices. ConceptDraw DIAGRAM extended with Android User Interface Solution from the Software Development Area is a powerful software with extensive drawing tools which can help you to build the intelligible, attractive and easy for perception Android GUI for your application.Android GUI *
Picture: Android GUI
Related Solution:

How to Connect Social Media DFD Flowchart with Action Maps →

The Social Media Response solution creates interactive social media flow charts and action mind maps. The solution includes a video tutorial and a number of samples helping social media teams refine and organize their response process.How to Connect Social Media DFD Flowchart with Action Maps *
Picture: How to Connect Social Media DFD Flowchart with Action Maps
Related Solution:

UML Diagram →

While developing software, it is very important to have a visual model, because it helps to represent the logic and the architecture of an application. Experienced engineers use UML diagrams to denote relationships between classes and their instances. UML is a general language for a set of diagrams like deployment diagrams, object diagrams or use case diagrams. This diagram represents UML class diagram used for a software system development using an object-oriented method. Class diagrams are categorized as static structure diagrams that depict the physical structure of a system. Class diagram divides a software system's structure into "classes". Classes are defined by the methods and variables of objects. UML Class diagram is used to depict relationships and source code dependencies between objects.UML Diagram *
Picture: UML Diagram
Related Solution:

Program Evaluation and Review Technique (PERT) with ConceptDraw DIAGRAM  →

Big and complex projects sometimes need some simplification of plans and schedules. That's why Program Evaluation and Review Technique was invented and first implemented in 1958. You can create PERT diagrams effortlessly with ConceptDraw DIAGRAM and share them with your colleagues. Program Evaluation Review Technique (PERT) is a method that is used to assess and analyze projects. PERT is a valuable tool for the project management practice. PERT gives an assessment and analysis of the time needed to the project completion. A PERT chart is a visual tool that delivers a graphical view of a project timeline. It is used to display the sequences and dependences of project tasks necessary to complete a project. ConceptDraw DIAGRAM delivers the possibility to build a PERT along with other diagrams applied to assist management process by using its Seven Management and Planning Tools solution.Program Evaluation and Review Technique <br>(PERT) with ConceptDraw DIAGRAM  *
Picture: Program Evaluation and Review Technique (PERT) with ConceptDraw DIAGRAM
Related Solution:

Flowchart Marketing Process. Flowchart Examples →

This sample shows the Flowchart that displays the layout and work flow of the cloud marketing platform. This diagram has a style of the marketing brochure. This style displays the central product that is related to the other issues. Using the ready-to-use predesigned objects, samples and templates from the Flowcharts Solution for ConceptDraw DIAGRAM you can create your own professional looking Flowchart Diagrams quick and easy.Flowchart Marketing Process. <br>Flowchart Examples *
Picture: Flowchart Marketing Process. Flowchart Examples
Related Solution:

Design Element: Crows Foot for Entity Relationship Diagram - ERD →

The first thing that usually comes to mind when talking about database models is ER-diagrams, and the ways to create them. The second most recognizable notation is the Crow’s Foot, which visually differs from Chen’s notation. Actually, it doesn’t matter which notation you’ll use for your entity relationship diagram (ERD), but the content is what matters. When designing an Entity-Relationship Diagram one need to use a certain notated symbols that were developed and standardized especially for databases description. First of them - the Chen’s notation had a linguistic origin. It includes rectangle boxes to show entities that may be described as nouns, and the relationships between them described as verbs depicted in a form of diamond. Finally the Chen’s notation was simplified up to the Crow’s Foot notation. It represents a relationship as labeled line. It is precisely this notation is shown in the given figure. ConceptDraw DIAGRAM together with its Entity-Relationship Diagram (ERD) solution is designed to support professionals who deals with creating ER diagrams using the element of both - Chen’s and Crow's Foot notations.Design Element: Crows Foot   <br>for Entity Relationship Diagram - ERD *
Picture: Design Element: Crows Foot for Entity Relationship Diagram - ERD
Related Solution:

Processing Flow Chart →

Processing Flow Chart is a simplified sketch which is used in chemical and process engineering for illustrating general plant streams, major equipments and key control loops.

ConceptDraw DIAGRAM enhanced with Flowcharts Solution from the "Diagrams" Area of ConceptDraw Solution Park is a powerful Processing Flow Chart software which will help save lots of your time.Processing Flow Chart *

Picture: Processing Flow Chart
Related Solution:

How To Draw Building Plans →

Architectural drawing allows to show the location of a building or ensemble of buildings on the ground, indicating the cardinal points. For centuries, people had been studying architecture in universities to learn how to draw building plans and now everyone can do it easily just using appropriate software. While developing the building plan, its graphic part, you can display the part of the floor or the entire floor of a building with an indication of the exact location of the drawn premise. Small-sized apartments does not restrict the advanced interior design opportunities. Here is a detailed and precise floor plan of a pretty small apartment. A furniture objects are added to show possible interior of this home. This plan can be used to help somebody with a floor layout and furniture arrangement. Having this floor plan in a pocket while shopping would be useful to check if there is enough rooms for a new furniture.How To Draw Building Plans
Picture: How To Draw Building Plans
Related Solution:
ConceptDraw
DIAGRAM 14