Made with
ConceptDraw
DIAGRAM 14

E-R Diagrams

Complexity of databases increases day by day, due to this the Entity relationship models and E-R diagrams become more and more popular, and now are an important part of database design. E-R diagrams allow visually and graphically represent structure and design of databases.

You can use so popular Chen's notation to represent all components of database and their relationships on the ER diagram. This notation was developed and implemented by Peter Chen in 1976. The main components of the E-R diagrams are:

  • entities,
  • attributes that describe these entities,
  • relationships among these entities that describe associations between the data,
  • cardinalities that describe the number of relationship participants: one-to-many (1:M), many-to-many (M:N), and one-to-one (1:1).

In a Chen's notation, entities are represented by rectangles on the diagram with the entity names written inside and relationships are represented by diamonds. Another popular type of E-R diagrams is known as Crow's Foot notation that is derived from the Chen's notation.

E-R Diagram - Students and teachers

Example 1. E-R Diagram - Students and teachers

Use of ConceptDraw DIAGRAM for professional ERD drawing includes using the predesigned components of ER diagram, such as entity relationship symbols, work flow shapes, entity relationship stencils. All they are provided for easy use by 2 libraries of Entity-Relationship Diagram (ERD) Solution from the Software Development Area for ConceptDraw Solution Park.

ERD Libraries

Example 2. ERD Libraries

There is also wide collection of predesigned E-R Diagrams which is represented at ConceptDraw STORE. All E-R Diagrams samples and templates are well thought-out, professionally designed, can be easy changed according to your needs and further successfully used.

E-R Diagrams *

Example 3. E-R Diagrams in ConceptDraw DIAGRAM

The following features make ConceptDraw DIAGRAM extended with the Entity-Relationship Diagram (ERD) solution the most effective E-R diagrams design software:

  1. You don't need to be an artist to draw professional looking diagrams in a few minutes.
  2. Large quantity of ready-to-use vector objects makes drawing your diagrams quick and easy.
  3. Extensive collection of pre-designed templates and samples give you a great start for your own diagrams.
  4. ConceptDraw DIAGRAM provides you with the possibility to use the grid, rules and guides. You can easily rotate, group, align, and arrange objects, and use different fonts and colors to make your diagram stand out.
  5. All ConceptDraw DIAGRAM documents are vector graphic files and are available for reviewing, modifying, and converting to a variety of formats: image, HTML, PDF file, MS PowerPoint Presentation, Adobe Flash, MS Visio.
  6. Using ConceptDraw STORE you can navigate through ConceptDraw Solution Park, managing downloads and updates. You can access libraries, templates and samples directly from ConceptDraw STORE.
  7. If you have any questions, our support is free of charge and always ready to come to your aid.






NINE RELATED HOW TO's:

Flow Diagram →

A flowchart can take any process and distil it into a series of actions or decisions; it is a versatile and simple form of diagram that can be used to describe situations in any field, and is easily understood by everyone. They are used frequently in business to document workflows from all areas of a company - they can show accounting purchase orders, human resource recruitment strategy, or a product life cycle. ConceptDraw DIAGRAM diagramming and vector drawing software extended with Flowcharts Solution from the "Diagrams" Area of ConceptDraw Solution Park is a perfect powerful tool for extremely easy designing professional looking Flow Diagram.Flow Diagram *
Picture: Flow Diagram
Related Solution:

DFD Flowchart Symbols →

A Data Flow Diagram (DFD) is a graphical technique which allows effectively model and analyze the information processes and systems. The ability to fast and easy create the DFDs is made possible with Data Flow Diagrams solution from the Software Development area of ConceptDraw Solution Park. For designing the Data Flow Diagrams are used simple DFD flowchart symbols which are connected each other by arrows depicting the data flow from one step to another.DFD Flowchart Symbols *
Picture: DFD Flowchart Symbols
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:

PDPC →

ConceptDraw DIAGRAM extended with Seven Management and Planning Tools Solution from the Management Area of ConceptDraw Solution Park is the best software for drawing all types of diagrams from the Seven Management and Planning Tools: Affinity Diagram, Relations Diagram, Prioritization Matrix, Root Cause Analysis Tree Diagram, Involvement Matrix, PERT Chart, and Risk Diagram (PDPC).PDPC *
Picture: PDPC
Related Solution:

Mathematical Diagrams →

ConceptDraw DIAGRAM diagramming and vector drawing software extended with Mathematics solution from the Science and Education area is the best for creating: mathematical diagrams, graphics, tape diagrams various mathematical illustrations of any complexity quick and easy. Mathematics solution provides 3 libraries: Plane Geometry Library, Solid Geometry Library, Trigonometric Functions Library.Solving Quadratic Equation
Picture: Mathematical Diagrams
Related Solution:

UML Deployment Diagram. Design Elements →

UML Deployment diagram describes the hardware used in system implementations and the execution environments and artifacts deployed on the hardware. 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 Deployment library.UML Deployment Diagram. Design Elements *
Picture: UML Deployment Diagram. Design Elements
Related Solution:

Data Flow Diagrams →

Software development flourishes nowadays. Students have tons of educational information and courses that would fit every taste. And it's no secret that knowing how to draw data flow diagrams is a useful skill for a future software architect. The diagrams help a lot in understanding how to storage data effectively and how data processes within a system. This data flow diagram represents the model of small traditional production enterprise. It was created using Yourdon and Coad notation. The data flow diagram include four main objects: entity, process, data store and data flow. Yourdon and Coad notation uses circles to depict processes and parallel lines to represent data stores. Dataflows are shown as arrowed lines. They are labeled with the description of the data that move through them. Dataflow's role is to deliver the pieces of information. A process's function is to transform. the input data flow into output data flow. ConceptDraw Data Flow Diagrams solution contains the data flow diagram symbols of both Yourdon-Coad and Gane-Sarson notations and a set of handy templates to get started with DFD.Data Flow Diagrams *
Picture: Data Flow Diagrams
Related Solution:

Flow chart Example. Warehouse Flowchart →

If you want to find a way to understand complex things in minutes, you should try to visualize data. One of the most useful tool for this is creating a flowchart, which is a diagram representing stages of some process in sequential order. There are so many possible uses of flowcharts and you can find tons of flow charts examples and predesigned templates on the Internet. Warehouse flowchart is often used for describing workflow and business process mapping. Using your imagination, you can simplify your job or daily routine with flowcharts. Warehouse flowcharts are used to document product and information flow between sources of supply and consumers. The flowchart provides the staged guidance on how to manage each aspect of warehousing and describes such aspects as receiving of supplies; control of quality; shipment and storage and corresponding document flow. Warehouse flowchart, being actual is a good source of information. It indicates the stepwise way to complete the warehouse and inventory management process flow. Also it can be very useful for an inventory and audit procedures.Warehouse Flowchart
Picture: Flow chart Example. Warehouse Flowchart
Related Solution:

Data Flow Diagram Example →

ConceptDraw DIAGRAM extended with Data Flow Diagrams solution is the best diagramming and vector drawing software for quick and easy designing the Data Flow Diagram Example of any complexity.Data Flow Diagram Example *
Picture: Data Flow Diagram Example
Related Solution:
ConceptDraw
DIAGRAM 14