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

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
	Entity	An entity is represented by a rectangle which contains the entity’s name.
	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.
	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
	Attribute	In the Chen notation, each attribute is represented by an oval containing atributte’s name
	Key attribute	An attribute that uniquely identifies a particular entity. The name of a key attribute is underscored.
	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.
	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
	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
	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.

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:

You don't need to be an artist to draw professional looking diagrams in a few minutes.
Large quantity of ready-to-use vector objects (entity relationship diagram symbols and meaning) makes your drawing diagrams quick and easy.
Great number of predesigned templates and samples give you the good start for your own diagrams.
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.
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.
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.
If you have any questions, our free of charge support is always ready to come to your aid.

TEN RELATED HOW TO's:

ConceptDraw Arrows10 Technology →

You want to connecting objects manually? You don't know how should diagramming software work? Is it possible to develop a diagram as quickly as the ideas come to you? Yes. The innovative ConceptDraw Arrows10 Technology - This is more than enough versatility to draw any type of diagram with any degree of complexity. You can start draw your diagram manually now.

Picture: ConceptDraw Arrows10 Technology

Cloud Computing Architecture Diagrams →

For documenting the Cloud Computing Architecture with a goal to facilitate the communication between stakeholders are successfully used the Cloud Computing Architecture diagrams. It is convenient and easy to draw various Cloud Computing Architecture diagrams in ConceptDraw DIAGRAM software with help of tools of the Cloud Computing Diagrams Solution from the Computer and Networks Area of ConceptDraw Solution Park.

Picture: Cloud Computing Architecture Diagrams

Related Solution:

Cloud Computing Diagrams

Computer Network. Computer and Network Examples →

Today, we can’t imagine our lives without daily data exchange. To call a set of devices that can be connected with each other a computer network, we must be sure that these devices support appropriate protocols to transfer data. A network consisting of personal devices is private, and global computer networks, for example, Internet, connects network nodes worldwide. This diagram represents a computer telecommunication network. The network depicted on the current diagram is featured with networked communication devices that provide data exchange through Internet. The network interconnections and connections between Internet nodes are settled using the cable media and wireless media. The nodes are the network workstations (terminals). and host computers. This network diagram was drawn with ConceptDraw DIAGRAM and its Computer and Networks Diagrams solution. Computer Network. <br>Computer and Network Examples *

Computer Network. <br>Computer and Network Examples *

Picture: Computer Network. Computer and Network Examples

Related Solution:

Computer Network Diagrams

Network Topologies →

When describing any computer network, we imagine a set of devices and nodes, arranged in some way. Talking about network structures, we should distinguish physical and logical network topologies, as physical topology is about devices location and logical topology illustrates data flow. In the same time, they do not have to match, and some devices, such as repeaters, may have a physical star layout, but a bus logical topology. There are two main types of computer network topologies: Physical topology that show the physical organization of a network - equipment and types of connections. Star network topology involves a set of devices that is connected to a single hub (router). Ring network topology means that, devices connected according this topology have two connections, connecting with nearby devices to make a loop. Bus network topology is the topology presented at the current diagram. It is similar to a ring topology. The difference is that data moves up and down a linear connection, copying itself where network equipment works as bus-stations along the way. This network topology can be used for small network, or when adding an extra device into a network.

Picture: Network Topologies

Related Solution:

Computer Network Diagrams

Example of DFD for Online Store (Data Flow Diagram) →

Structured-systems analysis and design method uses data flow diagrams to represent the process of data flowing through a system. Talking about this might be useless without a proper example of DFD for online store (Data Flow Diagram). This DFD example shows all the distinctness that a diagram can bring into a scattered data structure. Data flow diagrams are used to show how data is processed within some business processes. Making DFD is a common practice for business process modeling and analysis. This diagram represents the online store business flow. It describes inputs and outputs within online selling process and depicts the interactions between its participants. This DF diagram can be used by system analysts to create an overview of a business, to study and discover its inherent strengths and weak points.

Picture: Example of DFD for Online Store (Data Flow Diagram)

Related Solution:

Data Flow Diagrams (DFD)

Pyramid Chart Examples →

When we think of an hierarchy, we intuitively imagine a pyramid. Thus, a lot of management tools use pyramid charts as examples or illustrations of various documents or models. You can create any type of triangle diagram using ConceptDraw DIAGRAM. A triangle (pyramid) diagram is often used in marketing to show the data hierarchy. This pyramid diagram represents the Top Brand Model. It illustrate the model of rebranding strategy. It can be used by marketing agency dealing with rebranding strategies development. It’s critical for marketing diagrams to be both clear and eye catching. ConceptDraw Pyramid diagrams solution meet all these requirements and can be successfully applied for creating and presenting various marketing pyramidal diagrams. Pyramid Chart Examples *

Picture: Pyramid Chart Examples

Related Solution:

Workflow Diagrams

Pyramid Diagram →

The DIKW Pyramid refers loosely to a class of models for representing purported structural and/or functional relationships between data, information, knowledge, and wisdom. Pyramid Diagram *

Picture: Pyramid Diagram

Related Solution:

Pyramid Diagrams

Flowchart Maker →

Business graphic applications show a special knowledge representations and include many features for creating schematic pictures. These graphic tools are known as flowchart maker or flowchart maker software.

Picture: Flowchart Maker

Related Solution:

Flowcharts

How To Draw Building Plans →

Architectural drawing allows to show the location of a building or ensemble of buildings on the ground, indicating the cardinal points. For centuries, people had been studying architecture in universities to learn how to draw building plans and now everyone can do it easily just using appropriate software. While developing the building plan, its graphic part, you can display the part of the floor or the entire floor of a building with an indication of the exact location of the drawn premise. Small-sized apartments does not restrict the advanced interior design opportunities. Here is a detailed and precise floor plan of a pretty small apartment. A furniture objects are added to show possible interior of this home. This plan can be used to help somebody with a floor layout and furniture arrangement. Having this floor plan in a pocket while shopping would be useful to check if there is enough rooms for a new furniture.

Picture: How To Draw Building Plans

Related Solution:

Floor Plans

ConceptDraw

DIAGRAM 18

Buy it Now