This entity-relationship diagram shows a company’s employee management system. According to the diagram, the Employee entity has attributes like Name, Address, ID, and Phone. The employee also has a specific role with title and responsibilities. The diagram shows the employee’s specific department with a number and name. An employee works on a project that is controlled by the department.

Edit this diagram in Gleek

Employee management system diagram code in Gleek

Customer
int phoneNumber
int customerNumber
string Name
string Address
Product
int Price
int Type
string Manufacturer
Store
string Name
string Address
Merchant
string Name
string Address
int staffNumber
Sales
string Product
int priceTotal

Customer {1}–{0..n} Product
Customer {1}–{0..n} Sales
Product {0..n}–{1} Store
Product {0..n}–{0..n} Sales
Store {0..n}–{0..n} Sales
Merchant {1}–{0..n} Sales

About ER diagrams

We often make an entity-relationship (ER) diagram, ERD, or entity-relationship model, in the early stages of designing a database. An ERD is perfect for quickly sketching out the elements needed in the system. The ERD explains how the elements interact. ER diagrams can be shared with colleagues. Their simplicity makes them ideal even for non-technical stakeholders.

Similar ER diagram examples

Online store entity-relationship diagram

Inventory management system ER diagram (Chen notation)

Simple ER diagram example with Chen notation

Online shopping entity-relationship diagram

Library management system ER diagram with Chen notation

Simple order process entity-relationship diagram