Build database hierarchy for Bill of material (BOM)

Job ID: 32795424

Budget: $30 – $250 USD

Looking for someone familiar with databases in the manufacturing environment. Who can build a database hierarchy for Bill of material (BOM).

One bike has many components to build them. The sub-components also has several sub-components.
It needs to keep track of the quantity of parts used in an assembly as well as the remaining stock left in inventory.