Made with
ConceptDraw
DIAGRAM 14

What is Entity-Relationship Diagram

A database is a data collection, structured into some conceptual model. Two most common approaches of developing data models are:

  • UML diagrams
  • ER-model diagrams.

What is Entity-Relationship Diagram? Entity relationship diagrams look very similar to flowcharts, the main difference is the symbols provided by specific ERD notations. There are several models applied in entity-relationship diagrams: conceptual, logical and physical.

What is Entity-Relationship Diagram *

Example 1. What is Entity-Relationship Diagram, Crow's foot notation

Creating an entity relationship diagram requires using a specific notation. There are several notations of entity-relationship diagram symbols and their meaning is slightly different. Five main components of common ERD notations are Entities, Actions, Attributes, Cardinality and Connections.

What is Entity-Relationship Diagram, Chen's notation

Example 2. What is Entity-Relationship Diagram, Chen's notation


ERD notations

The two of notations most widely used for creating Entity-Relationship Diagrams are:

  • Chen's notation
  • Crow's foot notation.

Crow’s Foot notation is quite descriptive and easy to understand, meanwhile, the Chen notation is great for conceptual modeling. By the way, the Crow's foot notation originates from the Chen's notation - it is an adapted version of the Chen's notation.

Professional ERD drawing implies knowing of ERD symbols and meanings. Entity-Relationship Diagram (ERD) solution from Software Development area of ConceptDraw Solution Park includes icons advocated by Chen's and Crow’s Foot notation that can be used when describing a database.

ERD Libraries

Example 3. ERD Libraries

In Entity-Relationship Diagram (ERD) solution for ConceptDraw DIAGRAM all entity relationship diagram symbols and meaning, work flow shapes, and entity relationship stencils have easy to understand labels helps you while building Entity Relationship Diagram.

Entity-Relationship Diagram Symbols

Example 4. Entity-Relationship Diagram Symbols

The Entity-Relationship Diagram (ERD) solution from ConceptDraw Solution Park extends ConceptDraw DIAGRAM ector graphics and diagramming software with the ability to describe a database using the Entity-Relationship model. Use it to draw with pleasure your own professional-looking Entity-Relationship Diagrams using Chen's or Crow's foot notations.

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) from the ConceptDraw STORE. The Entity-Relationship Diagram (ERD) Solution is available for all ConceptDraw DIAGRAM or later users.






EIGHT RELATED HOW TO's:

UML Component for Bank →

UML Component for Bank - This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the UML Component Diagram library of the Rapid UML Solution from the Software Development area of ConceptDraw Solution ParkUML Component for Bank *
Picture: UML Component for Bank
Related Solution:

UML Component Diagram. Design Elements →

UML Component Diagram illustrates show components are wired together to larger components and software systems that shows the structure of arbitrarily complex systems. Rapid UML Solution for ConceptDraw DIAGRAM contains 13 vector stencils libraries with 393 interactive shapes that you can use to design your UML diagrams. To design a Component Diagram use the UML Component Diagram library. UML Component Diagram library contains 36 shapesUML Component Diagram. Design Elements *
Picture: UML Component Diagram. Design Elements
Related Solution:

Block Diagram Software →

The popularity of Block Diagrams grows day by day. The existence of powerful software for their design is an excellent news! ConceptDraw DIAGRAM Block Diagram Software offers the Block Diagrams Solution from the "Diagrams" Area.Block Diagram Software *
Picture: Block Diagram Software
Related Solution:

Process Flowchart →

When trying to figure out the nature of the problems occurring within a project, there are many ways to develop such understanding. One of the most common ways to document processes for further improvement is to draw a process flowchart, which depicts the activities of the process arranged in sequential order — this is business process management. ConceptDraw DIAGRAM is business process mapping software with impressive range of productivity features for business process management and classic project management. This business process management software is helpful for many purposes from different payment processes, or manufacturing processes to chemical processes. Business process mapping flowcharts helps clarify the actual workflow of different people engaged in the same process. This samples were made with ConceptDraw DIAGRAM — business process mapping software for flowcharting and used as classic visio alternative because its briefly named "visio for mac" and for windows, this sort of software named the business process management tools. This flowchart diagram shows a process flow of project management. The diagram that is presented here depicts the project life cycle that is basic for the most of project management methods. Breaking a project into phases allows to track it in the proper manner. Through separation on phases, the total workflow of a project is divided into some foreseeable components, thus making it easier to follow the project status. A project life cycle commonly includes: initiation, definition, design, development and implementation phases. Distinguished method to show parallel and interdependent processes, as well as project life cycle relationships. A flowchart diagram is often used as visual guide to project. For instance, it used by marketing project management software for visualizing stages of marketing activities or as project management workflow tools. Created with ConceptDraw DIAGRAM — business process mapping software which is flowcharting visio alternative or shortly its visio for mac, this sort of software platform often named the business process management tools.Process Flowchart
Picture: Process Flowchart
Related Solution:

Venn Diagram →

Venn diagrams are illustrations used in the branch of mathematics known as set theory. They show the mathematical or logical relationship between different groups of things (sets). A Venn diagram shows all the possible logical relations between the sets.Venn Diagram - Sustainable Development
Picture: Venn Diagram
Related Solution:

Database Flowchart Symbols →

Data base diagrams describes inter-related data and tables. It describes roles and relationships, internal and external dependencies, data exchange conventions and structures of knowledge domain. ConceptDraw Software provides number of data-base chart libraries including major 49 vector symbols. Use these DFD flowchart symbol libraries to design data-base structure and models, use it to design data base process-oriented models, or simple data-oriented models. The are special drawing tools for making data flowcharts, data process diagrams, structured analysis diagrams, and information flow diagrams.Database Flowchart Symbols *
Picture: Database Flowchart Symbols
Related Solution:

UML Timing Diagram, Design Elements →

UML Timing Diagram as special form of a sequence diagram are used to explore the behaviors of objects throughout a given period of time. ConceptDraw has 393 vector stencils in the 13 libraries that helps you to start using software for designing your own UML Diagrams. You can use the appropriate stencils of UML notation from UML Timing library.UML Timing Diagram, Design Elements *
Picture: UML Timing Diagram, Design Elements
Related Solution:

How Do You Make An Accounting Process Flowchart? →

To describe the accounting processing use ConceptDraw Flowchart set of symbold created for Accounting data processing. Tips, Methods and Symbols on How to Create Flowcharts for an Accounting Information System.How Do You Make An Accounting Process Flowchart? *
Picture: How Do You Make An Accounting Process Flowchart?
Related Solution:
ConceptDraw
DIAGRAM 14