Entity-Relationship Diagram

“An entity-relationship diagram is a visual representation of an information system. That shows a relationship between people, objects, places, concepts or events within that system.” – Margaret Rouse

This data modelling technique is commonly used within businesses that helps structure a process.

There are 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. (2014, Rouse)

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. (2014, Rouse)
  • 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. (2014, Rouse)
  • Many-to-many (M:N). For example, at a company where all call centre agents work with multiple customers, each agent is associated with multiple customers, and multiple customers might also be associated with multiple agents. (2014, Rouse)

Reference: 

Rouse, Margaret. ‘What Is Entity Relationship Diagram? – Definition From Whatis.Com’.SearchCRM. N.p., 2014. Web. 19 Feb. 2015.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s