Made with
ConceptDraw
DIAGRAM 15

ERD Symbols and Meanings

Modeling your data using entity-relationship diagram (ERD) with Crow's Foot notation which is popular in Structured Systems Analysis, Barker's Notations, Design Methods and information engineering you need the software that is easy in use having all necessary elements for creating the needed flowcharts as well as their examples. You can find all essential ERD symbols and its meanings on our site with tutorials of how to use it and you can always use the already existing layouts for making your own diagrams in our Solution Park. Once you download our application with extension of hundreds of design elements you’ll find it simple to start using it straight away and you’ll be pleasantly surprised of how smart this tool for making the charts is.

Design elements Crow’s Foot notation

Crow's Foot notation is used in Barker's Notation, Structured Systems Analysis and Design Method (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 making possibility to describe a database in which in the tables data can be the point to data in other tables — for instance, your entry in the database could point to several entries.

To create an ERD, software engineers mainly turn to dedicated drawing software, which contain the full notation resources for their specific database design — ERD symbols and meanings. CS Odessa has released an all-inclusive Entity-Relationship Diagram (ERD) solution for their powerful drawing program, ConceptDraw DIAGRAM

ERD Symbols and Meanings

Example 1. Entity Relationship Diagram symbols and meaning

When you need to describe efficiently a database using the Crow’s Foot notation icons, ConceptDraw DIAGRAM gives you the ability to draw Entity Relationship diagram (ERD) fast and easy.


Design elements Chen's notation

The Chen's ERD notation is still used and is considered to present a more detailed way of representing entities and relationships.

Use also ConceptDraw DIAGRAM enhanced with powerful Entity-Relationship Diagram (ERD) solution to draw your own ER diagrams using Chen's notation icons.

Symbol Shape Name Symbol Description
Entities
ERD Symbols and Meaning - Entity Entity An entity is represented by a rectangle which contains the entity’s name.
ERD Symbols and Meaning - Weak Entity Weak Entity An entity that cannot be uniquely identified by its attributes alone. The existence of a weak entity is dependent upon another entity called the owner entity. The weak entity’s identifier is a combination of the identifier of the owner entity and the partial key of the weak entity.
ERD Symbols and Meaning - Associative Entity Associative Entity An entity used in a many-to-many relationship (represents an extra table). All relationships for the associative entity should be many
Attributes
ERD Symbols and Meaning - Attribute Attribute In the Chen notation, each attribute is represented by an oval containing atributte’s name
ERD Symbols and Meaning - Key attribute Key attribute An attribute that uniquely identifies a particular entity. The name of a key attribute is underscored.
ERD Symbols and Meaning - Multivalue attribute Multivalued attribute An attribute that can have many values (there are many distinct values entered for it in the same column of the table). Multivalued attribute is depicted by a dual oval.
ERD Symbols and Meaning - Derived attribute Derived attribute An attribute whose value is calculated (derived) from other attributes. The derived attribute may or may not be physically stored in the database. In the Chen notation, this attribute is represented by dashed oval.
Relationships
ERD Symbols and Meaning - Relationship Strong relationship A relationship where entity is existence-independent of other entities, and PK of Child doesn’t contain PK component of Parent Entity. A strong relationship is represented by a single rhombus
ERD Symbols and Meaning - Identifying Relationship Weak (identifying) relationship A relationship where Child entity is existence-dependent on parent, and PK of Child Entity contains PK component of Parent Entity. This relationship is represented by a double rhombus.

In addition to the vector stencil image libraries with full standardized Chen and Crow’s foot notations included, the Entity-Relationship Diagram (ERD) solution contains a number of ERD templates and samples added to the solution pack. They will help users quick start representing their own ideas.

Entity Relationship Diagram samples and templates in ConceptDraw STORE

Example 2. Entity Relationship Diagram samples and templates in ConceptDraw STORE

Try it today for saving your time sake not to look for something else once you have great chance to use this excellent product already now!

The following features make ConceptDraw DIAGRAM the best Entity Relationship Diagram ERD Software:

  1. You don't need to be an artist to draw professional looking diagrams in a few minutes.
  2. Large quantity of ready-to-use vector objects (entity relationship diagram symbols and meaning) makes your drawing diagrams quick and easy.
  3. Great number of predesigned templates and samples give you the good start for your own diagrams.
  4. ConceptDraw DIAGRAM provides you the possibility to use the grid, rules and guides. You can easily rotate, group, align, arrange the objects, use different fonts and colors to make your diagram exceptionally looking.
  5. All ConceptDraw DIAGRAM documents are vector graphic files and are available for reviewing, modifying, and converting to a variety of formats: image, HTML, PDF file, MS PowerPoint Presentation, Adobe Flash, MS Visio.
  6. Using ConceptDraw STORE you can navigate through ConceptDraw Solution Park, managing downloads and updates. You can access libraries, templates and samples directly from the ConceptDraw STORE.
  7. If you have any questions, our free of charge support is always ready to come to your aid.

TEN RELATED HOW TO's:

Structured Systems Analysis and Design Method. SSADM with ConceptDraw DIAGRAM →

A waterfall model describes software development process as a sequence of phases that flow downwards. SSADM is one of the implementations of waterfall method. It’s easier to learn about structured systems analysis and design method (SSADM) with ConceptDraw DIAGRAM because this software has appropriate tools for creating data flow diagrams. You can use all the three main techniques of SSADM method with special tools and predesigned templates. This data flow diagram illustrates the Structured Systems Analysis and Design Method. This method method considers analysis, projecting and documenting of information systems. Data flow models are the most important elements of SSADM and data flow diagrams are usually used for their description. It includes the analysis and description of a system as well as visualization of possible issues.Structured Systems Analysis and Design Method
Picture: Structured Systems Analysis and Design Method. SSADM with ConceptDraw DIAGRAM
Related Solution:

Flowchart design. Flowchart symbols, shapes, stencils and icons →

When thinking about data visualization, one of the first tools that comes to mind is a flowchart design. You can find flowchart symbols, shapes, stencils and icons easily on the Internet, but it might take time to systematize this information. Nevertheless, once you start flowcharting, you’ll love its simplicity and efficiency. This diagram consists from standard flowchart symbols, approved by ANSI (American National Standard Institute) for drawing flowcharts. A flowchart is a diagram that represents a step-by-step algorithm of any process, displaying the process stages as boxes that are connected with arrows. Flowchart design makes it clear and readable. Flowchart designed using ConceptDraw DIAGRAM flowchart software allows to make attractive and clear process presentation, it makes interpretation of the business process flow fresh and versatile. Great flowchart design view is a big advantage over the diagram created manually on a paper.Flowchart design
Picture: Flowchart design. Flowchart symbols, shapes, stencils and icons
Related Solution:

ER Diagram Styles →

When creating ER diagrams, you can apply different color ER diagram styles and also notation styles. ConceptDraw DIAGRAM enhanced with Entity-Relationship Diagram (ERD) Solution gives the ability to draw visual and attractive ER Diagrams using the style icons from Crow’s Foot notation and Chen's notation professionally designed and offered by ERD Chen's Notation and ERD Crow’s Foot Notation libraries.ER Diagram Styles *
Picture: ER Diagram Styles
Related Solution:

Process Flow Diagram →

A Process Flow Diagram (PFD) is a diagram which shows the relationships between the main components in a system. Process Flow Diagrams are widely used by engineers in chemical and process engineering, they allows to indicate the general flow of plant process streams and equipment, helps to design the petroleum refineries, petrochemical and chemical plants, natural gas processing plants, and many other industrial facilities. ConceptDraw DIAGRAM diagramming and vector drawing software extended with powerful tools of Flowcharts Solution from the "Diagrams" Area of ConceptDraw Solution Park is effective for drawing: Process Flow Diagram, Flow Process Diagram, Business Process Flow Diagrams.Process Flow Diagram *
Picture: Process Flow Diagram
Related Solution:

How To use House Electrical Plan Software →

Electrical plan is a document that is developed during the first stage of the building design. This scheme is composed of conventional images or symbols of components that operate by means of electric energy. To simplify the creation of these schemes you can use house electrical plan software, which will not require a long additional training to understand how to use it. You only need to install the necessary software ant it’s libraries and you’ll have one less problem during the building projection. Any building contains a number of electrical systems, including switches, fixtures, outlets and other lightening equipment. All these should be depicted in a building electrical plans and included to general building documentation. This home electrical plan displays electrical and telecommunication devices placed to a home floor plan. On the plan, each electrical device is referenced with the proper symbol. Electrical symbols are used for universal recognition of the building plan by different persons who will be working on the construction. Not all possible electric symbols used on a certain plan, so the symbols used in the current home plan are included to a legend. The electrical home plan may be added as a separate document to a complete set of building plans.House Electrical Plan Software
Picture: How To use House Electrical Plan Software
Related Solution:

Flowchart Software →

Describing a workflow or approval process can take hours and be too complicated, especially since there are options to do it quickly and vividly. Diagrams called flowcharts replace long paragraphs of boring text and represent information in a graphic way. You can draw one on paper or you can use flowchart software to do it quickly and scalable. This kind of software is easy to use and you don’t need any special skills to start using it. In addition, there are a lot examples and predesigned templates on the Internet. Flowcharts are a best tool for staking out a huge and complex process into some small readable parts. Surely, flowcharts can be drawn manually but the use of standard symbols that make it clear for a wide audience makes a software tool preferred for this task. The core for a successful flowchart is its simplicity. That is why often before beginning making flowchart through software, people draw the sketch on a piece of paper. Designing an effective flowchart means the combination of the data needed to be shown and the simplicity with which you depict it.Flowchart Software *
Picture: Flowchart Software
Related Solution:

Total Quality Management Definition →

Total quality management is the one known to be consisting of some organization-wide efforts put in order to install and to make some climate in which this organization can continuously improve its ability to deliver the high-quality products and services to its customers permanently.Total Quality Management Definition *
Picture: Total Quality Management Definition
Related Solution:

Building Drawing Software for Design Office Layout Plan →

Some organization hold offices for years and decades, or even build their own campuses. However, if it’s time for your organization to move to another building, drawing software for designing office layout plan would come in handy. With such software you can save a lot of time and create a new layout or try to save old layout in a new building. This office layout plan is an example of a typical office furniture and equipment arrangement. This drawing provides a graphic view of the office area and its facilities including furniture and office equipment. It can be used as template which represent, desks, files, and other pieces of equipment that can be re-arranged according the certain requirements to office space and facilities. The vector graphic objects that represent various office layout elements such as special office furniture and equipment can help you to shape a number of creative ideas and develop your office layout plan.Building Drawing Software for Design Office Layout Plan
Picture: Building Drawing Software for Design Office Layout Plan
Related Solution:

How to Design Landscape →

How to design landscape? You can draw it by hand on a sheet of paper, but for this you need to know the bases of the perspective, you need to have good artistic abilities and to know how to depict the natural elements. But it is much easier and convenient to use the modern ConceptDraw DIAGRAM diagramming and vector drawing software extended with Landscape & Garden Solution from the Building Plans Area.How to Design Landscape *
Picture: How to Design Landscape
Related Solution:
ConceptDraw
DIAGRAM 15