IMHO, I would have a parts table, containing 'standard' data. Part Number, Revision, Description, Specification, etc. Have a Locations table, containing the possible inventory storage locations. Keep the inventory in a table containing the Part Number ID, the Location ID, and the quantity and units on hand, at that location. I would probably also have a
process table, containing data ...