Data model
A data model is a structured description of the things a business keeps data about, their attributes and the relationships between them.
What it means
It answers what the "things" are, such as customer, item, order, invoice and batch, what we store for each, and how they connect: one customer has many orders, one order has many lines. A sound model prevents double entry and makes reports possible. It is drawn before a system is built or chosen, and later when records need to move.
Example
A bakery chain in Mysuru models outlet, product, daily dispatch and wastage. Because wastage links to outlet and product, the owner can see that one outlet wastes 11 percent of its cakes while the rest waste 4 percent.
Records and checks
- Record each entity, its fields and its relationships in a diagram or table.
- Verify the model supports the reports the business actually needs.
- The system owner and a senior user review it before any build.
Common mistakes
- Modelling to the current form layout, which breaks as soon as the form changes.
- Storing the same fact in two places that can then disagree.
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 →