This site uses cookies. By continuing to browse the ConceptDraw site you are agreeing to our Use of Site Cookies.

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. 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!

Entity Relationship Diagram Symbols. Professional ERD Drawing

Very commonly used in the database structure design, the sematic modelling method is one the ways of describing data structures as well as its modelling, based on the meaning of this data. ER-model based diagrams (ERD) consist of these main components: relation, entity and attributes. To be able to create such diagram, you have to mention the entities with their names presented in a form of a rectangle and the relations in a way of non-directional line connecting two entities. To help you to create this chart, we developed ConceptDraw STORE product full of libraries with vector elements you can use for your flowchart. Also we provide you with Solutions section on this site where you can find the numerous stencil libraries, samples and examples to simplify your work with software called ConceptDraw DIAGRAM which is the only one offering that many symbols and templates for making professionally looking smart and mature diagrams.
Data modeling
Data modeling, subtype, supertype, Express-G notation, relationship pointer, entity, Express-G notation, cardinality, Express-G notation, BOOKS
This sample shows EXPRESS-G notation attribute symbols. This example was drawn on the base of the Wikimedia Commons file: A 02B Attribute symbols.svg.
Chen's ERD
Chen's ERD, week key attribute, weak entity, relationship, multivalue attribute, key attribute, identifying relationship, entity, derived attribute, attribute, associative entity, BOOKS
an underlined name of an attribute indicates that it is a key: two different entities or diagram techniques often list entity attributes within the rectangles drawn for  
Entity
Entity, entity, BOOKS
Attribute . Attribute , attribute ,. Key attribute . Key attribute , key attribute ,. Weak key attribute . Weak key attribute , weak key attribute ,. Derived attribute .
Entity
Entity, entity, BOOKS
Multivalue attribute . Multivalue attribute . Multivalue attribute , multivalue attribute , · ERD, Chen's notation - Vector stencils library · Entity · Weak entity 
Entity
Entity, entity, BOOKS
Derived attribute . Derived attribute . Derived attribute , derived attribute , · ERD, Chen's notation - Vector stencils library · Entity · Weak entity · Relationship 
Entity
Entity, entity, BOOKS
Key attribute . Key attribute . Key attribute , key attribute , · ERD, Chen's notation - Vector stencils library · Entity · Weak entity · Relationship · Identifying 
Entity
Entity, entity, BOOKS
Weak key attribute . Weak key attribute . Weak key attribute , weak key attribute , · ERD, Chen's notation - Vector stencils library · Entity · Weak entity · Relationship  

Draw entity relationship diagrams (ER diagrams) easily with ER

Representing relationships between entities in Entity-Relationship diagrams in a way of structured flowchart, the best decision would be to make sure you illustrate the database correctly using different shapes, such as rectangles and ovals, for putting the entities’ names in and draw all the arrows as well in terms of connecting all of them. Our product ConceptDraw DIAGRAM allows you to create diagrams, including the entity-relationship one, in short terms using our solution called Entity-Relationship Diagram, so you can have it as a draft to be able to draw your own great professionally looking flowchart using our samples as simply basic for your work. To draw ERDs for different database systems is simpler than ever before, as our solution can be used to diagram ODBC-compatible databases, such as MS SQL, Oracle, InterBase, MS Access, MySQL, Firebird and many other to make sure it can be truly helpful in your work with any of them.
DynamoDB
DynamoDB, DynamoDB, BOOKS
AWS Database - Vector stencils library · DynamoDB · Table · Item · Items · Attribute · Attributes · Global secondary index · Amazon RDS · RDS DB instance · RDS 
Object-role model
Object-role model, uniqueness constraint, role connector, mandatory constraint, entity, ORM diagrams, object-role modeling, binary predicate, binary association, BOOKS
Attribute -free. ORM is attribute -free: unlike models in the entity–relationship (ER) and Unified Modeling Language (UML) methods, ORM treats all elementary 
Chen's ERD
Chen's ERD, weak key attribute, weak entity, relationship, multivalue attribute, key attribute, identifying relationship, entity, derived attribute, attribute, BOOKS
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 

Design Element: Chen. Professional ERD Drawing

Entity-relationship diagrams or ERD are very well known for representing some data models as well as the relationships and the connections between them. Chen notation was first introduced by Chen and then developed by Barker and it provides lots of data modelling tool as, for example, decomposition charts or attribute diagrams as well as entity-relationship diagrams. The name of the diagram itself explains the reason of creating such type of diagram as it shows the relationship between the different entities which are the real or sometimes abstract objects, such as ideas, people, events, items, conditions, etc. Having ConceptDraw DIAGRAM on your desktop means having lots of design elements for creating any flowchart, charts, diagrams, schemes or plans with help of lots of templates as well as different examples of already existing diagrams, including the ERD. Downloading this application means helping yourself in drawing anything you need in a very short term and having the final result looking very professional.
UML object diagram symbols
UML object diagram symbols, object, named instance, link, instance specification, generalization, dependency, composition, aggregation, BOOKS
Each slot corresponds to a single attribute or feature, and may include a value for that if any, are included below the names, in a separate attribute compartment.

ConceptDraw DIAGRAM : Able to Leap Tall Buildings in a Single

ConceptDraw DIAGRAM : Able to Leap Tall Buildings in a Single Bound
Entity
Entity, entity, BOOKS
Entity · Weak entity · Relationship · Identifying Relationship · Associative Entity · Participation · Optional participation · Recursive Relationship · Attribute · Key 
DynamoDB
DynamoDB, DynamoDB, BOOKS
Attribute . Attribute , attribute ,. Attributes . Attributes , attributes ,. Global secondary index. Global secondary index, global secondary index,. Amazon RDS.