Definition

entity relationship diagram

Contributor(s): Laura Aberle

An entity-relationship diagram (ERD) is a graphical representation of an information system that shows the relationship between people, objects, places, concepts or events within that system. An ERD is a data modeling technique that can help define business processes and can be used as the foundation for a relational database.

While useful for organizing data that can be represented by a relational structure, an entity-relationship diagram can't sufficiently represent semi-structured or unstructured data, and an ERD is unlikely to be helpful on its own in integrating data into a pre-existing information system.

Three main components of an ERD are the entities, which are objects or concepts that can have data stored about them, the relationship between those entities, and the cardinality, which defines that relationship in terms of numbers.

For example, an ER diagram representing the information system for a company's sales department might start with graphical representations of entities such as the sales representative, the customer, the customer's address, the customer's order, the product and the warehouse. (See diagram) Then lines or other symbols can be used to represent the relationship between entities, and text can be used to label the relationships.

ER diagram example

Finally, cardinality notations define the attributes of the relationship between the entities. Cardinalities can denote that an entity is optional (for example, a sales rep could have no customers or could have many) or mandatory (for example, the must be at least one product listed in an order.)

The three main cardinal relationships are:

  • One-to-one (1:1). For example, if each customer in a database is associated with one mailing address.
  • One-to-many (1:M). For example, a single customer might place an order for multiple products. The customer is associated with multiple entities, but all those entities have a single connection back to the same customer.
  • Many-to-many (M:N). For example, at a company where all call center agents work with multiple customers, each agent is associated with multiple customers, and multiple customers might also be associated with multiple agents.

While there are tools to help draw entity-relationship diagrams, such as CASE (computer-aided software engineering) tools, some relational database management systems also have design capabilities built in.

This was last updated in October 2014

Continue Reading About entity relationship diagram

Dig Deeper on Data quality management in CRM

PRO+

Content

Find more PRO+ content and other member only offers, here.

Join the conversation

5 comments

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

Very much helpful..
Cancel
What are the limitations of an entity-relationship diagram? What other data modeling techniques have become more useful?
Cancel
thanks for the best information about ERD
Cancel
Somebody once told me the world is gonna roll me, I ain't the sharpest tool in the shed. She was looking kinda dumb with her finger and her thumb in the shape of an "L" on her forehead. Well the years start coming and they dont stop coming, fed to the rules and I hit the ground running, didnt make sense just to live for fun, your brain gets smart but your head gets dumb. So much to do so much to see, so whats wrong with taking the backstreets, you'll never know if you dont go, you'll never shine if you dont glow.

Hey now, youre a rockstar, get teh show on, get paid.
Hey now youre and allstar, get the game on, get laid.

Not all that glitters is gold, only shooting stars break the mold.
Cancel
Hi every one!
My project is Ultimate SMS blocker but i dont have idea how to draw ERD. kindly any one help me to draw ERD
Cancel

-ADS BY GOOGLE

File Extensions and File Formats

SearchBusinessAnalytics

SearchDataManagement

SearchSAP

SearchOracle

SearchAWS

SearchContentManagement

SearchSalesforce

Close