Entity relationship diagrams (ER diagrams) demystified

Entity relationship diagrams (ER diagrams) are a common tool used in database design. An ER diagram is a visual tool used to depict the relationships between entities in a database. These diagrams are used to help analysts and database administrators understand how data is related, and to make changes to the database without having to rebuild it from scratch.