Entity relationship diagram
An entity relationship diagram is a drawing that shows the entities a system stores, such as customers and orders, and the links between them.
What it means
Boxes represent entities, lines show relationships, and marks at the line ends show how many on each side, such as one customer to many orders. It is a visual form of the data model, used to explain structure to both business users and technical staff. It helps find missing links, like an invoice line with no item reference, before records are built.
Example
Before setting up a new stores process, a lubricant maker in Vadodara draws supplier, purchase order, receipt and batch. The diagram reveals that receipts cannot be traced to a batch, so a batch link is added.
Records and checks
- Record entities, key fields and the direction and count of each relationship.
- Verify the diagram against real documents such as a purchase order and goods receipt.
- The system owner approves it with a senior user from the department.
Common mistakes
- Drawing every field and producing a chart nobody can read.
- Keeping the diagram while the live system drifts away from it.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →