Database for Collection of Defects in Main Line Production in Electrical Manufacturing

Abstract

This project was developed in order to create a database to analyze of the major defects identified when the quality representative realizes inspections in the main line of an Electrical Manufacturing firm. A database is a collection of information organized to provide an efficient retrieval. This information could be in different formats like electronic, graphic, audio, and statistical. Also, its content can easily be acceded, managed, and updated. The purpose of a database is to analyze operating process, define problems and constraints, and define scope and boundaries. An effective database is one which has been engineered to meet the actual present and future needs of the company. The interface must be usable and understandable by all persons which will be directly accessing the database and must provide reports and exportable data which meets the users. In order to improve manual data collection process the DMAIC Methodology was used. DMAIC is an acronym for a series of steps used to measure defects in business processes and improve profitability. The term DMAIC stands for the five main steps in the process; Define, Measure, Analyze, Improve and Control. This research allows a team to develop the project from its inception. DMAIC methodology brings a structure and the tool to identify problems in a production assembly line. Key Terms - Database, Defects, DMAIC, Inspection.