This site uses cookies. By continuing to browse the ConceptDraw site you are agreeing to our Use of Site Cookies.

How to Create an ERD Diagram


How to Create an ERD Diagram

ERD (entity relationship diagram) is used to show the logical structure of databases. It represents the interrelationships between components of database (entities). Entity relationship diagrams are a widely used in software engineering. Using ERD software engineers can control the every aspect of database development. ER diagram can be used as guide for testing and communicating before the release of software product. ERD displays data as entities that are connected with connections that show the relationships between entities. There is some ERD notations used by data bases developers for representing the relationships between the data objects. ConceptDraw PRO and its ERD solution allow you to build ERD diagram of any notation. Read more

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

entity-relationship diagram, ER-diagram, database ERD
Entity-Relationship Diagram (ERD) solution extends ConceptDraw PRO software with templates, samples and libraries of vector stencils from drawing the ER-diagrams by Chen's and crow’s foot notations. Read more
"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. Read more
ERD, entity,

Data structure diagram with ConceptDraw PRO

Data structure diagram (DSD) is intended for description of conceptual models of data (concepts and connections between them) in the graphic format for more obviousness. Data structure diagram includes entities description, connections between them and obligatory conditions and requirements which connect them. Create Data structure diagram with ConceptDraw PRO. Read more

Cubetto Flowchart

Create flowcharts in a breath with Cubetto Flow on your iPad and iPhone wherever you are. Read more

How to Create a Concept Map in ConceptDraw PRO

Graphical technique of knowledge representation in a form of structured networks of concepts (ideas) is called concept mapping. Concept network consists of shapes that represent concepts and connectors representing relationships between concepts. The difference between mind maps and concept maps is that a mind map has only one object depicting a main idea , while a concept map may have several. Concept mapping is used to structure ideas, to communicate complex system of knowledge, to help learning process, etc. ConceptDraw PRO allows you to draw concept maps using the Concept Map solution. Read more

Data modeling with ConceptDraw PRO

Data modelling will help you to study and analyze business processes in your organization for optimization and increase of effectiveness and production. Read more

ConceptDraw Solution Park ConceptDraw Solution Park

ConceptDraw Solution Park
ConceptDraw Solution Park collects graphic extensions, examples and learning materials Read more