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

The end goal of database design is to be able to transform a logical data model into an actual physical database. A logical data model is required before you can even begin to design a physical ...