Design and Development of a Product Database for Brake Lining: A Case Study of a Brake Lining Factory

บทคัดย่อ

 The automotive parts manufacturing industry is characterized by intense competition, rapidly changing customer demands, and particular customer requirements. As a result, precise design and rapid development of new products are essential for maintaining competitiveness. Our case study is a lining brake factory with several thousand stock-keeping units. Managing all product-related data, such as engineering of change, bill of material and engineering files is crucial yet challenging due to the complexity of the products, manufacturing processes, and supply chain. This study aims to design and develop a product data brake lining management system to centralize product data within organization. It presents three main modules: the Input Data module, the Query Data module, and the Security module. The system is developed following the Software Development Life Cycle (SDLC). The system is based on web application technology, utilizing PostgreSQL for the database, React.js for the client side, and Express.js for the server side. The key technology used in this study is also discussed. The system evaluated through questionnaires completed using a user satisfaction form. User feedback indicated a satisfaction level of 4.48 out of 5 and a standard deviation 0.53. Moreover, it can reduce working time for all teams to create product data or search and retrieve product data from 131.6 min to 52.6 min, which reduces working time by 60% compared to the traditional method.