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.
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).
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.
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 vector stencils library Chen ERD from the solution Entity-Relationship Diagrams (ERD) contains specific symbols of the Chen ERD notation including entity symbols and relationship symbols for ConceptDraw DIAGRAM diagramming and vector drawing software. The Entity-Relationship Diagrams (ERD) solution is contained in the Software Development area of ConceptDraw Solution Park.
Picture: Chen ERD Diagram
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.
Picture: UML Use Case Diagram Example - Estate Agency
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.
Picture: Android GUI
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.
Picture: How to Connect Social Media DFD Flowchart with Action Maps
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.
Picture: UML 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.
Picture: Program Evaluation and Review Technique (PERT) with ConceptDraw DIAGRAM
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.
Picture: Flowchart Marketing Process. Flowchart Examples
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.
Picture: Design Element: Crows Foot for Entity Relationship Diagram - ERD
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.
Picture: Processing Flow Chart