An entity relationship (ER) diagram is a visual way to show how information is organized in a database. It lets people see the main entities, the information stored about them and the relationships ...