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:
Pyramid diagrams help you visualize information as a triangle divided into horizontal slices. Labelled slices represent a hierarchy. Pyramids are used in marketing presentations to show and analyze hierarchy levels.
3D triangular diagram of DIKW pyramid has 6 levels: measurement, facts, data, information, knowledge, wisdom.
The data component include different scattered signs or symbols which are merely useless until these random objective facts are somehow processed. Data is a resource which has to be manipulated or rearranged to get useful. Information can be extracted from a pile of data, it also can be mined from different data storages.
Picture: Pyramid Diagram
Related Solutions:
Use the libraries from the Block Diagrams solution to draw block diagrams for your business documents, presentations and websites in a few minutes.
Picture: Block Diagram
Related Solution:
These libraries of vector objects depict the Site Accessories and Parking and Roads elements. They are needed to draw architectural and landscape plans that show the architectural elements around buildings: parking spaces, hiking and biking trails, drainage systems, lights, and vehicle access control elements. These libraries are included into ConcepDraw solution for Site Planning. Site Accessories and Parking, Roads libraries contain near 40 vector images that will help depict an a surrounding territory at building plans.
These libraries of vector objects depict the Site Accessories and Parking and Roads elements. They are needed to draw architectural and landscape plans that show the architectural elements around buildings: parking spaces, hiking and biking trails, drainage systems, lights, and vehicle access control elements. These libraries are included into ConcepDraw solution for Site Planning. Site Accessories and Parking, Roads libraries contain near 40 vector images that will help depict an a surrounding territory at building plans.
Picture: Building Drawing. Design Element Site Plan
Related Solution:
ConceptDraw DIAGRAM contains spatial infographics samples, map templates to be filled in, and libraries of vector stencils for main design elements of spatial infographics.
Picture: Brilliant Examples of Infographics Map, Transport, Road
The Entity-Relationship Diagram (ERD) solution from ConceptDraw Solution Park extends ConceptDraw DIAGRAM vector graphics and diagramming software with the ability to describe a database using the Entity-Relationship (Chen) model. Use it for design your ERDs and verify that ConceptDraw DIAGRAM offers the best ERD diagrams software tools for design element Chen notation._Win_Mac.png)
Picture: Entity Relationship Diagram - ERD - Software for Design Chen ER Diagrams
Related Solution:
What's the best ERD tool for the Mac? ConceptDraw DIAGRAM on Mac OS X supplied with Entity-Relationship Diagram (ERD) Solution from the Software Development Area for ConceptDraw Solution Park is the best ERD tool! This solution offers for ConceptDraw users so powerful drawing tools, libraries with numerous ERD objects, which will help design ER diagrams of any complexity and any design you want.
Picture: What's the best ERD tool for the Mac?
Related Solution:
An integrated circuit (IC) is a chip or microchip that consists of a substrate created from semiconductor material and thousands or millions of tiny electronic components installed on it. ConceptDraw DIAGRAM software with included Digital Electronics solution allows you to choose from an enormous number of vector electrical symbols, integrated circuits, logic gates, connections, flip flop symbols. Collection of the pre-made symbols and also an included set of professionally designed samples are useful to create Integrated circuit schematics of various kinds in minutes.
Picture: Integrated Circuit
The visual form of mind maps is helpful in all stages of quality management, from describing problem to describing and documenting a decision.
Picture: Quality Project Management with Mind Maps
Related Solution:
UML Use Case Diagrams are used to illustrate the structure of arbitrarily complex systems and illustrates the service consumer - service provider relationship between components.
Picture: UML Use Case Diagram. Design Elements
There are many ways to define the flow of information within a system. Structured-systems analysis method often uses data flow diagrams to show data flow, data storages and data processing visualization. These diagrams are easy to develop and quite useful.
Here is a dataflow diagram presenting an example of the manufacturing process flow. The oval process shapes represent a process that controls data within the current system. The process may produce data or make some action based on data. Data flows are represented by lines. They show the movement of information through the system. The direction of the data flow is depicted by the arrow. The external entities are shown by rectangles. They represent the external entities interacting with the system. The data store objects (unclosed rectangles) are used to show data bases participating in a process flow.
Picture: Data Flow Diagram
Related Solution:
