Entity Relationship Diagram Example: Online Bookstore


Entity relationship diagrams (ERD) are widely used in database design and systems analysis to represent systems or problem domains. This is a typical ERD example for online bookstore. It contains entities like author, book, publisher, warehouse, customer, etc.

To edit this ERD template, simply click on Use this Template, then adjust the ERD to your liking. Alternatively, click Create Blank to draw your ER diagram from scratch.

What is Entity Relationship Diagram (ERD)?

The Entity-Relationship (ER) diagram (also known as ERD's or ER models) is a classical and popular conceptual data model originally proposed by Peter in 1976. It is a visual representation of different entities within a system and how they relate to each other. Entity Relationship Diagrams are widely used to design relational databases. The entities in the ER schema become tables, attributes and the converted database schema. Since they can be used to visualize database tables and their relationships it's commonly used for database troubleshooting as well.

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.