An Entity Relationship Diagram is a visual representation of how several entities exist in a system and their relationship with one another. A standard ER diagram shows department ids and their relationship with other service providers within the same industry.