ABSTRACT
In
this world of competitive resource application and technological development,
the banks have been totally computerized. This project work Design and Implementation
of computerized banking system is concerned with the analysis and design of a
computerized system aimed at supporting the whole banking operation provides an
interface which enables the user or the customer to lodge in money into his or
her account and make withdrawals as the need arises. It will also provide the
basis for the implementation of computerized banking transactions. A
development which made most banks and other financial institutions more
responsive to changes and imperative to adopt the latest art of technology is
for the purpose of maintaining operational efficiency as a means of warding off
competitive threat, and also to improve on the security measures, checkmate
fraud and error, to increase the speed of transaction and improvement of
customer’s convenience by reducing barriers to entry into payment systems. At
the end of all, the system proposed is better, calculates faster and is
reliable. This enhances operations and level of commitment to customers.
TABLE OF CONTENTS
CHAPTER ONE
INTRODUCTION
1.1 THE OVERVIEW OF THE STUDY
1.2 STATEMENT
OF THE PROBLEM
1.3 OBJECTIVES OF THE STUDY
1.4 LIMITATION OF THE STUDY
1.5 THE SCOPE OF THE STUDY
1.6 SIGNIFICANCE OF THE STUDY
1.7 ORGANISATIONAL STRUCTURE
1.8 DEFINITION
OF BASIC CONCEPTS RELEVANT TO THIS STUDY
CHAPTER TWO
REVIEW OF THE
RELATED LITERATURE
2.1 THE EVOLUTION OF THE COMPUTERISED BANKING SYSTEM
2.2 REGISTRATION AND SECURITY
2.3 DATABASE MANAGEMENT SYSTEMS
2.3.1
Cash Deposit Diagram
2.3.2 Deposit by Cheque
2.4 DATA MANAGEMENT
2.4.1 Data Integrity
2.4.2 Cash/Cheque Payment
2.5 TRADITIONAL BANKING VS ONLINE BANKING
2.6 TYPES OF SERVICES
2.7 THE ROLE OF INFORMATION TECHNOLOGY IN THE BANKING
SYSTEM
2.8 SECURITY FEATURES IN ONLINE BANKING SYSTEM
2.9 ADVANTAGES OF ONLINE BANKING
2.10 DISADVANTAGES
OF ONLINE BANKING
2.11 ONLINE BANKING SYSTEM SECURITY
CHAPTER THREE
SYSTEM ANALYSIS
AND METHODOLOGY
3.1 DESCRIPTION
OF THE EXISTING SYSTEM
3.2.1 FEASIBILITY
CONSIDERATIONS
3.2.2 ECONOMIC
FEASIBILITY
3.2.3 OPERATIONAL
FEASIBILITY
3.3 MANUAL PROCESS DIAGRAM
3.4 PROBLEM DOMAIN
3.5 PROPOSED SYSTEM
3.6 THE MANUAL SYSTEM
3.7 INPUT, OUTPUT AND ANALYSIS
3.8 THE CURRENT ISSUES INVOLVING THE FOLLOWING FACTORS
3.8.1 NEW USER
3.8.2
EXISTING USER
3.9 ACCOUNTS
3.10 DESIGN PROCEDURE
3.11 FLOW DIAGRAM
3.12 SOME FORMS (TELLERS) USED IN UBA
CHAPTER FOUR
4.0 DESIGN
AND IMPLEMENTATION OF THE NEW SYSTEM
4.1 DESIGN STANDARD
4.2 OUTPUT SPECIFICATION AND DESIGN
4.3 INPUT SPECIFICATION AND DESIGN
4.3
TRANSACTION FILE STRUCTURE
4.4 FILE DESIGN
4.5 STRUCTURE
OF THE MASTER FILE
4.5.1 TRANSACTION FILE
4.6 PROCEDURE FLOWCHARTS
4.7 SYSTEM FLOWCHARTS
4.8 SYSTEM REQUIREMENT
4.8.2 SOFTWARE REQUIREMENT
4.9 PROGRAM
FLOWCHART
4.10 ACCOUNT
OPENING FLOWCHART
4.11 BANK TRANSACTION FLOWCHART
4.12 CODES
4.12.1 CODING TESTING
4.12.2 TESTING
4.12.3 TESTING OBJECTIVES
4.13 LEVELS OF
TESTING FLOW CHART
4.13.1 INTEGRATION
TESTING
4.13.2 SYSTEM
TESTING
4.14 DATABASE
IMPLEMENTATION
CHAPTER FIVE
SUMMARY, CONCLUSION AND RECOMMENDATIONS
5.1 SUMMARY
5.2 CONCLUSION
5.3 RECOMMENDATIONS
REFERENCES
CHAPTER
ONE
INTRODUCTION
1.1 THE OVERVIEW OF THE STUDY
Banking
has come a long way from the time of ledger cards and other manual filing
systems. Most banks today are computerized to handle their daily voluminous
tasks of information retrieval, storage, and processing. Irrespective of whether they are automated or
not, banks by their natures are involved in all forms of Information Technology
and Management on continuous basis (Molina, 1997).
Banks
play their significant role in any economic system. They are financial
intermediaries involve in transfers of funds within and outside the country. Banking
sector is getting competitive every day. Quantity, speed, efficiency and
innovations are the main points on which quality programs are designed. All
banks are engaged in same basic banking activities but it is the way of
delivery of services that distinguishes one bank form the other. All banks
worldwide are considering quality in the strategic management. Taking a
proactive stance against privacy invasion could help stave off government
intervention in passing legislation to create tighter controls over what can be
done with an individual’s personal data. The development of computerized
banking system, however, involves a substantial amount of work, which ranges
from collecting sufficiently large number of data items. Computerized banking
system uses computer technology to relieve the consumer of the paper based and
time consuming work. Computerized banks have started utilizing powerful computer
networks resources for automating large numbers of daily transactions, which
minimizes the time consuming manual paper work and giving access too many
different banking services to its clients instantly, on demand, at home or at
work. With the help of computerized banking, one can have access to money and
banking functions anytime and anywhere, even where there is internet access
(Renom, 1997).
This
technology has seen a tremendous increment in the usage, as more and more big
national banks and various other banks in smaller regions, have started some
form of computerized banking to provide conveniences to their customers and to
themselves. According to (Wainer, 2000),
the computerized banking mechanism is fast and secure compared to the
traditional banking operations because
of automation of the manual aspects of banking practice, which is time
consuming.
United
bank for Africa was incorporated on February 23, 1961 and was the first of the International
Banks operating in Nigeria
at that time to be registered under Nigeria Law. However, the Bank has its
antecedents in the British French bank which itself metamorphosed from Banque
National Pour Le Commerce ET L Industries, BNCI, and Paris, established in
1932. UBA has 258 branches and cash offices and agencies in Nigeria’s major commercial center, state capital
and the federal territory, including two offshore branches in New
York and grand Cayman
Island. UBA retains the unique status of being the
only Nigerian Bank with a presence in the United States of America. The New York branch acts as
one of UBA’s overseas correspondent banks. Others major correspondent banks are
Bankers Trust (USA) and Banque Nationale de Paris (UK
and France). A tradition of trail-brazing. In 1963, UBA
became the first bank to introduce Mobile Banking services in Nigeria. In
1986, UBA became the first to introduce a Cheque Guarantee Scheme known as
UBACARD, a forerunner of Easy Card which has recently replaced the electronic
payment card, UBA Val Card. Today the bank remains in the forefront in the
application of technological innovations in banking. It is one of the largest
agents of monogram International for award international money transfers. UBA
Connect TM provides a window for online global banking. In 1998 UBA became the
first Nigerian Bank to have its shares placed abroad through a global
depositary Receipt (GDR) program. UBA thus has a more international and
diversified shareholder base than any other Nigerian bank.
UBA
Capital and Trust, one of UBA’s subsidiaries, handles specialized services
including Asset Management , retirement and Pension, Executorships of wills,
trust ship services etc. Nominee, custodial and share registration services are
provided by UBA Securities services. An aggressive business promotion strategy
has earned the bank an enviable position in the banking industry. Due to the
competition in the banking sector, banks are mapping up the best strategy to
meeting up the global challenges. UBA is one of the new generation banks in Nigeria that
has one or two branches in each States of the Federation of which Enugu Branch
is my case Study. From the studies carried out, their initial means of
transactions was manual, to automated system then to computerized system which
lacked some feature such as account to account transfer of different customers,
instant messaging. This study focuses on total elimination of the manual means
of transactions through the addition of more features in computerized system of
banking. Effective adoption of computerized banking system, error rate, paper
work, inefficiency, inconsistency which has been the features of manual means
of transaction will drastically reduced or totally eliminated.
1.2
STATEMENT OF THE PROBLEM
In
banking industries today, queuing
has become the order of the day, customers’ line up for hours waiting to
withdraw or deposit money. This creates a lot of problem to both customers as
they waste their useful time in the baking hall. The management also wastes
their time as they run around to find solution to their problems. Also it is
observed that customers cannot withdraw money any time they want as banks has
their working hours. This is a big problem as needs can arise at any time and
human beings will always like to have those needs solved. Also money deposited
into accounts at times takes some hours to reflect in the persons account
balance hence making banking operations slow and unhealthy for business growth.
1.3 OBJECTIVES OF THE STUDY
The
project has been planned to have the form of distributed architecture, with
centralized storage database to improve on the speed and effectiveness, efficiency
and conveniences in business transaction.
The standards of security and data protective mechanism have been given a big
choice for paper usage. The application takes care of different modules and
their associated reports. The only online transactions the customer can do are
cheque book requisition and fund transfer among his personal accounts. Provide
administration to control and monitor various transactions. The study and
subsequent design and implementation of this program will be of immense use to
the organization, the administration and the customers in realizing the speed,
efficiency, effectiveness and convenience. The program takes care of those factors
that militate against the smooth running of the organization using the
computerized system services. Better still scholars who intend to carry out
subsequent research could have this as base from where improvement could be
made.
In
a nut shell therefore, the following are the major objective of this work:
-
To provide fast services, this reduces the
queue in the banking hall.
-
To provide an easy to operate system for
the bank staff.
-
To build a one time entry for customer
details in the system.
-
It requires minimum staff for easy
operation.
-
It reduces room for errors which might be caused
by staff.
-
To provide a minimum saving tie for
customer and also staff.
-
The system provides automatic calculation
for accurate results.
-
The system reduces the time normally spent
trying to save data.
-
A calculation like interest or rate is
very fast and accurate under this system.
1.4 LIMITATION OF THE STUDY
The
development of this work was not an easy task, the areas of sourcing for
information and data collection was a challenging one. The materials apart from
the one sourced from the internet were not easy as most information were
journals that requires subscriptions in order to have access to it. Also
gaining access and interviewing of various heads of their staff was not an easy
one, most time I went, they are busy attending to customers. Again lack of
sufficient funds to conduct an extensive study was another handicap. More so I
found at that banks go through a lot in order to get a system which not only
should be secure but also offers many order services as to the satisfaction of
the customer. The financial implication as this project is concerned gulped
money.
1.5 THE SCOPE OF THE STUDY
The
application of this software is not only limited to banks alone but can be used
equally by government establishment, cooperate organization and individuals to
efficiently pilot the affairs and its management.
1.6 SIGNIFICANCE OF THE STUDY
The
purpose of this project is to magnificently improve on the manual means of
transaction in the banks which has lead to low output, customer’s
dissatisfaction, inefficiency, inconsistency, error and poor storage data and
information to computerized means of transaction system.
1.8 DEFINITION OF BASIC CONCEPTS
RELEVANT TO THIS STUDY Analysis: Breaking a problem into
successively manageable parts for individual study.
Attribute:
A data item that characterize an object
Data flow:
Movement of data in a system from a point of origin to specific destination
indicated by a line and arrow
Data Security:
Protection of data from loss, disclosure, modification or destruction.
Design:
Process of developing the technical and operational specification of a
candidate system for implements.
File:
Collection of related records organized for a particular purpose also called
dataset.
Flow Chart:
A graphical picture of the logical steps and sequence involved in a procedure
or a program.
Form:
A physical carrier of data of information
Gantt chart:
A statistics system model used for scheduling portrays output performance
against time.
Implementation:
In system development-phase that focuses on user training, site preparation and
file conversion for installing a candidate system.
Maintenance: Restoring
to its original condition
Normalization:
A process of replacing a given file with its logical equivalent the object is
to derive simple files with no redundant elements.
Operation System:
In database – machine based software that facilitates the availability of
information or reports through the DBMS.
Password:
Identity authenticators a key that allow access to a program system a
procedure.
Record:
A collection of aggregates or related items of a data treated as a unit.
Source Code:
A procedure or format that allow enhancements on a software package.
System:
A regular or orderly arrangements of components or parts in a connected and
interrelated series or whole a group of components necessary to some operation.
System Design: Detailed
concentration on the technical and
other specification that will make the new system operational.
SDLC
(System Development Life Cycle): A structural sequence of phases for
implementing information system
System Testing:
Testing the whole system by the user after major programs and subsystem has
been tested.
Unit testing:
Testing changes made in an existing or new programs.
Validation: Checking
the quality of software in both simulated and live environments.
Login To Comment