Entity Relationship Diagram Examples

Creation of Entity-Relationship (ER) model is a visual representation the structure of a business database, where data equates to entities or objects, which are linked by defined relationships expressing dependencies and requirements. By the nature, the ER model is an abstract visualization, a first step in design process towards creating a logical and functional database. ConceptDraw DIAGRAM professional software gives the ability to effectively describe a database using the Entity-Relationship model. Included to ConceptDraw Solution Park, the Entity-Relationship Diagram (ERD) solution contains the set of predesigned vector icons advocated by Chen's and Crow’s Foot notations that both can be used for data modeling and describing a database. Entity-Relationship Diagram (ERD) solution includes also helpful templates and incredibly large collection of varied Entity Relationship Diagram examples and samples offered at ConceptDraw STORE. Each of them can be used to develop your own model of a database of arbitrary complexity.

How to Build an Entity Relationship Diagram (ERD)

Entity Relationship Diagram Symbols

The semantic modeling method nowadays is successfully applied in database structure design. It is effective method of modeling the data structures, which is based on the meaning of these data. As a tool of semantic modeling, there are used different types of Entity-Relationship Diagrams. Entity Relationship Diagram (ERD) is applied to visually and clearly represent a structure of a business database. The main components of ERDs are: entity, relation and attributes. An entity is a class of similar objects in the model, each entity is depicted in the form of rectangle and has the name expressed by a noun. Relation is shown in the form of non-directional line that connects two entities. There are several notation styles used for ERDs: information engineering style, Chen style, Bachman style, Martin Style. The Entity Relationship Diagram symbols used for professional ERD drawing are predesigned by professionals and collected in the libraries of the Entity-Relationship Diagram (ERD) solution for ConceptDraw DIAGRAM software.

ERD Symbols and Meanings

Entity Relationship Diagram (ERD) is a popular software engineering tool for database modeling and illustration the logical structure of databases, which uses one of two notations - Chen's or Crow’s Foot. Crow's foot notation is effective when used in software engineering, information engineering, structured systems analysis and design. Each of these notations applies its own set of ERD symbols. Crow's foot diagrams use boxes to represent entities and lines between these boxes to show relationships. Varied shapes at the ends of lines depict the cardinality of a given relationship. Chen's ERD notation is more detailed way to represent entities and relationships. ConceptDraw DIAGRAM application enhanced with all-inclusive Entity-Relationship Diagram (ERD) solution allows design professional ER diagrams with Chen's or Crow’s Foot notation on your choice. It contains the full set of ready-to-use standardized ERD symbols and meanings helpful for quickly drawing, collection of predesigned ERD samples, examples and templates. ConceptDraw Pro is a great alternative to Visio for Mac users as it offers more features and can easily handle the most demanding professional needs.

How to Build an Entity Relationship Diagram (ERD)

UML Class Diagram Generalization Example UML Diagrams

This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the UML Class Diagram library of the Rapid UML Solution from the Software Development area of ConceptDraw Solution Park. This sample describes the use of the classes, the generalization associations between them, the multiplicity of associations and constraints. Provided UML diagram is one of the examples set that are part of Rapid UML solution.

Flowchart Components

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.

Piping and Instrumentation Diagram Software

Piping and Instrumentation Diagram is a technical sketch or drawing, which shows in details the piping system and instrumentation of a processing plant. Piping and Instrumentation Diagram is developed by process design engineers and technical engineers on the phase of plant design. This plan is necessary on the stages of plant construction and then is actively used by operators, instrumentation and piping engineers when operating the plant. ConceptDraw DIAGRAM software provides unique Plumbing and Piping Plans solution from Building Plans area of ConceptDraw Solution Park with 10 libraries of ready-to-use predesigned vector elements, templates and samples, to help you create professional Piping diagrams and schematics, Instrumentation diagrams, Plumbing plans and blueprints, Schemes of hot and cold water supply systems, Heating schemes, Mechanical diagrams, Diagrams of fluids, hydraulics, air and gas pipings, Technical drawings of waste water disposal systems, Schematics of industrial piping systems, Diagrams of ventilation systems, etc.

Watercraft - Vector stencils library

The vector stencils library "Watercraft" contains 28 clip art images for creating ship transport illustrations, presentation slides, infographics and webpages using the ConceptDraw PRO diagramming and vector drawing software.
"The term watercraft covers a range of different vehicles including ships, boats, hovercraft and submarines, and differs from a simple device that merely floats, such as a log raft. ...
Usually the purposes behind watercraft designs and skills are for seafaring education or leisure activities, fishing and resource extraction, transportation of cargo or passengers, and for conducting combat or salvage operations. In general, the purpose of a water vehicle identifies its utility with a maritime industry sub-sector." [Watercraft. Wikipedia]
The vector stencils library "Watercraft" is included in the Aerospace and Transport solution from the Illustrations area of ConceptDraw Solution Park.
www.conceptdraw.com/ solution-park/ illustrations-aerospace-transport

Boat

Motorboat

Yacht

Sailing yacht

Motor yacht

Passenger vessel

Sailing ship

Passenger ship

Regular ship

Tugboat

Oil ship

Dry cargo ship

Dry cargo vessel

Capesize bulk-carrier

Handysize bulk-carrier

Container ship

Multipurpose ship

Reefer

Oil tanker

Reefer vessel

Gas ship

Lighter aboard ship

Offshore oil platform

Car carrier

Battleship

Submarine

Container ship

Used Solutions

Illustrations >

Aerospace and Transport

Components of ER Diagram

Entity-Relationship model gives the possibility to visually describe a database using the components of ER Diagram, entity relationship stencils, relationship symbols, work flow shapes. ER-diagram lets represent the data or entities, attributes of these entities and relationships between them, using standardized Crow’s Foot notation icons or Chen’s notation icons. An entity is an object of the real world, it can exist independently and has the instances which differ in attribute values (properties). The attributes give an unambiguous (uniquely) identification for the instance and are called the primary key, this key can be composite and combine several attributes. ConceptDraw DIAGRAM is a professional software available with Entity-Relationship Diagram (ERD) solution from Software Development area that lets create ERDs for various database systems, using Crow’s Foot and Chen’s notations. It is invaluable tool for software engineers and developers, it supports ODBC-compatible databases (Oracle, MySQL, MS Access, MS SQL, InterBase, Firebird and others).

Telecommunication Network Diagrams

Telecommunication Network Diagrams solution extends ConceptDraw DIAGRAM software with samples, templates, and great collection of vector stencils to help the specialists in a field of networks and telecommunications, as well as other users to create Computer systems networking and Telecommunication network diagrams for various fields, to organize the work of call centers, to design the GPRS networks and GPS navigational systems, mobile, satellite and hybrid communication networks, to construct the mobile TV networks and wireless broadband networks.

Active Directory Diagram

Active Directory (AD) is a directory management service introduced by Microsoft Corporation for Windows domain networks. This service uses the Lightweight Directory Access Protocol (LDAP) and provides quick access to the included information about large structural units such as domains, organizational units, sites, and also about simple objects, such as users names with detailed information about them - contacts information, access rights, etc. Active Directory Diagram is a representation of the network structure in clear graphical format. It is a scheme of correlations of service components with preset degree of detailed elaboration. Active Directory Diagram makes the work of network administrators with Active Directory network structure more easy and convenient, allows plan and service the network quicker and more qualitatively. The help of ConceptDraw DIAGRAM software extended with Active Directory Diagrams solution from the Computer and Networks area is indispensable for easily and quickly creation the highly detailed Active Directory Diagrams.

Download ConceptDraw PRO
Free 21 Trial for Mac and PC

Buy Now