I need to create a database which will have below modules:
- Items [Food items, stationary]
- Items Stock Management [stock in out]
- Items Sale Management
The system will have different types of items & so can have different 'Unit of Measurement'. Possible Units of Measurement can be bags, pieces, Kilograms. Another things is that certain items can be sold as a whole 'unit of measurement' OR 'part of unit of measurement', for example tomato can be sold 2 kilograms or 450 grams.
- How should i handle the 'Unit of measurement'?
- What is the best way to keep the stock in out?
For stock in out, i am thinking about to have a separate stock transaction table that will store any in/out transaction. I am still not clear about the 'Unit of measurement'.
Please forgive me if my question is not clear.
Thanks for your valuable time & help.