Get Free Trial

Entity Relationship Diagram Symbols

Entity Relationship Diagram Symbols

The semantic modeling method nowadays is successfully applied in database structure design. It is effective method of modeling the data structures, which is based on the meaning of these data. As a tool of semantic modeling, there are used different types of Entity-Relationship Diagrams. Entity Relationship Diagram (ERD) is applied to visually and clearly represent a structure of a business database. The main components of ERDs are: entity, relation and attributes. An entity is a class of similar objects in the model, each entity is depicted in the form of rectangle and has the name expressed by a noun. Relation is shown in the form of non-directional line that connects two entities. There are several notation styles used for ERDs: information engineering style, Chen style, Bachman style, Martin Style. The Entity Relationship Diagram symbols used for professional ERD drawing are predesigned by professionals and collected in the libraries of the Entity-Relationship Diagram (ERD) solution for ConceptDraw PRO software. Read more
"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.
Cardinality constraints are expressed as follows:
- a double line indicates a participation constraint, totality or surjectivity: all entities in the entity set must participate in at least one relationship in the relationship set;
- an arrow from entity set to relationship set indicates a key constraint, i.e. injectivity: each entity of the entity set can participate in at most one relationship in the relationship set;
- a thick line indicates both, i.e. bijectivity: each entity in the entity set is involved in exactly one relationship.
- an underlined name of an attribute indicates that it is a key: two different entities or relationships with this attribute always have different values for this attribute.
Attributes are often omitted as they can clutter up a diagram; other diagram techniques often list entity attributes within the rectangles drawn for entity sets." [Entity–relationship model. Wikipedia]
The vector stencils library ERD, Chen's notation contains 13 symbols for drawing entity-relatinship diagrams using the ConceptDraw PRO diagramming and vector drawing software.
The example "Design elements - ER diagram (Chen notation)" is included in the Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park. Read more
Chen's ERD
Chen's ERD, week key attribute, weak entity, relationship, multivalue attribute, key attribute, identifying relationship, entity, derived attribute, attribute, associative entity,

Databases Access Objects Model with ConceptDraw PRO

ConceptDraw Basic gives the opportunity of interaction with any ODBC-compatible databases. For this the Database Access Objects Model is provided. All calls to the database are made by certain methods of objects of this model. Read more

Business Diagram Software

When managing the projects, people, or networks, there are daily designed and used different types of Business diagrams, so the powerful drawing software will be very useful for this. ConceptDraw PRO with large quantity of business solutions will meet your needs and will help you convey your ideas successful and rapidly, no matter are you professional or beginner. It is the best choice for business specialists and technical professionals who need quickly and easily explore, visualize, and communicate information. ConceptDraw PRO business diagram software is the most powerful business software and relational charting software. Create advanced, completely customizable Business Process Diagrams, Business Flow Charts, Work Flow Diagrams, Organizational Charts, Audit diagrams, Marketing diagrams, Value Stream Maps, TQM diagrams, ERD diagrams, EPC diagrams, Cause and Effect diagrams, Infographics, Dashboards, and other Relational business diagrams from your data using the powerful drawing tools of ConceptDraw Solution Park. Read more

flow chart software, flowchart maker, flowchart, flow chart Flowcharts

The Flowcharts Solution for ConceptDraw PRO v10 is a comprehensive set of examples and samples in several different color themes for professionals that need to graphically represent a process. Solution value is added by basic flow chart template and shapes' library of Flowchart notation. ConceptDraw PRO flow chart creator lets one depict a processes of any complexity and length, as well design of the flowchart either vertically or horizontally. Read more
flow chart software, flowchart maker, flowchart, flow chart

spatial infographics, spatial data visualization Spatial Infographics

Spatial infographics solution extends ConceptDraw PRO software with infographic samples, map templates and vector stencils libraries with design elements for drawing spatial information graphics. Read more
spatial infographics, spatial data visualization