by Dinesh Thakur Category: DBMS & RDBMS

There is no standard for representing data objects in ER diagrams. Each modeling methodology uses its own notation.

All notational styles represent entities as rectangular boxes and relationships as lines connecting boxes. Each style uses a special set of symbols to represent the cardinality of connection. The symbols used for the basic ER constructs are:

• Entities are represented by labeled rectangles. The label is the name of the entity. Entity names should be singular nouns.

• Attributes are represented by Ellipses.

• A solid line connecting two entities represents relationships. The name of the relationship is written above the line. Relationship names should be verbs and diamonds sign is used to represent relationship sets.

• Attributes, when included, are listed inside the entity rectangle. Attributes, which are identifiers, are underlined. Attribute names should be singular nouns.

• Multi-valued attributes are represented by double ellipses.

• Directed line is used to indicate one occurrence and undirected line is used to indicate many occurrences in a relation.

The symbols used to design an ER diagram are shown.  

                             ER Notation Symbol

                            Symbols used in E-R diagram

 The ER diagram showing the usage of different symbols

                            ER diagram for EMP PROJ database

If you liked this article, you can also catch us on facebook and Google+

Related Articles (You May Also Like)

{loadposition DBMS_And_RDBMS}

About Dinesh Thakur

Dinesh ThakurDinesh Thakur holds an B.SC (Computer Science), MCSE, MCDBA, CCNA, CCNP, A+, SCJP certifications. Dinesh authors the hugely popular blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps. For any type of query or something that you think is missing, please feel free to Contact us.

Search Content