Entity Relationship Diagram

Standard

Today we had a lecture on Entity Relationship Diagrams which are a diagram system that explain he relationship between the entities on a database.

I also found some other definitions online to be able to understand this concept further:

“An entity-relationship diagram (ERD) is a type of data modeling that shows a graphical representation of objects or concepts within an information system or organization and their relationship to one another.”

Source – What is entity relationship diagram? – Definition from WhatIs.com. 2015.What is entity relationship diagram? – Definition from WhatIs.com. [ONLINE] Available at: http://searchcrm.techtarget.com/definition/entity-relationship-diagram. [Accessed 23 February 2015].

The diagram below describes what each of the symbols are and how to use them in an ERD.

Here is a basic example of a real ERD as a purchase order application:

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