ABSTRACT
The application has three users, Managing Director, Teller and the Customer
login page. The MD has access to all the transaction details, MD can create an
Account , add staff and each account created will have password for security
purpose which is going to serve as login details. The Teller can check account
details, Credit an account with the following details: Account Number, Amount
and Depositor Name, also Debit an account with the following details: Account
Number, Amount and Withdrawer Name. The Customer has access to check
his/her account details, view and print transaction details, also changes his/her
password.
LIST OF FIGURES
Fig 3.1 Manual Process Diagram- – – – – -25
Fig 3.2 Input, Output Analysis- – – – – – – – -28
Fig 3.3: Main menu- – – – – – – – – -29
Fig 3.4: New Users- – – – – – – – – -29
6
Fig 3.5 Edit Account- – – – – – – – -30
Fig 3.6: Deposit Slip- – – – – – – – – -32
Fig 3.7: Account Opening Form- – – – – – – -34
Fig 3.8: Transaction File Structure- – – – – – – -34
Fig 3.9: Structure of the Master File- – – – – – – -35
Fig 3.10: Transaction File- – – – – – – – -35
Fig 3.11 Available Cash- – – – – – – –
-35
Fig 3.12 Account Type– – – – – – – -35
Fig 3.13 User Table- – – – – – – – – -36
Fig 3.14: Program Flowchart- – – – – – – – -36
Fig 3.15: Accounting Opening Flowchart- – – – – – -37
Fig 3.16: Bank Transaction Flowchart- – – – – – –
-38
Fig 3.17: System Flowcharts- – – – – – – – -39
Fig 3.18: Top down diagram- – – – – – – – -40
Fig 4.1. Account form (KYC) – – – – – – – – -42
Fig 4.2 Admin and Customer Login Implementation- – – – -43
Fig 4.3 Feedback Interface- – – – – – – – -43
Fig 4.4 Transaction Interface- – – – – – – – -43
Fig 5.1 Main Interface with admin login- – – – – – -55
Fig 5.2 Admin welcome page interface- – – – – – -55
Fig 5.3 Update Customer Details- – – – – – – -56
Fig 5.4 Checking of Account Balance- – – – – – –
-56
Fig 5.5 Crediting of Account- – – – – – – – -57
Fig 5.6 Debiting of Account- – – – – – – – -57
Fig 5.7 Customer Transaction Details– – – – – – -58
LIST OF TABLES
Table 3.1 Operations at May Fresh Bank- – – – – – -21
Table 3.2 Extent of Computerization at May Fresh Bank- – – – -22
Table 4.1 Account Number Testing- – – – – – – -44
Table 4.2 Account KYC form Testing- – – – – – -44
Table 4.3 Login page Testing- – – – – – – – -44
Table 4.4 Feedback Form Testing- – – – – – – -45
7
Table 4.5 Admin page Testing- – – – – – – – -45
Table 4.6 Teller page Testing- – – – – – – – -46
Table 4.7 Customer page Testing- – – – – – – -46
Table 5.1 Project Expenses- – – – – – – – -49
TABLE OF CONTENTS
Title page – – – – – – – – – – -i
Certification- – – – – – – – – – -iii
Dedication- – – – – – – – – – – -iv
Acknowledgement- – – – – – – – – -v
Abstract- – – – – – – – – – – -vi
List of Figures- – – – – – – – – – vii
List of Tables – – – – – – – – – viii
Table of contents- – – – – – – – – – ix
CHAPTER ONE
1.1Introduction – – – – – – – – – -1
1.2 Statement of Problem- – – – – – – -3
1.2Objectives of the Project- – – – – – – – -5
1.4 Scope of the Project- – – – – – – – – -5
8
1.5 Limitation of the Study- – – – – – – – -6
1.6 Programming Language Used- – – – – – – -6
1.7Organization of Project Report – – – – – – – -7
1.8Definition of Terms- – — – – – – – – -7
CHAPTER TWO
Literature Review – – – – – – – – – -9
2.1 The Online Banking Management System – – – – -10
2.2 Registration and Security- – – – – – – – 10
2.3 Database Management Systems – – – – – – – -11
2.4 Data Management- – – – – – – – – -11
2.4.1 Data Integrity – – – – – – – – – -11
2.4.2 Cash/Cheque Payment – – – – – – – – -12
2.5 Traditional Banking Vs Online Banking – – – – – -12
2.6 Types of Services – – – – – – – – – -13
2.7 The Role of Information Technology in the Banking System- – -14
2.8 Security Features in Online Banking System- – – – – -15
2.9 Advantages of Online Banking- – – – – – – -15
2.10 Disadvantages of Online Banking – – – – – – -16
2.11 Online Banking System Security – – – – – – -17
CHAPTER THREE
3.1 Methodology- – – – – – – – – – -20
3.2Information Gathering- – – – – – – – -20
3.3 Data Analysis- – – – – – – – – – -22
3.4 Limitations of the Existing System- – – – – – -22
3.5 Description of the Existing System – – – – – – -23
3.5.1 Feasibility Considerations- – – – – – – -24
9
3.5.2 Economic Feasibility – – – – – – – – -24
3.5.3 Operational Feasibility- – – – – – – – -24
3.5.4 Manual Process Diagram- – – – – – – -25
3.5.5 Problem Domain- – – – – – – – – -26
3.6 Proposed System Design- – – – – – – – -26
3.6.1 The Manual System – – – – – – – -27
3.6.2 Input, Output and Analysis- – – – – – – -28
3.6.3 The Current Issues Involving the Following Factors- – – -29
3.6.4 New User – – – – – – – – – – -29
3.6.5 Existing User – – – – – – – – – -29
3.6.6 Accounts- – – – – – – – – – -30
3.6.7 Design Procedure- – – – – – – – – -31
3.6.8 Flow Diagram- – – – – – – – – -31
3.6.9 Some Forms (Tellers) Used In May Fresh Bank- – – – -32
3.7 Database Design Standard- – – – – – – – -33
3.7.1 Output Specification and Design- – – – – – -33
3.7.2 Input Specification and Design- – – – – – – -33
3.7.3 Transaction File Structure- – – – – – – -34
3.7.4 File Design- – – – – – – – – – -34
3.7.5 Structure of the Master File – – – – – – – -35
3.7.6 Transaction File- – – – – – – – – -35
3.7.7 Available Cash- – – – – – – – – -35
3.7.8 Account Type- – – – – – – – – -35
3.7.9 User Table- – – – – – – – – – -36
3.8 Program Flowchart – – – – – – – – – -36
3.8.1 Account Opening Flowchart – – – – – – – -37
3.8.2 Bank Transaction Flowchart – – – – – – – -38
3.8.3 System Flowcharts– – – – – – – – -39
10
3.9 Top down Design Diagram– – – – – – – -40
CHAPTER FOUR
4.1Choice Of Development Tools- – – – – – – -41
4.2 System Requirement– – – – – – – – -41
4.2.1 Hardware Requirement – – – – – – – – -41
4.2.2 Software Requirement – – – – – – – – -41
4.3Database Implementation- – – – – – – – -42
4.3.1 System Security Implementation- – – – – – -43
4.3.2 Implementation of the Feedback Table Design- – – – -43
4.3.3 Implementation of Transaction Table Design- – – – -43
4.4 The Test Plan- – – – – – – – – – -44
4.4.1 Test Data, Expected Versus Actual Test Result- – – – -44
4.4.2 Testing the Database – – – – – – – – -44
4.4.3 Testing the Admin Side- – – – – – – – -45
4.4.4 Testing the Customer Side- – – – – – – -46
4.4.5 Integrated Testing– – – – – – – – -46
4.4.6 System Evaluation- – – – – – – – -47
CHAPTER FIVE
5.1Summary- – – – – – – – – – -48
5.2Limitation- – – – – – – – – – -48
5.3Recommendations- – – – – – – – – -49
5.4B.E.M.E (Bill Of Engineering Measurement And Evaluation)- – -49
5.5Conclusion- – – – – – – – – – -49
References- – – – – – – – – – – -50
Appendix A- – – – – – – – – – -52
Appendix B- – – – – – – – – -55
11
CHAPTER ONE
1.1 INTRODUCTION
Design and implementation of online banking system, a case study of May fresh
savings and Loans Bank Caritas University Branch.
The greatest innovation that has taken place in the twentieth century is in the
realm of information Technology. This is currently made possible by the
introduction of the digital computers which has been observed in the field of
communication to be increasingly inseparable from communications. These
linkages often referred to as convergence is driven by technology and amplified
by business trends. Faster growth in network systems that use communication
links to connect subsidiary system (nodes) which may send and receives, direct
and redirect information.
Talking of the internet a couple of years ago would have sound like a
fairytale but today the internet is pervasive in almost every field of human
Endeavour changing the fundamentals of how we conduct national as well as
international businesses. Few years of its existence, the internet has shown that
it can deliver the long sought after goal of electronic commerce.
It is worth that companies in the developed countries world-wide have
recognized the business potential of the internet and are getting connected to the
network of networks in their millions.
12
The financial institution (Bank) is one of such organizations. Banking
constitutes one of the most prominent life wire for Socio-Economic grow and
development in any given nation, it supports and assists in the supply of long
and short term loan, accepts both current sowing and fixed deposits, both
foreign transactions, advice and facilitates transactions between client, workers,
agents, firm, buyers and seller by providing payment services, not excluding the
issue of undertaking risk on behalf of their clients, only to mention but a few.
The internet having found its application and acceptance in the banking
procession has particularly put the banking industry on an accelerating pace of
development. The technological highway (the internet) has become an enabler
for Banks in achieving high level productivity and in handling volumes of
transaction which would have been impossible without the use of on-line
banking (E-commerce).
The technology facilitates linkages with clients both through the
provision of information and quality service delivery, as well as in reducing
barriers to entry into payment systems retail banking. Internet banking allows
clients to engage in informal transaction relationship which would have taken
long distance travels or movement of documents with the attendant risk of loss.
With the online banking (internet) you can at your convenience, at home and at
any time review account balances and transactions, transfer funds, receive and
pay bills, down-load transaction services and contact customer services just to
mention but a few.
13
An over view of the benefits and prospects of the on-line banking suggest
that for banks to be relevant to their customers in term of the services they
provide in the twenty-first century and in the future, must append this services
provided by E-commerce in the banking system in order to stay in competition.
Now the on-line banking is the one thing bank should get up and invest in
internet technology to reap bounteously the benefit accruing from internet
banking.
While Internet continues growing and gaining popularity among crowd,
mobility represents new challenges to web designers. Wireless access is a new
challenging mission in the current Internet era, with different demand for
information by using less efficient terminals and networks. What really
motivated our choice of topic was the fact that Information and Communication
Technology (ICT) is not yet fully applied in May fresh Bank and in our
economy as a whole. We felt that May fresh Bank Caritas University Branch
should also exploit the use and application of this wireless system in order to
enhance their operations effectively and efficiently.
1.2 STATEMENT OF 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 banking
hall. The management also wastes their time as they run around to find solution
to those problems. Also it is observed that customers cannot withdraw money
14
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.
Information and Communication Technology is still underutilized in May
fresh Bank Caritas University Branch and in our society as a whole. May
fresh Bank Caritas University Branch lacks effective ICT capacity for
dynamic wireless operations. On analyzing the existing system of branch,
the following problems were identified:
a. May fresh Bank Caritas University Branch lacks the Information and
Communication Technology (ICT) capability to wirelessly operate and
interact with their database in order to:
 Verify whether an account is credited or debited, wirelessly using GSM
