Python Report

Download as pdf or txt
Download as pdf or txt
You are on page 1of 23

BANK MANAGEMENT SYSTEM 2022-2023

CHAPTER 1
INTRODUCTION
1.1 Project Overview
The project entitled “Bank management system” is a computerized telecommunications device
that provides the customers of a financial institution with access to financial transactions in a
public space without the need for a human clerk or bank taller (manpower). Thousands of bank
performs millions of transactions every day and thousands of users used banking system in day
to day life. As we know that if number of users increases us need more banks and more staff it
means increasing manual work also we put more amount of money in bank it is more risky and
not much secure. If we developed advanced computerized based banking system so there is no
need to open more branches as well the manpower is reduce and maximum information are
stored automatically in banking server. Banking system requires authenticity and validity if a
system provides these basic logics that mean we can developed a new system that authenticate
and validate the user and user can do any type of virtual transaction any time anywhere in
minimum amount of time. One of the most authentic codes i.e. the customer account number
for recognition of any person. It always appear on and credit, withdraw, money transferring,
linking aadhar with account and changing the account location in one branch to another branch
in same bank. Day to day life banking system is most useful and important thing in economical
world and which is very useful to develop country as well as economic power. Transaction: in
banking transaction is the execution of a program that performs an administrative or real time
function, often by accessing shared data sources, usually on behalf of a banking users who have
an account in the respective bank. This transaction executed by the program and it automatic
do the transactions with balance and it check all conditions are satisfied or not in respective
proses. This is the more secure and automatic process which do all the transaction with
accuracy of calculation. In our project we also provide the facility to link aadhar with account
number and we also provide the facility to change location of account with branch that mean
the user can change the branch which is convenient for it. They will also change or update data
like address, mobile number using online banking system.

East west Institute of Technology Department of MCA Page. 1


BANK MANAGEMENT SYSTEM 2022-2023

1.2 Project Description


Transaction: in banking transaction is the execution of a program that performs an
administrative or real time function, often by accessing shared data sources, usually on behalf
of a banking users who have an account in the respective bank. This transaction executed by
the program and it automatic do the transactions with balance and it check all conditions are
satisfied or not in respective proses. This is the more secure and automatic process which do
all the transaction with accuracy of calculation. In our project we also provide the facility to
link aadhar with account number and we also provide the facility to change location of account
with branch that mean the user can change the branch which is convenient for it. They will also
change or update data like address, mobile number using online banking system.

East west Institute of Technology Department of MCA Page. 2


BANK MANAGEMENT SYSTEM 2022-2023

CHAPTER 2
LITERATURE SURVEY
2.1 Introduction
Every software development requires a survey process. The survey process is needed to get the
requirements for the software. The survey also consists of studying the present system and
also about the tools needed for the development of the software. A proper understanding of the
tool is very much essential following an extract of the information of the material collected
during literature survey

2.2 Existing and Proposed System

2.2.1 Existing system

In [1], Information and communication technology (ICT) has helped to drive increasingly
intense global Competition. In the world history the most of the countries are most developed
because of they are financially very clear for how to use the high amount of money in the
developing process in own country . We also use the SOA architecture for providing the
scalable and reliable service therefor we studied related to the SOA architecture to know how
we use to implementation process in our project using Service Oriented Architectures
(SOA).we also refer the paper who give the case study information about Scandinavian bank
and a Swiss bank This two banks are working on the basis of service oriented architecture for
providing the service for the customer. SOA provides potential for greater organizational
agility (and thereby competitiveness).

In [2], in the second paper we learn which type of problems are created in banking system
during the different types of transactions. Here discuss about if any region the transaction may
be fail then how to avoid it and fixed it. We also studied about Firms in Italy defaulted more
against banks with high levels of past losses. This `selective' default increases where legal
enforcement is weak. Poor enforcement thus can create a systematic transaction risk by
encouraging banking users to defaulted masse once the continuation value of their bank
relationships comes into doubt. In banking sector the security also must and when we talk about
money or property this case is more sensational then we found the security is the major thing
to do in banking system.

In our project we provide the security questions when customer login with account to prevent
the fraud and provide the best security in the bank management system.

East west Institute of Technology Department of MCA Page. 3


BANK MANAGEMENT SYSTEM 2022-2023

2.2.2 Limitations of existing system

• Inconsistency in data entry, room for errors, miss keying information.


• Large ongoing staff training cost.
• System is dependent on good individuals.
• Reduction in sharing information and customer services & Lack of security.
• Time consuming and costly to produce reports.

2.2.3 Proposed System


The proposed system is highly computerized in which the data related to user accounts will be
secured high with high accuracy that even reduced the machine damage and human made errors
and this existing system is highly efficient to offer best services to the customers as well as
bank because it has user friendly access that customers less time when compare with a normal
banking system. When the data is entered it will check for its validity. Appropriate massages
are provided as when needed so that the user will not be in a maize of instant. The data entry
screen is design such a way that all the data manipulates can be performed, it also provide
record viewing facilities. Our Project developing as per the below figures. In the below fig (a)
this project is use for online banking system, the user can register first and then login. When
user login successfully they will perform the operation like money withdraw, money transfer,
deposit, aadhar link with own account, transfer account in one location to another location etc.
Admin has all authority to handle all the user account and transactions in a sequence to avoid
unauthorized user. Costumer can update his data like address, contact number etc. as well as
they link aadhar number with own account number using online banking system. User can
transfer money, deposit money, withdraw and check account balance through online banking
system. In Bank management system we use n-tier architecture which is helpful to handle
different tasks in fluently and sequential order.

2.3 Feasibility Study


Feasibility study is a study of project where it will verify whether the projected project is
technically and economically possible or not. In feasibility study we analyses the` project to
determine the ability to complete the project successfully with all the feasible cost and technical
services. Feasibility study main goal is analysing the entire feasible test for economical and
operational and function feasibility so that the proposed project cost will be not much
expensive.

East west Institute of Technology Department of MCA Page. 4


BANK MANAGEMENT SYSTEM 2022-2023

Feasibility study is a decision making of project documentation where it will provide idea to
perform the task by using this feasibility report. It also provides the economical and all the
technical cost and resources we needed to perform our task to propose our project. Feasibility
study also used for identifying the scope of our project.

Feasibility study is over all examination of project strength and weakness of project and
required cost to develop our project and also it will provide the problems available in the
offered system and what features we need to include in the existing system to overcome from
the problem of existing system. The feasibility study as follows

• Technical Feasibility

• Operation Feasibility

• Economical Feasibility
Technical Feasibility

The technology feasibility to the proposed system could be summarized as below.

Data storage
All information is stored in the MySQL database which best suited for distributed application,
it does not required any additional drivers to make transaction’s with database it is added
advantage, the proposed system works on the principle of client server architecture it does not
require additional software at client side to make the system functional .

Web server
Server which needs to execute continuously and serve client requests reliably, in this project
Apache web server is used for this purpose which provides service at 3306 dedicated port,
server has the potential to work concurrently and provide service to clients instantly, it works
best on Linux platform as it is a multiuser operating system. This server executes the PHP
programs efficiently.

Operational feasibility
The planned system is an effort to make use of web applications and internet services to design
a well generalized web site which act as communication media between users and the order
system and law.

Since users have rights to make complaint against the crime after being verified as a
authenticated users .only the register users can make a complaint over online regarding crime

East west Institute of Technology Department of MCA Page. 5


BANK MANAGEMENT SYSTEM 2022-2023

and miss guidance and even for providing illegal information on web sites which may create
problems to the accessed users.

Economic Feasibility

Economic practicableness determine whether or not the specified code is capable of generate
currency gain for a company. It involve the value of code development, calculable price of
hardware and code, price of maintenance. The aspects mainly verify whether the development
is cost-effective. In our proposed system, the development cost is optimized. The maintenance
cost of the proposed system will be less.

2.4 Tools and Technologies Used


pycharm as a Program development tool and technology implemented in python with
programming language with python framework, and server side implementation under python
server consisting of python database.

2.4.1 PyCharm
PyCharm is the most popular IDE used for Python scripting language. This chapter will give
you an introduction to PyCharm and explains its features.

PyCharm offers some of the best features to its users and developers in the following aspects
Code completion and inspection

Advanced debugging
Support for web programming and frameworks such as Django and Flask

Features of PyCharm
Besides, a developer will find PyCharm comfortable to work with because of the features
mentioned below −

Code Completion
PyCharm enables smoother code completion whether it is for built in or for an external package.
SQLAlchemy as Debugger
You can set a breakpoint, pause in the debugger and can see the SQL representation of the user
expression for SQL Language code.

East west Institute of Technology Department of MCA Page. 6


BANK MANAGEMENT SYSTEM 2022-2023

Git Visualization in Editor


When coding in Python, queries are normal for a developer. You can check the last commit
easily in PyCharm as it has the blue sections that can define the difference between the last
commit and the current one.

Code Coverage in Editor


You can run .py files outside PyCharm Editor as well marking it as code coverage details
elsewhere in the project tree, in the summary section etc.

Package Management

All the installed packages are displayed with proper visual representation. This includes list of
installed packages and the ability to search and add new packages.

Local History

Local History is always keeping track of the changes in a way that complements like Git. Local
history in PyCharm gives complete details of what is needed to rollback and what is to be
added.

Refactoring

Refactoring is the process of renaming one or more files at a time and PyCharm includes
various shortcuts for a smooth refactoring process.

User Interface of PyCharm Editor

The user interface of PyCharm editor is shown in the screenshot given below. Observe that the
editor includes various features to create a new project or import from an existing project.

East west Institute of Technology Department of MCA Page. 7


BANK MANAGEMENT SYSTEM 2022-2023

CHAPTER 3
SOFTWARE REQUIREMENT SPECIFICATION
3.1 Functional Requirement
It defines the functionality of the software and the constraints on it. Functional requirements
describe the features, functioning, and usage of a product/system/software for the perspective
of the product and its user. The document will not only define the product functions, user
characteristics and constrains but also serve as a basis for software design document.

3.1.1 Modules Description


The Modules description of Bank Account Management System project. These modules will
be developed in PHP source code and MYSQL database

1. Create New Account: A customer who having the account in the world can create a
virtual account through this module. This module receives the customer profile details
and the bank account details with the proof of the ownership of the bank account.
2. Login: Virtual account holders can login in to the system using this module. Thus this
is the secured login page for the customers in the website.
3. Bank Accounts: A customer may have more than one bank account in various banks,
in this case, the customer prompted to decide which bank account should reflect in the
account debit or amount credit. For these operations customers can add their owned
bank accounts here and it will be approved by the administrations of the system.
4. Fund Transfer: This is the module to make fund transfer to the virtual bank account
holders or the usual bank account holders from the customer's specified bank account.
5. Beneficiary: Beneficiary is a person who receives money. Here the customer can add
the beneficiaries to make fund transfer in the future.
6. Transactions: This module displays the transactions made by the customer in the
particular date with the transaction details.
7. Administrative Control: This module contains the administrative functions such as
view all virtual account, transactions, approve bank accounts, approve virtual accounts
etc.

East west Institute of Technology Department of MCA Page. 8


BANK MANAGEMENT SYSTEM 2022-2023

3.2 Non Functional Requirements


These are the requirements that specify criteria that can be used to judge the operation of a
system, rather than specific behaviour’s. These are constraints within which the system must
work. The non-functional requirements elaborates a performance characteristic of the system.
➢ Performance:
This includes the response time of the systems utilization level of both static and
volumetric type throughput etc. these parameters are standardized so a system has to
follow them.
➢ Recoverability:
A system should be able to make a recovery from a crash. It is required that system has
the inbuilt ability to recover themselves.
➢ Security:
Security measures should be embedded in the system to ensure that the records present
in the system are secure and no unauthorized personal can access them.
➢ Maintainability:
The system should be designed in such a way that they can be serviced and maintained
on a periodic basis.
➢ Environmental:
It is one of the legal and regulatory requirements as well. The system should be
designed in such way that its manufacturing and operation does not affect the
environment in a negative way. The carbon foot prints of the system should be below
the statutory limits.
➢ Interoperability:
The system should be designed in such way that it can work in integration with different
operating systems and they can be changed as per the requirement of the user.

East west Institute of Technology Department of MCA Page. 9


BANK MANAGEMENT SYSTEM 2022-2023

3.3 Software and Hardware Requirements


3.3.1 Hardware Requirements
➢ Processor: Pentium 4 or newer, Intel x86 or Apple silicon processor
➢ 512MB of RAM
➢ 10GB of hard drive space
➢ Monitor : 14 inch Color Monitor
➢ Keyboard : 108 Keys
➢ Mouse : Optical Mouse

3.3.2 Software Requirements


➢ Operation System: Windows 7/8/8.1/10, Linux, Mac OS X or 11.
➢ Front End: Python
➢ Back End: Python database
➢ Browser with JavaScript enabled (Chromium based, Firefox, Safari).

East west Institute of Technology Department of MCA Page. 10


BANK MANAGEMENT SYSTEM 2022-2023

CHAPTER 4

SYSTEM DESIGN

4.1 System Perspective


System designs is a process or art of defining the architecture, components, modules, interface
and data for a system to satisfy specified requirements. One could see it as the application of
system theory to product development.

The design process translates the requirements into the representation of the software that can
be assured for quality before coding design.

Fig. 4.1 System Overview

