Entity Relationship Diagram Example: Hospital


Entity relationship diagrams (ERD) are widely used in database design and systems analysis to represent systems or problem domains. This is a simple ER diagram for hospital that consists of three entities: Patient, Doctor and Test. Use this ER diagram template to get started building your own. Customize the ER diagram to reflect the objects of your problem. Click Use this Template to start.

What is Entity Relationship Diagram?

The ERD was introduced by Chen (1976) in early 1976. An ERD can be served as the basis for databases, which store data about the problem domain, and which use, manipulate, and constrain that data. Experts in systems analysis and database design are adept at identifying user requirements and then translating them into corresponding components of the model. The entity relationship diagram is a graphical representation of a conceptual structure of a problem domain being modeled. The ERD assists the database designer in identifying the data and the rules that will be represented and used in a database.

Conceptual Design vs Logical Design vs Physical Design ERD

Conceptual Design - Creating an Entity Relationship Diagram (ERD) and associated data dictionary to represent the reality and capture business data requirements

Logical Design - Transforming ERD to relational model: tables, keys (constraints), etc.

Physical Design - Creating the database and other supporting structures based on a specific DBMS

Keen to try VP Online?

No limitations, no obligations, no cancellation fees.

Start a Free Trial

We use cookies to offer you a better experience. By visiting our website, you agree to the use of cookies as described in our Cookie Policy.