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 DIAGRAM software with templates, samples and libraries of vector stencils from drawing the ER-diagrams by Chen's and crow’s foot notations.
"In software engineering, an entity–relationship model (ER model) is a data model for describing a database in an abstract way.Chen's notation for entity–relationship modeling uses rectangles to represent entity sets, and diamonds to represent relationships appropriate for first-class objects: they can have attributes and relationships of their own. If an entity set participates in a relationship set, they are connected with a line.
Attributes are drawn as ovals and are connected with a line to exactly one entity or relationship set." [Entity–relationship model. Wikipedia]
This sample Chen's ER-diagram illustrates the structure of a typical MMORP game.
"Massively multiplayer online role-playing game (MMORPG) mixes the genres of role-playing video games and Massively multiplayer online games, possibly in the form of web browser-based games, in which a very large number of players interact with one another within a virtual world.
As in all RPGs, players assume the role of a character (often in a fantasy world or science-fiction world) and take control over many of that character's actions. MMORPGs are distinguished from single-player or small multi-player online RPGs by the number of players, and by the game's persistent world (usually hosted by the game's publisher), which continues to exist and evolve while the player is offline and away from the game." [Massively multiplayer online role-playing game. Wikipedia]
This ERD example was redrawn using the ConceptDraw PRO diagramming and vector drawing software from the Wikipedia file: ER Diagram MMORPG.png. [en.wikipedia.org/ wiki/ File:ER_ Diagram_ MMORPG.png]
This file is licensed under the Creative Commons Attribution-Share Alike 3.0 Unported license. [creativecommons.org/ licenses/ by-sa/ 3.0/ deed.en]
This Chen's ERD example is included in the Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park.
Chen's ERD
Chen's ERD, weak key attribute, weak entity, relationship, multivalue attribute, key attribute, identifying relationship, entity, derived attribute, attribute,
"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,

ConceptDraw DIAGRAM Database Modeling Software

ConceptDraw DIAGRAM is a very easy-to-use and intuitive database design tool which can save you hundreds of work hours. See database diagram samples created with ConceptDraw DIAGRAM database modeling database diagram software.

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

fishbone diagram, Ishikawa diagram, cause and effect analysis
Fishbone Diagrams solution extends ConceptDraw DIAGRAM software with templates, samples and library of vector stencils for drawing the Ishikawa diagrams for cause and effect analysis.
"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 18 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,

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.

ConceptDraw Solution Park ConceptDraw Solution Park

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

Software development with ConceptDraw DIAGRAM

Modern software development requires creation of large amount of graphic documentation, these are the diagrams describing the work of applications in various notations and cuts, also GUI design and documentation on project management. ConceptDraw DIAGRAM technical and business graphics application possesses powerful tools for software development and designing technical documentation for object-oriented projects. Solutions included to the Software Development area of ConceptDraw Solution Park provide the specialists with possibility easily and quickly create graphic documentation. They deliver effective help in drawing thanks to the included package of templates, samples, examples, and libraries with numerous ready-to-use vector objects that allow easily design class hierarchies, object hierarchies, visual object-oriented designs, flowcharts, GUI designs, database designs, visualize the data with use of the most popular notations, including the UML and Booch notations, easy manage the development projects, automate projection and development.

audio video diagram, hook up diagram Audio and Video Connectors

audio video diagram, hook up diagram
Audio and video connectors solution extends ConceptDraw DIAGRAM software with templates, samples and library of vector stencils for drawing audio and video hook up diagrams.

event-driven process chain diagram, EPC diagram, process chain flowchart Event-driven Process Chain Diagrams

event-driven process chain diagram, EPC diagram, process chain flowchart
Event-Driven Process Chain Diagrams solution extends ConceptDraw DIAGRAM functionality with event driven process chain templates, samples of EPC engineering and modeling the business processes, and a vector shape library for drawing the EPC diagrams and EPC flowcharts of any complexity. It is one of EPC IT solutions that assist the marketing experts, business specialists, engineers, educators and researchers in resources planning and improving the business processes using the EPC flowchart or EPC diagram. Use the EPC solutions tools to construct the chain of events and functions, to illustrate the structure of a business process control flow, to describe people and tasks for execution the business processes, to identify the inefficient businesses processes and measures required to make them efficient.