Database design with product structure, Bill of Material and group technology for supplier decision support systems (Case study: hand tractor manufacturing)

Supplier selection is a common problem for manufacturing industries because there are so many supplier options. The decision support system is one solution that can help industries in which one is the best supplier with specific criteria. In the case of manufacturing industries, to give decisions supports system input data, we need to identify the bill of materials. Furthermore, group technology also can be used to optimize the bill of materials. In this paper, we present the database design process from the bill of materials combined with group technology in tractor manufacturing industries. Product structure diagram, bill of materials table, database design diagram are created as results. From this result, we can develop a decision support system with some computing algorithmsfor the next study.