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.1 Introduction - - - - - - - - - -1
1.2 Statement of Problem- - - - - - - -3
1.2 Objectives 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.7 Organization 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.2 Information 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.1 Choice Of Development Tools- - - - - - - -41
4.2 System Requirement- - - - - - - - - -41
4.2.1 Hardware Requirement - - - - - - - - -41
4.2.2 Software Requirement - - - - - - - - -41
4.3 Database 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.1 Summary- - - - - - - - - - -48
5.2 Limitation- - - - - - - - - - -48
5.3 Recommendations- - - - - - - - - -49
5.4 B.E.M.E (Bill Of Engineering Measurement And Evaluation)- - -49
5.5 Conclusion- - - - - - - - - - -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.