Database Design for Liquid Inventory Management System

[Lightwave]

Dear All - I thought I had posted this already but can't seem to find it. That's what happens when you are a bit rusty. Hope everyone is well.

Looking to see if anyone can point me in the direction of a good skeletal design of a inventory management system for liquid aclohol management system. So distilling alcohol and then splitting it up into bottles of various sizes. Probably make something up myself but would like to canvas opinion as well.

Much appreciated.

 

[AccessBlaster]

This site has a few diagrams of inventory, might be worth looking at.

http://www.databaseanswers.org/data_models/index.htm

 

[Lightwave]

Thank you guys much appreciated

 

[jdraw]

Do you have some "business facts" or overview of the things and processes involved? There must be a requirement/statement of need or something. I agree that some standardization for UOM will be key.

 

[Thales750]

I build Chemical Plant databases.
At the structural level, any tank that can hold liquid is in the same table. This includes trucks in, trucks out, and every tack and reactor (a place where the material is modified). Then transfers From and To. Transfers that modify materials will need to show that on the "To" side of the transfer.

This is theoretically a continuous process, so you break it down into batches.