Development of a Consolidated Data Base For Stock Control and Production Management.
Abstract
A relational data base for stock control and production management in one of the main logistics depots in Egypt was developed and partially implemented on INGRES. Top-down analysis of the depot was carried out, entities were determined, and an entity relationship chart was drawn. The areas of stock control and production management were chosen for applying the first data base project. Information requirements in the two specified areas were analysed, data elements were listed, and the individual user's views were determined. A set of third normal form relations were derived and used as a basis of the design. The conceptual model was developed using a structured technique that yielded the model in a canonical form. A subset of the conceptual model was mapped to the logical model in relational form, and the logical data base was implemented on INGRES and tested by running some queries against it. In conjunction with the data base design, linear programming techniques for solving the cutting problem were studied. An efficient algorithm was selected, modified to minimize time and space requirements, and coded in PASCAL. The system was tested by solving some problems, using data retrieved from the data base. Originator supplied keywords included: Data base; Relational data base; Linear programming; Cutting problem; Computer program; Pascal.
Document Details
- Document Type
- Technical Report
- Publication Date
- Dec 01, 1984
- Accession Number
- ADA153042
Entities
People
- A. I. El Deihi
Organizations
- Air Force Institute of Technology