Entity-Relationship Diagram (ERD)
with ConceptDraw DIAGRAM
Entity-Relationship Diagram (ERD) serves for detailed description of structures and databases. An ERD represents a diagram made up mainly of rectangular blocks (for entities, or data) linked with relationships. The links between the blocks describe relations between these entities. There are three types of relationships:
- one-to-one,
- one-to-many,
- many-to-many.
For example, "driver drives a car". Here, the entity "driver" relates to the entity "car" by means of a one-to-one relationship "drives". One driver drives one car.
An example of a one-to-many relationship is a sergeant commanding a team of soldiers. Here the entity "sergeant" relates to a number of entities "soldier" by means of a one-to-many relationship.
Since the many-to-many relationship does not adequately represent the nature of interaction between entities, it is rarely used in diagrams, or is used in diagrams with little detail.
Entities and relationships can both have attributes. Example: a car from the first example has number; the "drives" relation may have quality attributes describing the quality of driving, or time attributes, saying when exactly the driver was driving the car.
ERDs are mainly used to describe database structures, though they might be used as diagrams describing a structure of a company, organization, or some business processes.
ConceptDraw DIAGRAM extended with Entity-Relationship Diagram (ERD) solution from the Software Development Area allows you to draw very complex and detailed ERD. It has a number of libraries with objects used in diagrams, which are included in relevant templates and samples available from ConceptDraw STORE.
Example 1. Entity-Relationship Diagram (ERD) Solution in ConceptDraw STORE
In actual practice, ERDs employing the method of P.P. Chen are used most. Choose the Chen ERD template in ConceptDraw STORE. A new document will open along with the library with objects necessary to create a diagram. Drag the vector objects representing entities and relationships, and then just connect them between each other in the required order. Use respective library objects to indicate the types of relationships and their attributes.
Example 2. ERD WordPressFile Reference. Chen's Notation
One of advantages of ERD diagram drawn in ConceptDraw DIAGRAM is that when you move entities on the diagram, they stay connected and you don't need to move relationships too.
Apart from building a diagram manually, ConceptDraw has a built-in tool for drawing an ERD automatically, from a database.
Example 3. Entity Relationship Model Diagram. Crow's Foot Notation
The samples you see on this page were created in ConceptDraw DIAGRAM using the Entity-Relationship Diagram (ERD) Solution and demonstrate some of solution's capabilities and the results you can achieve.
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.
TEN RELATED HOW TO's:
ConceptDraw DIAGRAM is a powerful tool for business and technical diagramming.
Software Development area of ConceptDraw Solution Park provides 5 solutions:
Data Flow Diagrams, Entity-Relationship Diagram (ERD), Graphic User Interface, IDEFO Diagrams, Rapid UML.
Picture: Software Diagram Examples and Templates
Related Solution:
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.
Picture: Data Flow Diagrams
Related Solution:
There are a lot of structured analysis and design technique methodologies used to describe systems and data sources. To visualize data structures, data flow diagrams can be used for various purposes in the area of software engineering. Nowadays these diagrams are also used in the area of business analysis and information system analysis.
This data flow diagram depicts an account processing system of a typical account department of a small manufacturing enterprise. It shows the data transmission through the order processing to shipping verification. This data flow diagram was created according to standard of Yourdon and Coad notation. The vector graphic objects of Yourdon/Coad notation symbols was delivered by ConceptDraw Data Flow Diagrams solution. The current DFD can be employed as an example of a business process model, representing the set of business events and interactions commonly engaged in a accounts receivable process.
Picture: Data Flow Diagrams
Related Solution:
The Entity-Relationship Diagram (ERD) Solution from the Software Development Area for ConceptDraw Solution Park extends ConceptDraw DIAGRAM vector graphics and diagramming software with the ability of drawing the Entity Relationship Diagrams for visually describing the databases with Crow’s Foot and Chen's notation icons.
Picture: Entity Relationship Diagrams
Related Solution:
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
Related Solution:
ER diagram is the most popular database design tool which lets create graphical representations of database tables, their columns and also relationships. As for the Mac users, they are very interested in powerful database diagramming tools and ER diagram tool for OS X to design professional looking E-R Diagrams and ERD drawings. ConceptDraw DIAGRAM software on Mac OS X gives the ability to easy draw ERDs.
Picture: ER diagram tool for OS X
Related Solution:
To pull a social media team together, to set your objectives, to develope an integrated communications strategy.
Picture: How to Present Workflow to Team
Related Solution:
Engineering students usually have huge amount of homework. Learning how to develop a technical drawing is one of the necessary skills. Luckily, at the present time, there’s no need to draw it on paper, because there a lot of software tools for it.
This drawing represents the Bearing symbols library, that is the part of the ConceptDraw Mechanical Engineering solution. Bearings are the important components of any movable mechanism. The function of bearing is to align, guide, and support the moving parts in any mechanical construction. Usually they are located between moving and stationary parts, it works as a connection point between them. Using Mechanical Engineering solution and ConceptDraw DIAGRAM one can effortlessly draw engineering diagrams of any complexity.
Picture: Technical Drawing Software
Related Solution:
The Total Quality Management Diagram solution helps your organization visualize business and industrial processes. Create Total Quality Management diagrams for business process with ConceptDraw software.
Picture: A Study of the Business Value of Total Quality Management
Related Solution:
