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