1.1 Introduction
Commodity exchange information system is a system designed to give essential information on commodities produced in the state. It contains transaction records for various commodities. These products vary from state-based agricultural products to mineral-based goods. This chapter will address the background information that motivated this study, the challenges that prompted it, its aim, and its objectives as a preface to subsequent sections of the study. Additional factors include the study's significance, scope, limitations, and the definition of technical terms.
1.2 Statement of Problem
Investigation revealed that the problem has been largely on how to locate commodities where they are produced and the record in the state. This includes grading of commodities. Standard measures and price attached to each grade. This computerized system is aimed at providing a remedy for these problem areas.
1.3 Aim and Objectives of the Study
The aim of the study is to design and implement a Computer Based System for Commodity Information Exchange. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will:
- Provide information to the local government area and the warehouse at which those commodities could be got;
- Provide information on available commodities in Enugu State;
- Allocate price for every commodity per unit measurement of the commodity;
- Allow updating of the database files of all the database in the system;
- Provide security strategies to secure transaction and files;
- Produce report on information needed;
- Provide file maintenance facilities; and
- Provide information on the banks at which individual warehouse in local government area do their financial transactions.
1.4 Significance of Study
This study will be beneficial to the local population. A recommended remedy has been identified for the issue they are now encountering. For both scholars and the general public, this study is extremely important. More information on the topic at hand will be provided.
The implementation of the new system is expected to alleviate their workload related to gathering and storing data, as well as producing reports that may be needed for managerial decisions and industry advancement.
The local government area of Enugu State, Nigeria, is rich in natural resources. Fruits, vegetables, crops, coal-produced minerals, etc. are a few examples. In addition to individuals, groups, and commodities, these resources are spread over many towns around the state. Therefore, there are everyday commercial transactions involving these goods. It is consequently necessary for them to maintain a record of the data needed to find and purchase these goods when needed. When completed manually, this cannot provide all the necessary and involved details. Thus, this exchange system is required.
1.5 Scope and Delimitation of Study
The scope of the research is focused on the Design and Implementation of a Computer Based System for Commodity Information Exchange.
The commodity Exchange Information system is designed based on selected commodities existing in Enugu State. The system does not take into consideration payment of any transaction made by cash, but that made through electronic fund transfer. Banks which payments are made are selected ones situated in Enugu metropolis.
Mainly major commodities produced are taken care of in this project work. There are no utility files or work up tables incorporated, instead a simplified and concrete users operation manual is provided to guide the user in chapter six. This contains all the necessary utility facilities needed.
1.6 Limitations of the Study
from investigation gotten from the ministries of Agriculture, Raw Material Development Centre and the Nigeria Export promotion council, there is no adequate and through record of commodities are produced local government of production, or even giving account of transaction made on these commodities.
There is a problem to know the standard measures of these commodities and price according to the grade of these commodities.
In the course of this project Enugu has been taken off most of their mineral based commodities, limiting them to only coal. The major constrain at the time of programming was usually access of the computer to work in the course of this project work. Finally banks do not exist in some zones of production die to lack of fund so that fund transfer can be fally effective.
1.7 Assumptions
This project work agrees that commodities are broken or grouped into their respectives classes e.g vegetables, fat and oil, fruits, tuber and so on.
1.8 Definition of Terms
System Sub-System:
These are the different sub-routines in the system that performs the different unique activities of the system. The sub-system of these different modes forms the system operation.
Create and Append:
The sub-system that creates and ads new information to the data base respectively. The records are stored in the transaction files.
Edit:
The sub-system effects the connection of the records. The fields are prompted for each record
Insert:
This effect an automatic correction of records by prompting for particular field(s) which are used to update the records involved
Delete:
This sub-system marks a record, for removal from the database file. The records can be called back using the recall command.
Pack:
Pack is included in the delete sub-system, it is finally used to delete the records marked for deletion. When a record is marked for deletion and packed it cannot be recalled back using the recall command.
selection:
This set up a filter mechanism for selecting the different records of a file. It remains active until a new file is selected. The selection mechanism is in different modes for example while DO IF CONSTRUCTS.
Projections:
This makes a particular field of a file to be inactive for a new file selected.
Join:
It concatenates fields of a given file to those of another file.
File Sorting and Indexing:
This allows both the physical and logical arrangement of the records of a file. In sorting this arrangement is physical in that the current positions are most like to be altered. Indexing arrangement with structure of the arrangement stored in a transaction file referred to as index file. When a file is used with the index the record number is obtained from the index file and used to read the data file. Data files are physically not arranged. The index file name is user supplied.
Option Prompter:
It is used in the selection of system option. It utilizes highlight bars with arrows for direction and enters key for selection confirmation in this project work.
Range / Position:
It specifies range, starting position and direction of records to be processed ensuring that thee user does not exceed the present record number specified.