Products Solutions Samples Buy
✕
This site uses cookies. By continuing to browse the ConceptDraw site you are agreeing to our Use of Site Cookies.
"An ER model is an abstract way of describing a database. In the case of a relational database, which stores data in tables, some of the data in these tables point to data in other tables - for instance, your entry in the database could point to several entries for each of the phone numbers that are yours. The ER model would say that you are an entity, and each phone number is an entity, and the relationship between you and the phone numbers is 'has a phone number'. Diagrams created to design these entities and relationships are called entity–relationship diagrams or ER diagrams.
Using the three schema approach to software engineering, there are three levels of ER models that may be developed. ...
Conceptual data model ... is the highest level ER model in that it contains the least granular detail but establishes the overall scope of what is to be included within the model set.
Logical ER model ... contains more detail than the conceptual ER model. In addition to master data entities, operational and transactional data entities are now defined.
The physical ER model is normally developed to be instantiated as a database. Therefore, each physical ER model must contain enough detail to produce a database and each physical ER model is technology dependent since each database management system is somewhat different.
Physical model ... is normally forward engineered to instantiate the structural metadata into a database management system as relational database objects such as database tables, database indexes such as unique key indexes, and database constraints such as a foreign key constraint or a commonality constraint." [Entity–relationship model. Wikipedia]
This crow's foot entity-relationship diagram (ERD) example "Educational data base" was created using the ConceptDraw PRO diagramming and vector drawing software extended with the Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park.
ERD
ERD, entity,
Used Solutions

entity-relationship diagram, ER-diagram, database ERD Entity-Relationship Diagram (ERD)

entity-relationship diagram, ER-diagram, database ERD
An Entity-Relationship Diagram (ERD) is a visual presentation of entities and relationships. That type of diagrams is often used in the semi-structured or unstructured data in databases and information systems. At first glance ERD is similar to a flowch

Software Diagrams

Design and document development of projects using a wide range of pre-drawn shapes and smart connectors. Develop visualization solutions with the help of the built-in scripting language.
ConceptDraw DIAGRAM is a perfect tool for Designing and planning tasks; Developing Visualization Solutions; Project Planning (Gantt Charts, Timelines, Project Schedules).

Components of ER Diagram

ConceptDraw gives the ability to draw ER diagram (ERD) for visual describing database using the entity relationship symbols, work flow shapes, entity relationship stencils. Entity-Relationship model making possibility to describe a database using the components of ER Diagram in which in the tables data can be the point to data in other tables - for instance, your entry in the database could point to several entries.

data flow diagram, DFD templates Data Flow Diagrams (DFD)

data flow diagram, DFD templates
Data Flow Diagrams solution extends ConceptDraw DIAGRAM software with templates, samples and libraries of vector stencils for drawing the data flow diagrams (DFD).

Applications

ConceptDraw DIAGRAM is a multipurpose software for business and technical drawing, diagramming, visual documentating.
To understand what practical benefits you can reach with ConceptDraw DIAGRAM take a look at this range of articles. They describe the versatile possibilities of ConceptDraw DIAGRAM expedient applications.

Entity Relationship Diagram Examples

Entity Relationship Diagram Examples
Create an Entity-Relationship (ER) model is to visually represent the structure of a business database, where data equates to entities (or objects) that are linked by defined relationships expressing dependencies and requirements. By nature it is an abstract visualization, the first step in the design process towards creating a logical and functional database.

ConceptDraw DIAGRAM diagramming and vector drawing software gives the ability to describe a database using the Entity-Relationship model. Entity-Relationship Diagram(ERD) solution from the Software Development area supplies the ConceptDraw DIAGRAM with icons advocated by Chen's and Crow’s Foot notation that can be used when describing a database.
How to Build an Entity Relationship Diagram (ERD)
How to Build an Entity Relationship Diagram (ERD)

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.

Software development with ConceptDraw DIAGRAM

ConceptDraw possesses powerful tools for designing of technical documentation for object-oriented projects. The libraries included in the package allow to easily draw class hierarchies, object hierarchies and diagrams of data flows with the use of the most popular notations, including UML and Booch notations.

Cross-Functional Flowchart - The easiest way to draw crossfunctional

ConceptDraw DIAGRAM diagramming software provides vector shapes and connector tools for quick and easy drawing diagrams for business, technology, science and education.
Use ConceptDraw DIAGRAM enhanced with solutions from ConceptDraw Solution Park to create diagrams to present and explain structures, process flows, logical relationships, networks, design schemes and other visually organized information and knowledge.