An entity relationship (ER) diagram is a visual way to show how information is organized in a database.

A well-designed data model is the cornerstone of effective operational systems and BI and analytics applications that deliver business value by transforming enterprise data into a useful information ...