Made with
ConceptDraw
DIAGRAM 17

Entity-Relationship Diagram

Entity–Relationship modeling was developed by Peter Chen in 1976 for database design. Usually ER Model is constructed as abstract data model which defines information structure and data.

The Entity-Relationship Diagram (ERD) is the world-known way to show the logical structure of databases in visual manner. It gives an overall plan of how the database will look and is constructed of graphical elements, mainly of rectangles (representing entities and their properties) and lines (representing relationships and relationships of entities with each other). All relationships are divided into three categories: one-to-one (1:1), one-to-many (1:N), and many-to-many (M:N). Each entity has properties or characteristics that are implemented in the form of attributes that describe each entity instance.

The best software tool for drawing Entity-Relationship Diagram is ConceptDraw DIAGRAM ector graphics software with Entity-Relationship Diagram (ERD) solution from Software Development area which gives the ability to describe a database using the Entity-Relationship model.

Entity-Relationship Diagram *

Example 1. Entity-Relationship Diagram (ERD) - Students and Teachers

Entity-Relationship Diagram (ERD) solution includes vector icons advocated by popular Chen's or Crow's foot notations that can be used when describing an enterprise database. All they are offered by the libraries: ERD Chen's Notation and ERD Crow' Foot Notation.

ERD Libraries

Example 2. ERD Libraries

Develop ER models and ER diagrams using these predesigned vector objects, or start with one of predesigned ERD templates from the Entity-Relationship Diagram solution. Two professionally designed ERD templates (Chen and Crow's Foot) are available at ConceptDraw STORE.

ConceptDraw STORE - ERD Templates

Example 3. ConceptDraw STORE - ERD Templates

The vector graphic diagrams produced using the Entity-Relationship Diagram (ERD) solution and also samples included to it can be successfully used in whitepapers, presentations, datasheets, posters, or any technical materials.

Entity-Relationship Diagram

Example 4. Entity-Relationship Diagram

The Entity-Relationship Diagram samples you see on this page were created in ConceptDraw DIAGRAM diagramming and vector drawing software using the Entity-Relationship Diagram (ERD) solution from ConceptDraw Solution Park. An experienced user spent 5 minutes creating each of these diagrams.

Use ConceptDraw DIAGRAM enhanced with Entity-Relationship Diagram (ERD) solution to draw quick and easy your own Entity-Relationship Diagram 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.






NINE RELATED HOW TO's:
UML diagrams of business processes. The Rapid UML solution provides diagram examples, templates and vector stencils libraries for quick and easy drawing all types of UML 2.x and 1.x diagrams: UML activity diagrams, UML communication (collaboration) diagrams, UML component diagrams, UML composite structure diagrams, UML deployment diagrams, UML interaction overview diagrams, UML object diagrams, UML package diagrams, UML sequence diagrams, UML state machine diagrams, UML timing diagrams, UML use case diagrams.UML Business Process *
Picture: UML Business Process
Related Solution:
A competent delegation of responsibilities between workers guarantees business success in most cases. At first sight, it might seem that workflow diagram symbols are quite similar to a regular flowchart. But workflow diagram is a more accurate way to present working processes. Workflow diagrams are helpful for a working process analyzation, to depict a pathway of process issues, personalize responsibilities and identify resources that will help to optimize a workflow. Generally, Workflow diagram deploys flowchart symbols for displaying work process steps and relationships. But, often it require some additions and improvements to become more professional and illustrative. The Workflow solution for ConceptDraw DIAGRAM provides the user with a big library of symbols that are designed especially for workflow diagrams.Workflow Diagram Symbols *
Picture: Workflow Diagram Symbols
Related Solution:
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:
The ConceptDraw Flowchart component includes a set of samples and templates. This geathered as flowchart maker toolbox which focused on drawing flowcharts of any industry standards.Flowchart Components
Picture: Flowchart Components
Related Solution:
To maintain big and complex mechanical systems, you need an appropriate education and tools. It’s needless to say that mechanical drawing is important part of any industrial project. There are a lot of standard symbols depicting valves, pumps, motors, etc. This drawing illustrates the content of the Fluid Power Equipment library provided by the ConceptDraw Mechanical Engineering solution. The solution is composed from the 8 libraries, containing about 500 elements related to mechanical engineering visualization. it will be helpful for drawing various schemes, charts and blueprints of pneumatic, and hydraulic equipment or other drawing related mechanical engineering. All drawings can be freely resized without loss of quality due to the vector graphics components of its facilities.Mechanical Drawing Symbols
Picture: Mechanical Drawing Symbols
Related Solution:
UML Collaboration Diagram depicts the interactions between objects or parts in terms of sequenced messages and describes both the static structure and dynamic behavior of a system. Rapid UML solution provides templates, examples and libraries of stencils for quick and easy drawing all the types of system and software engineering diagrams according to UML 2.4 and 1.2 notations.UML Collaboration Diagram (UML2.0) *
Picture: UML Collaboration Diagram (UML2.0)
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 Symbols, Electrical Diagram Symbols
Related Solution:
This sample shows the Use Case Diagram of parking lot control system. On this sample you can see use cases represented as ovals and three actors represented as figures of persons that employ these use cases. Associations between actors and use cases are shown as lines. UML Diagram of Parking - This diagram can be used for understanding the process of working the car parking, at the projection and construction the parking by building companies and for automation the existing parkings.UML Diagram of Parking *
Picture: UML Diagram of Parking
Related Solution:
ConceptDraw
DIAGRAM 17