Entity-Relationship Diagram (ERD)

Entity-Relationship Diagram (ERD) solution extends ConceptDraw DIAGRAM software with templates, samples and libraries of vector stencils from drawing the ER-diagrams by Chen's and crow’s foot notations.

Crow's foot ERD - Educational data base

"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

Used Solutions

AREA_SOFTWARE_DEVELOPMENT >

Crow’s Foot Notation

Interactive Voice Response Diagrams

Interactive Voice Response Diagrams solution extends ConceptDraw DIAGRAM software with samples, templates and libraries of ready-to-use vector stencils that help create Interactive Voice Response (IVR) diagrams illustrating in details a work of interactive voice response system, the IVR system’s logical and physical structure, Voice-over-Internet Protocol (VoIP) diagrams, and Action VoIP diagrams with representing voice actions on them, to visualize how the computers interact with callers through voice recognition and dual-tone multi-frequency signaling (DTMF) keypad inputs.

Football

The Football Solution extends ConceptDraw DIAGRAM 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

Enterprise Architecture Diagrams

Enterprise Architecture Diagrams solution extends ConceptDraw DIAGRAM software with templates, samples and library of vector stencils for drawing the diagrams of enterprise architecture models.

Applications

ConceptDraw DIAGRAM is a multipurpose software from ConceptDraw suite intended for diagramming, business and technical drawing, and visual documenting. You can reach a lot of practical benefits from the use of ConceptDraw DIAGRAM. The list of ConceptDraw DIAGRAM applications and versatile possibilities is extremely great. Among them network and system diagramming, business diagramming, Cisco network design, network visualization, software and database design, software development, business flowcharting, data flow design, databases modeling and visualization, business processes modeling, business drawing, technical drawing, GUI prototyping, Organizational charts construction, business processes fixing, web site planning and design, Internet solutions design, information architecture design, UML modeling, ER diagrams design, home and landscape design, and a lot of other applications. ConceptDraw DIAGRAM offers the users a beneficial collaboration, compatibility with MS Visio and many other popular programs, including other products from ConceptDraw suite.

Metro Map

Metro Map solution extends ConceptDraw DIAGRAM 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.

Wireless Networks

The Wireless Networks Solution extends ConceptDraw DIAGRAM software with professional diagramming tools, set of wireless network diagram templates and samples, comprehensive library of wireless communications and WLAN objects to help network engineers and designers efficiently design and create Wireless network diagrams that illustrate wireless networks of any speed and complexity, and help to identify all required equipment for construction and updating wireless networks, and calculating their costs.

Fault Tree Analysis Diagrams

This solution extends ConceptDraw DIAGRAM.5 or later with templates, fault tree analysis example, samples and a library of vector design elements for drawing FTA diagrams (or negative analytical trees), cause and effect diagrams and fault tree diagrams.

Data modeling with ConceptDraw DIAGRAM

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

IDEF1X Standard

Use Case Diagrams technology. IDEF1x standard - for work with relational data bases. IDEF1x standard is meant for constructing of conceptual schemes which represent the structure of data in the context of the concerned system, for example, a commercial organization.