Which diagram shows the entities and relationships in a database?

• A. Flowchart
• B. ERD
• C. Entity Framework
• D. Double

Answer: (B)

An ERD, or entity-relationship diagram, is the diagram used to model a database’s structure by showing the entities (the data tables), their attributes, and how those entities relate to one another. It highlights the connections between data, such as one-to-one, one-to-many, and many-to-many relationships, and helps you place foreign keys to enforce those links. This makes it the right choice for illustrating the entities and their relationships in a database.

In contrast, a flowchart maps steps in a process or workflow, not the data structure. A software framework like Entity Framework is a tool for mapping code objects to database tables, not a diagram of the database itself. And a Double refers to a numeric data type, not a diagram.