What is an Entity-Relationship diagram? How do you represent entities, attributes, and different types of relationships?

Sample answer preview

An Entity-Relationship diagram is a visual representation of data entities and the relationships between them. It is the primary tool for communicating data models to both technical and business audiences.