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
Banking system entity-relationship diagram
Travel management system Er diagram
College management system ER diagram
Online shopping entity-relationship diagram