Design And Implementation Of Real Time Current Account Transaction Processing System
This research work on “Design And Implementation Of Real Time Current Account Transaction Processing System” is available in PDF/DOC. Click the below button to request or download the complete material
UBN PLC, is a bank which deals with customers account both current, savings, deposit loan etc.
The above-mentioned processes and activities are not only time consuming but also stressful when done manually. The complexity and strain processes involved. The work will give birth to a computerized real time current account transaction processing system. This will facilitate storage of customers’ information as well as withdrawal of money from other branches without problems or delay. It will also provide a secured customer account filling system.
It will generally facilitate transaction processing in the bank.
INTRODUCTION
In the twentieth Century, the banking world has seen a continuing process towards fully computerized operations. At the start of the century there were few mechanical aids with all ledgers, passbook and account statements being written by hand. By 1920s the banks had graduated to mechanical accounting combined with an increase in business, this trend towards mechanization was continuous process, the staffing and expansion difficulties were tackled more forcibly on the 1950 with assistance from electronic data processing techniques. It was on the period that banks ordered their first computers.
The early installations were of a batch processing nature of data that had to be sent for processing at the computer centre and reports produced. Throughout the 1960s more of the clerical work was computerized and eventually by the end of 1960s all accounts were computerized.
In the middle of 1960s the utilization of branch terminal equipment which linked directly to computer centre was becoming a feasible proposition. This culminated in the early 1970s with the introduction of a sophisticated real time system in current Account Transaction Department.
This project aim is to produce an indigenous software package, which will be used to improve the efficiency of the CURRENT ACCOUTN TRANSACTION PROCESSING SYSTEM for Nigeria Banking Industry. Although banks have developed packages, however, because of the following reasons they have failed to meet the need of the Nigerian Banking Industry. Firstly, guidelines and policies for banks in Nigeria are controlled by central banks of which they revise annually thereby resulting in unsteady policies as a result; there is no standard whatsoever set for the banking industry thus banking policies are flexible.
Most of these banks use packages without modification hence the result is not what they desire. The modification of these packages to suit the Nigeria Banking Industry will cost expenditure to be wasted.
Efficiency in the banks has always been the foundation underlining the effectiveness of banks operation. Quick and accurate settlement of customers withdrawals, fast depositing system and procedures and the over acknowledged information process with which customers usually regard are also problems which computerized current transaction processes wishes to address by introducing Nigeria software packages.
This package will help Nigerian banks to obtain the efficiency in their current accounting transaction hence draw more customers and more money. It is menu driven and features top-down and structured programming techniques.
Real mode of operation provides an instantaneous transaction and processing of data, which gives immediate availability of result for decision-making. It has improved the efficiency of banks by:
(i) Customers; henceforth spent much less time in collecting their money.
(ii) There were seldom any mistakes because computer handled almost all operations. If there is any mistake, the computer can always easily pick it.
(iii) There was customer’s satisfaction and bank recorded substantial increase in their profits.
1.1 STATEMENT OF THE PROBLEMS
There are many methods that are being used in current account transaction processing system. Unfortunately, these methods are not always real in practice, to the day society. Even when they are real, they are not as efficient as expected. Some of the problems encountered by UBN are:
(i) Lack of computer for storage, there is tendency of the UBN to loose customer’s file which will bring distrust to them;
(ii) Due to lack of computer for accessing the file, there is tendency for them to be shown in retrieval of customer’s files, and updating of files.
(iii) Customers spend much time due to the delay of the bank.
(iv) Once there is not computer for calculation, there is tendency for their calculation to be inaccurate.
However, the researcher shall by the end of this work provide a suitable solution to these pressing problems of Current Account Transaction processing system.
1.2 PURPOSE OF THE STUDY
All effects of the researchers are pearled towards the gathering of sufficient information that would help in making suggestions as to how the current accounts transaction will be alleviated in the banks using real time mode of operation. The study attempted:
(i) To reduce staff pressure: With the increased utilization of banking services, branch staff have been placed on a pressure situation in which they are expected to deal with increasing volumes of business with computer, there is relief of clerical boredom.
(ii) Improve customer service: It has been felt for some time that the high standards of customer service are deteriorating largely due to the fact that branch staff is under continuing pressure to deal with more transactions rate.
(iii) To increase the efficiency and productivity of bank services.
(iv) Care at immediate response to account inquiries, information will be provided more quickly than under a manual or batch system. It is possible for example to monitor the cash flow into and out of the branches as the movement occurs.
(v) Reliability: The information provided by computer system is more accurate and reliable than that produced under a manual system subjective judgments and human inaccuracies are to a great extent eliminated. It could be urged, however, that middle management is being by-assed and the responsibility of the branch manager’s role is being diminished. The interpretation of branch statistics and the resultant decisions can now be made centrally and they will not be subject to possible personal considerations.
(vi) Variety: The real-time system allows a greater variety of management information to be produced. Furthermore, this information is of greater quantity that can be envisaged under a manual system.
1.3 AIMS AND OBJECTIVES
The objectives of this study is to find way through which the real-time current account transaction processing system could be improved with emphasis on Union Bank of Nigeria.
This could be (effective) achieved by designing a software package that will help the UBN to establish corporate policies, which will provide guide-line that will help to achieve their objectives. To provide an efficient computer based information system for easy updating storage and retrieval of information. To reduce the time the manual processing methods takes.
To provide a system, which will respond to urgent matter, this will provide a solution to an urgent enquiry finally to provide reliable and accurate information.
1.4 DELIMITATIONS
The study is delimited to Union Bank of Nigeria PLC, Enugu branch. Generally, in Nigeria, the operations carried out by the current and savings accounts are virtually the same.
The banks at the time of this research has got its above-mentioned departments computerizes. Again the other department of the banks could be involved to see the achievement made in such areas by the introduction of computers in the banks. This research involved programs to current account transaction operations, and did not include program for savings account.
1.5 LIMITATIONS
There are uncontrollable factors that act constraint to the efforts of this research and this includes the following:
Time: The research work is by task and requires time and energy. This research was carried out within the semester, which was very difficult for the students because it was combined with academic works.
Finance: Financial constraint is the most limiting factor. Due to the poor state of our economy, we the researchers could not procure all the needed material.
Finally, due to the financial constraint and time factor this research is limited to CURRENT ACCOUNT TRANSACTION DEPRATMENT in Union Bank of Nigeria.
1.6 ASSUMPTIONS
It was assumed here that all the programs fed into the computer for current account transaction calculations are perfectly in order. The generalization that all the banks have the same way of going about their current account transaction calculations may have been much assumption than reality.
The information given by the bank officials as regards the effect of computers on bank services are assumed to be correct.
1.7 DEFINITION OF TERMS
Computer: An electronic device, which on receipt of an appropriate input is capable of processing the inputs according to a set of previously supplied instructions and making the result (outputs) available, if desired.
File: A collection of related data or records.
IBM: International Business Machines. A computer producing company.
Real-time: Is a mode of operation that provide an instantaneous transmission and processing of an enquiry.
Program: Series of instructions to the computer.
Software: Computer software is a collection of instruction (programs) which are designed to solve specific user problems or to control and enhance the operations and uses of the computer.
Current Account: This is an account owned by mostly the businessmen which can be used by cheque in case of withdrawal.
Statement of Account: Is an account declaration of all its pay in an withdraw at the same time update the transaction for both the customer and the banker.
Transaction Processor: Is a process carried out on the activities and written records of the customer and he banker.
Opening of Account: It is the first time of a customer coming to the bank to open an account for depositing his/her money.
Closing of account: Is when a customer wants to close his account by withdrawing all his money from the banks.
Withdrawal: It is the process of collecting money that is less than the current balance that the computer has.
Teller: It is a paper used by the computer to deposit money into his/her account.
Cheque: It is a paper used by the customer to withdraw money from the bank’s current account.
UPS: Uninterrupted Power Supply: an interface between electric power from NEPA and the computer.
Title page
Certification
Dedication
Acknowledgement
Abstract
Organization of the work
Table of contents
CHAPTER ONE
1.0 Introduction 1
1.1 Statement of the problems 4
1.2 Purpose of study 5
1.3 Aims and objectives 7
1.4 The delimitations 7
1.5 The limitations 8
1.6 Assumptions 9
1.7 Definitions of terms. 9
CHAPTER TWO
Literature Review 12
CHAPTER THREE
3.0 Description and analysis of the existing system 22
3.1 Fact finding methods used. 22
3.2 Objectives of the existing system 30
3.3 Input, process and output analysis 32
3.4 Information flow diagram 34
3.5 Problems of the existing system 35
3.6 Justification of the new system. 35
CHAPTER FOUR
4.0 Output Specifications on Master Report 36
4.1 Input specification and design 38
4.2 File design 39
4.3 Procedure chart 42
4.4 System flowchart 43
4.5 System requirements 44
CHAPTER FIVE
5.0 Implementation 48
5.1 Program flowchart 48
5.2 Pseudo codes 50
5.3 Test run 53
CHAPTER SIX
6.0 Documentation 55
CHAPTER SEVEN
7.0 Recommendation and conclusion 58
7.1 Recommendation 60
7.2 Suggestions for further research 61
References 62