Entity Relationship Diagram Example: Online Photo Album


An ER diagram is a pictorial representation of the information that can be captured by a database. This ER diagram example shows the entities identified for developing an online photo album, which include photo, album, member, comment, tag, etc.

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 (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 Database Design produces the initial model of the mini world in a conceptual data model similar to the Entity-Relationship-Model).

Logical Database Design transforms this schema into the data model supported by the DBMS to be used similar to the relational model.

Physical Database Design aims at improving the performance of the final database system.

During conceptual design, we should focus is on producing a correct model of the real world. There is no need to worry about performance aspects or limitations of 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.