Description: Fig. 4.1 shows the working flow of this application.

East west Institute of Technology Department of MCA Page. 11


BANK MANAGEMENT SYSTEM 2022-2023

CHAPTER 5
DETAILED DESIGN
5.1 ER Diagram
An entity relationship diagram (ERD) shows the relationships of entity sets stored in a database.
An entity in this context is an object, a component of data. An entity set is a collection of similar
entities. These entities can have attributes that define its properties.

By defining the entities, their attributes, and showing the relationships between them, an ER
diagram illustrates the logical structure of databases. ER diagrams are used to sketch out the
design of a database.

Fig. 5.1 ER Diagram

Description: Fig. 5.1 describes the detailed control process of bank managements system

East west Institute of Technology Department of MCA Page. 12


BANK MANAGEMENT SYSTEM 2022-2023

5.2 Data Flow Diagram


A Data Flow Diagram (DFD) is a traditional visual representation of the information flows
within a system. A neat and clear DFD can depict the right amount of the system requirement
graphically. It can be manual, automated, or a combination of both.

It shows how data enters and leaves the system, what changes the information, and where data
is stored.

The objective of a DFD is to show the scope and boundaries of a system as a whole. It may be
used as a communication tool between a system analyst and any person who plays a part in the
order that acts as a starting point for redesigning a system. The DFD is also called as a data
flow graph or bubble chart.

Fig.5.2 Data Flow Diagram for New Account

Description: Fig. 5.2 describes data fetch from the user then stored in the database and show
the appropriate message to the user

East west Institute of Technology Department of MCA Page. 13


BANK MANAGEMENT SYSTEM 2022-2023

Fig.5.3 Data Flow Diagram for Withdraw/deposit account

Description: Fig. 5.3 describes deposit and withdraw amount

5.3 Database Design


5.3.1 Table used in the project

COLUMN TYPE

Account number Int(11)

Current balence Int(11)

Date of Creation date

Fullname Varchar2(10)

Date of Birth date

Mobile Number number(10)


gender
Varchar2(20)

East west Institute of Technology Department of MCA Page. 14


BANK MANAGEMENT SYSTEM 2022-2023

Nationality Varchar2(10)

KYC Varchar2(10)
Table 5.1 customer table
Description: Table. 5.1 table used to store the user details

5.3.2 Sample data

Account Current Mobile Fullname Date of Creation Date of


number balence Number Birth

123456 12000 7892210426 yashas 12/05/2022 06/05/2000

257890 20000 9902558362 chandan 22/06/2022 12/06/1999

3125456 3000 7895532456 sanjay 2/10/2022 29/05/2015

Table. 5.2 Sample value of user table


Description: Table. 5.2 shows the user some details

East west Institute of Technology Department of MCA Page. 15


BANK MANAGEMENT SYSTEM 2022-2023

CHAPTER 6

IMPLEMENTATION

6.1 Screenshots
Admin login

Fig . 6.1 : Admin login


Description: it describes the login activity of the admin

Create bank account

Fig . 6.2 : Create bank account


Description: it describes the creation of new account for customer by the admin

East west Institute of Technology Department of MCA Page. 16


BANK MANAGEMENT SYSTEM 2022-2023

Check account sum mary

Fig . 6.3 : Check account summary


Description: it displays all the details of the particular customer

Customer login

Fig . 6.4: Customer login


Description: it describes the login activity of the customer

East west Institute of Technology Department of MCA Page. 17


BANK MANAGEMENT SYSTEM 2022-2023

Deposit

Fig . 6.5: Customer login


Description: it describes the deposit activity done by the customer

East west Institute of Technology Department of MCA Page. 18


BANK MANAGEMENT SYSTEM 2022-2023

CHAPTER 7
SOFTWARE TESTING
The procedure of executing system with the target of finding error is outlined as testing. It can
also be defined as the process that defines, isolates, subjects to rectification of defects, and so
that the customer satisfaction is reached at last with the assurance of the system is free from
defects.

Software testing is a very important element of the quality assurance and it represents the SRS,
designing, coding and implementation of the system proposed.

7.1 Levels of testing

7.1.1 Test Planning


Test plan is the document that gives the information regarding the procedure that is to be
followed in performing various tasting on the whole application.
This document involves scope and objectives of the testing, areas that are to be tested and areas
that should not be tested, scheduling of resources available, the area that need to be automated
and various tools that are used for testing.
7.1.2 Test Development:
Test development involves development of test cases and their procedural preparation i.e.
description of the developed test cases.
Types of testing:

Various types of testing that are done on the system are as follows:

