Development of traceability model for inexpensive high-volume items

Having a traceability system in a company which produces goods or services is something that can help to assure the customer’s or the company’s security, safety,and satisfaction. Information created by this system will help to improve the quality and also to find the clues of the production problem...

Full description

Saved in:

Bibliographic Details
Main Author:	Khabbazi, Mahmood Reza
Format:	Thesis
Language:	English
Published:	2009
Subjects:	Software engineering Systems engineering - Data processing Manufacturing processes
Online Access:	http://psasir.upm.edu.my/id/eprint/51508/1/FK%202009%2014RR.pdf
Tags:	Add Tag No Tags, Be the first to tag this record!

id	my-upm-ir.51508
record_format	uketd_dc
spelling	my-upm-ir.515082017-05-04T04:25:10Z Development of traceability model for inexpensive high-volume items 2009-03 Khabbazi, Mahmood Reza Having a traceability system in a company which produces goods or services is something that can help to assure the customer’s or the company’s security, safety,and satisfaction. Information created by this system will help to improve the quality and also to find the clues of the production problem occurrences. A database system in which storage and retrieval of information is performed is the most applicable method to meet this need and fulfill this demand. This thesis focuses on the data modeling for traceability system in information layer of manufacturing control system that is devoted for non-expensive high volume items as final goods in all aspects production and control operations. A useful database system that could be applicable in many identical cases for lot-base traceability for material flow is developed through data modeling. The designed model improves the applicability of lot traceability with dynamic store and retrieval of the manufacturing and quality data. The functionality of the computerized traceability information system requirement is successfully evaluated through implementing data queries. As the result, the developed model promises to handle fundamental issues of traceability system effectively. It supports for customization and real-time control of material flow in all quality and production operation processes. Through prototype implementation of the model, recording deviations and therefore, assessing their impacts become easier. The computerized information system with better visibility and dynamic data processing handles all traceability usages and applications efficiently. Due to the case and nature of this thesis is not for a complex enterprise, it can be concluded that the model is initially applicable to environment with identical operational boundaries and complexity. A case study in car component industry which provides the fundamental idea and key solution is presented. ERM (Entity Relationship Modeling) and pertaining diagrams (Entity Relationship Diagram) are used as modeling tool for its easy-understanding and applicability in modeling of high volume data. Microsoft Access is selected as database platform in this study due to its availability at all manufacturers especially small-to-medium size enterprises. The designed database includes main console with two options of data entry forms, and reports. Data entry is made manually and from customer order to final product inspections. Report option is designed to acquire desired traceability information such as lot relations. The solution is limited to material flow control excluding all resources and capacity related issues in the planning functionality. The model developed for a single company environment with batch production system for Make-to-Order. Software engineering Systems engineering - Data processing Manufacturing processes 2009-03 Thesis http://psasir.upm.edu.my/id/eprint/51508/ http://psasir.upm.edu.my/id/eprint/51508/1/FK%202009%2014RR.pdf application/pdf en public masters Universiti Putra Malaysia Software engineering Systems engineering - Data processing Manufacturing processes
institution	Universiti Putra Malaysia
collection	PSAS Institutional Repository
language	English
topic	Software engineering Systems engineering - Data processing Manufacturing processes
spellingShingle	Software engineering Systems engineering - Data processing Manufacturing processes Khabbazi, Mahmood Reza Development of traceability model for inexpensive high-volume items
description	Having a traceability system in a company which produces goods or services is something that can help to assure the customer’s or the company’s security, safety,and satisfaction. Information created by this system will help to improve the quality and also to find the clues of the production problem occurrences. A database system in which storage and retrieval of information is performed is the most applicable method to meet this need and fulfill this demand. This thesis focuses on the data modeling for traceability system in information layer of manufacturing control system that is devoted for non-expensive high volume items as final goods in all aspects production and control operations. A useful database system that could be applicable in many identical cases for lot-base traceability for material flow is developed through data modeling. The designed model improves the applicability of lot traceability with dynamic store and retrieval of the manufacturing and quality data. The functionality of the computerized traceability information system requirement is successfully evaluated through implementing data queries. As the result, the developed model promises to handle fundamental issues of traceability system effectively. It supports for customization and real-time control of material flow in all quality and production operation processes. Through prototype implementation of the model, recording deviations and therefore, assessing their impacts become easier. The computerized information system with better visibility and dynamic data processing handles all traceability usages and applications efficiently. Due to the case and nature of this thesis is not for a complex enterprise, it can be concluded that the model is initially applicable to environment with identical operational boundaries and complexity. A case study in car component industry which provides the fundamental idea and key solution is presented. ERM (Entity Relationship Modeling) and pertaining diagrams (Entity Relationship Diagram) are used as modeling tool for its easy-understanding and applicability in modeling of high volume data. Microsoft Access is selected as database platform in this study due to its availability at all manufacturers especially small-to-medium size enterprises. The designed database includes main console with two options of data entry forms, and reports. Data entry is made manually and from customer order to final product inspections. Report option is designed to acquire desired traceability information such as lot relations. The solution is limited to material flow control excluding all resources and capacity related issues in the planning functionality. The model developed for a single company environment with batch production system for Make-to-Order.
format	Thesis
qualification_level	Master's degree
author	Khabbazi, Mahmood Reza
author_facet	Khabbazi, Mahmood Reza
author_sort	Khabbazi, Mahmood Reza
title	Development of traceability model for inexpensive high-volume items
title_short	Development of traceability model for inexpensive high-volume items
title_full	Development of traceability model for inexpensive high-volume items
title_fullStr	Development of traceability model for inexpensive high-volume items
title_full_unstemmed	Development of traceability model for inexpensive high-volume items
title_sort	development of traceability model for inexpensive high-volume items
granting_institution	Universiti Putra Malaysia
publishDate	2009
url	http://psasir.upm.edu.my/id/eprint/51508/1/FK%202009%2014RR.pdf
_version_	1747812059859386368

Development of traceability model for inexpensive high-volume items

Similar Items