Entity Relationship Diagram Example: Inventory System

Description:

This is an ER diagram example for inventory system. It contains entities like customer, order, product, employee, part, supplier, etc. Properties of these columns are represented by columns, while their inter-relationships are represented by connector lines with different cardinality.

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 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