i. Unit testing
ii. Integration testing
iii. System testing

Unit testing
As the name itself says, this type of testing is done on small units of the system. A part of the
system is considered as a unit and its testing is done. If as an example, login page considered;
the user or the administrator can enter into their respective home pages only after giving the
valid username and password. This part of validating a system, by considering Login as a unit
can be said as a unit testing.

East west Institute of Technology Department of MCA Page. 19


BANK MANAGEMENT SYSTEM 2022-2023

Integration testing
This part of testing deals with the testing procedure. It involves, testing of various integrations
of several units. It checks whether the system is functioning correctly when two or more units
are integrated together. This part of testing gives information about order of arrangements of
various units, integrating modules, systems, sub-systems and the entire system as a whole.

System testing
This testing technique deals with the process of testing the system as a whole. At the end of
each project, all defects are removed and the interface errors are uncovered in order to achieve
the good functioning of the whole system. This testing technique can be called as the final part
of whole testing process.

7.2 Test cases


Test case ID Test cases Test case Status Remarks
Description
Searching The admi or
1 Search account number pass customer
for customer searching with
details,deposit proper account
and withdraw number
The users abele
Check whether to login to the
2 Login the admin or pass application with
custome can the verified
login the username and
application password
correctly
Admin have fill All the
3 Create new all the details of pass filleddetails are
account the customer currect

East west Institute of Technology Department of MCA Page. 20


BANK MANAGEMENT SYSTEM 2022-2023

Customer need If account


4 Check balance fill the correct Pass number is
account number correct it shows
balance
Admin need fill If account
5 Delete account the correct pass number is
account number correct it shows
account deleted
Table 7.1 Test Case

Description: Table 7.1 shows the all test performed on this application.

East west Institute of Technology Department of MCA Page. 21


BANK MANAGEMENT SYSTEM 2022-2023

CHAPTER 8

CONCLUSION AND FUTURE ENHANCEMENT


I have successfully designed, develop and implemented this Bank customers Management
system which provides a more secured approach in managing bank customer’s information and
strengthens the relationships between banks and their customers by providing the right
solutions that uses a multilevel security to improve customer satisfaction. I therefore
encourages other developers of similar application to think twice on how best they can improve
in developing a more secured system that will meet the challenges we face today especially on
the banking sector and other financial institutions.

This project is developed to nurture the needs of a user in a banking sector by embedding all
the tasks of transactions taking place in a bank. Future version of this project will still be much
enhanced than the current version. Writing and depositing checks are perhaps the most
fundamental ways to move money in and out of a checking account, but advancements in
technology have added ATM and debit card transactions. All banks have rules about how long
it takes to access your deposits, how many debit card transactions you're allowed in a day, and
how much cash you can withdraw from an ATM. Access to the balance in your checking
account can also be limited by businesses that place holds on your funds. Banks are providing
internet banking services also so that the customers can be attracted. By asking the bank
employs we came to know that maximum numbers of internet bank account holders are youth
and business man. Online banking is an innovative tool that is fast becoming a necessity. It is
a successful strategic weapon for banks to remain profitable in a volatile and competitive
marketplace of today. If proper training should be given to customer by the bank employs to
open an account will be beneficial secondly the website should be made friendlier from where
the first time customers can directly make and access their accounts

East west Institute of Technology Department of MCA Page. 22


BANK MANAGEMENT SYSTEM 2022-2023

BIBLIOGRAPHY
1. Fundamentals of database systems by (Elmasri Navathe, 2000),
Website:https://archive.org/stream/FundamentalsOfDa tabaseSystemselmasrinavathe#
page/n51/mode/2up, Page: From 52 to more.
2. [2] Article: Online banking, Website: https://en.wikipedia.org/wiki/Online_banking
3. [3] Online Bank Account Management System Website: http://www.slideshare.net
4. [4] Learning Python by http://www.w3schools.com
5. [5] Pthon and Tinker video tutorial Durgasoft online.com
6. [6] Veneeva, V. (2006), “E-Banking (Online Banking) and Its Role in Today's Society”, Ezine
articles Python Durgasoftonline.com.
7. Fundamentals of database systems by (Elmasri Navathe, 2000),
Website:https://archive.org/stream/FundamentalsOfDatabaseSystemselmasrinavathe
8. Article: Online banking, Website: https://en.wikipedia.org/wiki/Online_banking June 29,
2015, 12.30 am.
9. Online Bank Account Management System Website: http://www.slideshare.net (Collect some
info for report documents, 2014- 2015)

East west Institute of Technology Department of MCA Page. 23

You might also like