handset or internet.
 To verify the status of a Customer‟s transactions.
b. May fresh Bank, can verify the validity of their customers only through
one source in a whole Branch through on central database online.
c. Presently, customers cannot access their May fresh Bank account
Information online or with their GSM handsets, either to check or verify
the status of a transaction without much official steps.
15
May fresh Bank cannot automatically contact their customer whose account
number has been credited or debited as a result of lack of automated system.
1.3OBJECTIVES OF THE PROJECT
 To improve in the speed, effectiveness, efficiency and convenience in
business transaction.
 To design and implement a computer software to solve this problem and
rendering the services.
 To design a friendly web-site that graphically advertises goods and
services provided by the institute on web pages.
 To provide an On-line banking database for May fresh Bank using
MySQL database.
 To interface the client and server side in a cost effective and efficient
manner.
 To generally enhance the operational capacity of May fresh Bank via
ICT.
 To design an interface that could be used to input transactions details for
customer, and the bank staff information, able to store them in the
database for further use and investigations of any bank transactions.
1.4SCOPE OF THE PROJECT
16
This project will provide an online banking database using MySQL database
for May fresh Bank that can be accessed wirelessly from any branch area at
any time. It features both GSM based wireless database access and Internet
based wireless access for WAP enabled cell phones. Other features include
ability to receive feedback wirelessly from any stakeholder and also the
ability to provide answers wirelessly to frequently asked questions and other
enquiries. It is hoped that its wireless database access feature would greatly
enhance the operational capacity of May fresh Bank in a cost effective
manner.
1.5 LIMITATION OF THE STUDY
Hard time is not a new phenomenon to an ordinary Nigerian but to the
student researcher, it is even worse. Time and finance posed a lot of constraints
to the work.
Consequently, difficulties were encountered during the collection of
primary data. Most of the administrators, system engineers and clerks visited
reluctantly refused interview for one reason or the other and being referred to,
the organization from one personnel to the other not excluding even security
men.
Books related to this topic are relatively scarce and could only be gotten from
the internet, which took a lot of time and money.
However, with persistence and perseverance reasonable facts were finally
obtained.
17
1.6 PROGRAMMING LANGUAGE USED
Programming language used are HTML, JAVA script, PHP. Software
includes Adobe Software used are Adobe Dreamweaver CS5, Adobe
Fireworks and wampServer .
1.7ORGANIZATION OF PROJECT REPORT
This Project report is organized in five chapters. Chapter one is on the
Introduction, Chapter two is on Literature Review. Chapter three is on
Research Methodology and System Design, Chapter four Testing and
Implementation. Chapter Five is on recommendations and Conclusions.
1.8DEFINITION OF TERMS
 Analysis: Breaking a problem into successively manageable parts for
individual study. Data flow: Movement of data in a system from a point of
origin to specific destination indicated by a line and arrow
 Design: Process of developing the technical and operational specification of
a candidate system for implements.
 Implementation: In system development-phase that focuses on user
training, site preparation and file conversion for installing a candidate
system.
 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.
18
 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.
 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.