What is an Entity Relationship Diagram (ERD)?

An ERD is a high-level overview of the design of a database management system. An ERD is widely used by business analysts when making a business case to explain the justification for implementing a particular database management system. This is done to improve business intelligence within the company.

An ERD typically includes a diagram of the Entities, Attributes, and the Relationships between them. A popular tool for creating the diagram is Microsoft Visio. Visio includes data notation tools and connectors to make creating entities and relationships easy. I prefer Visio 2010 versus 2013. I guess I'm just used to it. 

You simply drag and drop the tool onto the drawing board and type in the name, attributes and what type of relationship it is (1:1, 1:M, M:M) and Visio does the rest.

I was tasked with the assignment in my grad school class to create a simple ERD for a company that sells widgets online and needs to implement a database management system to help improve their data collection and analysis. So, my solution and explanation will be in a future post.

Add comment