I need to create a database which will have below modules:
1- Items [Food items, stationary]
2- Items Stock Management [stock in out]
4- 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, peaces,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 450grams.
1- How should i handle the 'Unit of measurement'?
2- What is the best way to keep the stock in out?
Please forgive me if my question is not clear.
Thanks for your valuable time & help.
The the Item can have one or more units of measure? If it's only one, I'd say make it a lookup table linked directly to Items. If more than one, you'll want to set up a lookup table and then an interim table (a table that joins two other tables, classic many-to-many solution).
For second question, just go with a seperate stock transaction table that shows everything moving in AND moving out (pluses and minuses) and then you can aggregate to an answer.
Is this homework?
answered Dec 06 '11 at 05:15 AM
Grant Fritchey ♦♦