Products Solutions Samples Buy
✕
This site uses cookies. By continuing to browse the ConceptDraw site you are agreeing to our Use of Site Cookies.
HelpDesk

How to Create an ERD Diagram

Entity-Relationship Diagram (ERD) using Chen's notation
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.
"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

telecommunication networking, networking and telecommunications, telecommunications network, computer systems networking and telecommunications Telecommunication Network Diagrams

telecommunication networking, networking and telecommunications, telecommunications network, computer systems networking and telecommunications
Telecommunication Network Diagrams solution extends ConceptDraw PRO 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.

BPMN standard, Business Process Diagram, BPMN, Business Process Business Process Diagrams

BPMN standard, Business Process Diagram, BPMN, Business Process
Business Process Diagrams solution extends the ConceptDraw PRO BPM software with RapidDraw interface, templates, samples and numerous libraries based on the BPMN 1.2 and BPMN 2.0 standards, which give you the possibility to visualize equally easy simple and complex processes, to design business models, to quickly develop and document in details any business processes on the stages of project’s planning and implementation.

gym layout, fitness center floor plan, fitness center layout Gym and Spa Area Plans

gym layout, fitness center floor plan, fitness center layout
Effective promotion of spa complexes, spa resorts, fitness centers, and gym rooms requires professional, detailed, illustrative and attractive spa floor plan, gym floor plan, and other fitness plans designs. They are designed to display common plans of premises, design, Spa furniture, gym and exercise equipment layout, and pools location.

systems engineering, sysml SYSML

systems engineering, sysml
The SysML solution helps to present diagrams using Systems Modeling Language; a perfect tool for system engineering.

mind map, Conference Calls, Remote Learning, mindmapping, project, Skype presentation, Skype, remote presentation, international call, team, workgroup, screen sharing, screen share, Skype screen sharing, PowerPoint, MS Word, MindJet, education, remote eLearning for Skype

mind map, Conference Calls, Remote Learning, mindmapping, project, Skype presentation, Skype, remote presentation, international call, team, workgroup, screen sharing, screen share, Skype screen sharing, PowerPoint, MS Word, MindJet, education, remote
This solution extends ConceptDraw MINDMAP software with the ability to prepare and run remote learning sessions by using Skype

business processes, business management, plan projects Business Package for Management

business processes, business management, plan projects
Package intended for professional who designing and documenting business processes, preparing business reports, plan projects and manage projects, manage organizational changes, prepare operational instructions, supervising specific department of an organization, workout customer service processes and prepare trainings for customer service personal, carry out a variety of duties to organize business workflow.