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

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.
"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,

software development, software engineering Software Development Area

software development, software engineering
Solutions from the Software Development Area of ConceptDraw Solution Park collect templates, samples and libraries of vector stencils for drawing the software engineering diagrams and user interface design prototypes.
"Crow's Foot notation is used in Barker's Notation, SSADM and Information Engineering. Crow's Foot diagrams represent entities as boxes, and relationships as lines between the boxes. Different shapes at the ends of these lines represent the cardinality of the relationship." [Entity–relationship model. Wikipedia]
The vector stencils library ERD, crow's foot notation contains 17 symbols for creating the ER-diagrams using the ConceptDraw PRO diagramming nd vector drawing software.
The example"Design elements - ERD solution (crow's foot notation)" is included in the Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park.
Crow's foot ERD
Crow's foot ERD, entity,

fishbone diagram, Ishikawa diagram, cause and effect analysis Fishbone Diagram

fishbone diagram, Ishikawa diagram, cause and effect analysis
Fishbone Diagrams solution extends ConceptDraw PRO software with templates, samples and library of vector stencils for drawing the Ishikawa diagrams for cause and effect analysis.

computer networks Computer and Networks Area

computer networks
The solutions from Computer and Networks Area of ConceptDraw Solution Park collect samples, templates and vector stencils libraries for drawing computer and network diagrams, schemes and technical drawings.

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.

UML diagram, UML modeling Rapid UML

UML diagram, UML modeling
Rapid UML solution extends ConceptDraw PRO software with templates, samples and libraries of vector stencils for quick drawing the UML diagrams using Rapid Draw technology.

value stream map, VSM Value Stream Mapping

value stream map, VSM
Value stream mapping solution extends ConceptDraw PRO software with templates, samples and vector stencils for drawing the Value Stream Maps (VSM) in lean manufacturing practice.

seven management and planning tools Seven Management and Planning Tools

seven management and planning tools
Seven Management and Planning Tools solution extends ConceptDraw PRO and ConceptDraw MINDMAP with features, templates, samples and libraries of vector stencils for drawing management mind maps and diagrams.

football, american football, football field, american football field, football field dimensions, offense, defense, football plays, football diagram Football

football, american football, football field, american football field, football field dimensions, offense, defense, football plays, football diagram
The Football Solution extends ConceptDraw PRO v9.5 (or later) software with samples, templates, and libraries of vector objects for drawing football (American) diagrams, plays schemas, and illustrations. It can be used to make professional looking documen

metro maps, subway map, mta subway map, metro train map, metro path map, subway train map Metro Map

metro maps, subway map, mta subway map, metro train map, metro path map, subway train map
Metro Map solution extends ConceptDraw PRO software with templates, samples and library of vector stencils for drawing the metro maps, route maps, bus and other transport schemes, or design tube-style infographics.

biological image,  biology drawing,  biology symbols Biology

biological image,  biology drawing,  biology symbols
Biology solution extends ConceptDraw PRO software with samples, templates and libraries containing biological vector symbols, to help you create scientific and educational designs in the field of biology.

basketball, basketball court, football field, baskettball court dimensions, offense, defense, bsketball plays, basketball diagram Basketball

basketball, basketball court, football field, baskettball court dimensions, offense, defense, bsketball plays, basketball diagram
The Basketball Solution extends ConceptDraw PRO v9.5 (or later) software with samples, templates, and libraries of vector objects for drawing basketball diagrams, plays schemas, and illustrations. It can be used to make professional looking documents, pre