BANK MANAGEMENT SYSTEM

ABSTRACT

The Bank Account Management System is a desktop application for maintaining

a person's account in a bank. This project contains the working of a banking account
system and cover the basic functionality of a Bank Account Management System. To
develop a project for solving financial applications of a customer in banking
environment in order to nurture the needs of an end banking user by providing various
ways to perform banking tasks. Also to enable the user’s work space to have additional
functionalities which are not provided under a conventional banking project. The Bank
Account Management System undertaken as a project is based on relevant technologies.

The main aim of this project is to develop software for Bank Management
System. This project has been developed to carry out the processes easily and quickly,
which is not possible with the manuals systems, which are overcome by this software.
This project is developed using VB.NET language and MS SQL use for database
connection. Creating and managing requirements is a challenge of IT, systems and
product development projects or indeed for any activity where you have to manage a
contractual relationship. The project analyzes the system requirements and then comes
up with the requirements specifications. It studies other related systems and then come
up with system specifications. The system is then designed in accordance with
specifications to satisfy the requirements. The system design is then implemented with
MS SQL and VB.NET. The system is designed as an interactive and content
management system. The content management system deals with data entry, validation
confirm and updating whiles the interactive system deals with system interaction with
the administration and users. Thus, above features of this project will save transaction
time and therefore increase the efficiency of the system.
INTRODUCTION

OVERVIEW OF THE PROJECT

The “Bank Management System” project is a desktop banking application. This

application enables the banking admin to perform the basic banking transactions by
sitting at bank through PC or laptop. The system provides the access to the admin to
create an account, deposit/withdraw the cash from bank account, also to view reports of
all accounts present. The admin can access the banks application for viewing customer
account details and perform the transactions on account as per requirements. With
Desktop Banking, the brick and mortar structure of the traditional banking gets
converted into a click and application model, thereby giving a concept of systematic
banking a real shape. Thus today's banking is no longer confined to branches.

The primary aim of this “Bank Management System” is to provide an improved

design methodology, which envisages the future expansion, and modification, which is
necessary for a core sector like banking. This necessitates the design to be expandable
and modifiable and so a modular approach is used in developing the application
software. Anybody who is an Account holder in this bank can become a member of
Bank Account Management System.

Bank is the place where customers feel the sense of safety for their property. In
the bank, customers deposit and withdraw their money. Transaction of money also is a
part where customer takes shelter of the bank. Now to keep the belief and trust of
customers, there is the positive need for management of the bank, which can handle all
this with comfort and ease. Smooth and efficient management affects the satisfaction of
the customers and staff members, indirectly. And of course, it encourages management
committee in taking some needed decision for future enhancement of the bank.
SYSTEM SPECIFICATION

HARDWARE REQUIREMENTS SPECIFICATION

Processor : Intel Pentium III or later

Main Memory(RAM) : 256 MB

Cache Memory : 512 KB

Monitor : 14-inch Color Monitor

Keyboard : 108 Keys

Mouse : Optical Mouse

Hard Disk : 160 GB

SOFTWARE REQUIREMENTS SPECIFICATION

Front End/Language : VB.NET

Back End/Database : MS SQL SERVER

Additional Tools : Visual Studio 2013 and SQL Server Studio

Operating System : Windows 7, 8, 9 and 10

SOFTWARE FEATURES

WINDOWS OPERATING SYSTEM

Systems developed, marketed, and sold by Microsoft. It consists of several

families of operating systems, each of which cater to a certain sector of the computing
industry. Active Windows families include Windows NT, Windows Embedded and
Windows Phone; these may encompass subfamilies, e.g. Windows Embedded Compact
(Windows CE) or Windows Server. Defunct Windows families include Windows 9x and
Windows Mobile.

Microsoft Windows (or simply Windows) is a meta-family of graphical operating

Microsoft introduced an operating environment named Windows on November 20, 1985,
as a graphical operating system shell for MS-DOS in response to the growing interest in
graphical user interfaces (GUIs). Microsoft Windows came to dominate the world's
personal computer market with over 90% market share, overtaking Mac OS, which had
been introduced in 1984.

However, since 2012, it sells less than Android, which became the most popular
operating system in 2014, when counting all of the computing platforms Windows runs
on (same as Android); in 2014, the number of Windows device sold were less than 25%
of Android devices sold.

As of July 2015, the most recent version of Windows for personal computers,
tablets and smart phones is Windows 10. The most recent versions for server computers
and embedded devices are respectively Windows Server 2012 R2 and Windows
Embedded 8. A specialized version of Windows runs on the Xbox One game console.

The next server version of Windows is Windows Server 2016, which is expected
to be released in early 2016.
OVERVIEW OF THE FRONT-END

VISUAL BASIC .NET

Visual Basic .NET (VB.NET) is an object-oriented computer programming

language implemented on the .NET Framework. Although it is an evolution of classic
Visual Basic language, it is not backwards compatible with VB6, and any code written
in the old version does not compile under VB.NET.

Like all other .NET languages, VB.NET has complete support for object-oriented
concepts. Everything in VB.NET is an object, including all of the primitive types (Short,
Integer, Long, String, Boolean, etc.) and user-defined types, events, and even
assemblies. All objects inherit from the base class Object.

VB.NET is implemented by Microsoft's .NET framework. Therefore, it has full

access to all the libraries in the .Net Framework. It is also possible to run VB.NET
programs on Mono, the open-source alternative to .NET, under not only Windows, but
also even Linux or Mac OSX.

The following reasons make VB.Net a widely used professional language:

⦁ Modern, general purpose.

⦁ Object oriented.
⦁ Component oriented.
⦁ Easy to learn.
⦁ Structured language.
⦁ It produces efficient programs.
⦁ It can be compiled on a variety of computer platforms.
⦁ Part of .Net Framework.
OVERVIEW OF THE BACK-END

MS SQL SEREVR

Microsoft SQL Server is a relational database management system developed by

Microsoft. As a database server, it is a software product with the primary function of
storing and retrieving data as requested by other software applications, which may run
either on the same computer or on another computer across a network (including the
Internet).

Microsoft markets at least a dozen different editions of Microsoft SQL Server,

aimed at different audiences and for workloads ranging from small single-machine
applications to large Internet-facing applications with many concurrent users.

Since the release of SQL Server 1.0 in 1989, SQL Server has evolved to become
a true, enterprise information platform. While its core function is that of an RDBMS,
SQL Server has become much more than that. SQL Server 2016 includes built-in
business intelligence tools, as well as a range of analysis and reporting tools. This is on
top of the database management tools such as database creation, backup, replication,
security, and more.

DATABASE MANAGEMENT TOOLS

SQL Server comes with a number of tools to help you with your database
administration and programming tasks.

Some typical database administration and programming tasks could include:

⦁ Create & maintain databases

⦁ Create & maintain tables
⦁ Create & maintain other database objects such as stored procedures, views, etc
⦁ Create & maintain and schedule data backups
⦁ Replication (eg, create a copy of the database)
⦁ Create & maintain users, roles, etc
⦁ Optimization tasks
SYSTEM ANALYSIS
System analysis is a process of gathering and interpreting facts, diagnosing
problems and the information to recommend improvements on the system. It is a
problem solving activity that requires intensive communication between the system users
and system developers. System analysis or study is an important phase of any system
development process.

The system is studied to the minutest detail and analyzed. The system analyst
plays the role of the interrogator and dwells deep into the working of the present system.
The system is viewed as a whole and the input to the system are identified. The outputs
from the organizations are traced to the various processes.

System analysis is concerned with becoming aware of the problem, identifying

the relevant and decisional variables, analyzing and synthesizing the various factors and
determining an optimal or at least a satisfactory solution or program of action.

The development of a computer-based information system includes a system

analysis phase. This helps produce the data model, a precursor to creating or enhancing
a database. There are a number of different approaches to system analysis. When a
computer-based information system is developed, system analysis (according to the
Waterfall model) would constitute the following steps:

⦁ The development of a feasibility study: determining whether a project is

economically, socially, technologically and organizationally feasible

⦁ Fact-finding measures, designed to ascertain the requirements of the system's

end-users (typically involving interviews, questionnaires, or visual observations of
work on the existing system)

⦁ Gauging how the end-users would operate the system (in terms of general experience
in using computer hardware or software), what the system would be used for and so
on
EXISTING SYSTEM
The existing system is a manual one using which the banking agent cannot
maintain the effectively by sharing across different branches with proper security and
cannot track details easily. It does not provide proper co-ordination between different
departments of the company. It does not allow the customer to check the status of his
file in proper way, which leads customer dis-satisfaction.
EXISTING SYSTEM DISADVANTAGES

⦁ No graphical password for admin authentication.

⦁ MDI form based application is not developed.
⦁ Customer management is not user friendly and customer image is not used for
authorization.
⦁ Admin panel is not developed by using the flat user interface concept.
⦁ Customer account management makes more error while processing the data.
⦁ More complexity in banking financial transaction module.
⦁ The loan module is not including in the existing system.
⦁ Report generation takes more time.
PROPOSED SYSTEM
PROPOSED SYSTEM ADVANTAGES

⦁ Color graphical password used for admin authentication.

⦁ MDI form based application is developed for bank management.
⦁ Customer management is user friendly and customer image is used for authorization.
⦁ Admin panel is developed by using the flat user interface concept.
⦁ Customer account management errors are debugged completely.
⦁ No complexity in banking financial transaction module.
⦁ The loan module is including in the proposed system.
⦁ Report generation takes less time.
SYSTEM DESIGN AND DEVELOPMENT

MODULE DESCRIPTION

ADMIN

The admin module is used to manage entire banking application. The admin
should select correct colors for login into the application. Through this module the
admin can manage the following modules. Admin can add, delete, update, view and
search the data.

CUSTOMER

The customer module is used to manage the customer details like customer
name, gender, contact details, aadhaar, pan card details and more. This customer module
is primary module of the application. This module is connected with following modules.

ACCOUNT

The account module is used to create and manage the customer banking account
details. The admin can maintain two types of account details. This module supports to
maintain savings and current account details.

TRANSACTION

The transaction module is an important module of the application. In this module

the admin can add and manage the deposit and withdrawal details. the financial details
are completely managed by this module. This module is connected with account module.

LOAN

The loan module contains two sub modules. The first sub module is loan apply
module. The second module is loan pay module. This module helps to manage the loan
and EMI payment details.

REPORT

The report module is used to generate the system report as PDF format. The
admin can generate the report by using this module. The report module is developed by
using the crystal reporter application.
TABLE DESIGN

TABLE NAME: ADMIN

COLUMN DATA TYPE SIZE CONSTRAINT DESCRIPTION

AID Int 15 Primary Key Admin ID

Username Varchar 15 Not Null Username

Password Varchar 15 Not Null Password

TABLE NAME: CUSTOMER

COLUMN DATA TYPE SIZE CONSTRAINT DESCRIPTION

CID Int 15 Primary Key Customer ID

Photo Image Not Null Customer Image

Name Varchar 30 Not Null Name

Gender Varchar 6 Not Null Gender

DOB Date 3 Not Null Date of Birth

Aadhaar Big Int 12 Not Null Aadhaar

Pan Varchar 15 Not Null Pan Card No

Address Varchar 50 Not Null Address

Mobile Big Int 12 Not Null Mobile No

Email Varchar 30 Not Null Email ID

DoR Date 3 Not Null Date of Record

TABLE NAME: ACCOUNT

COLUMN DATA TYPE SIZE CONSTRAINT DESCRIPTION

AID Int 15 Primary Key Account ID

CID Int 15 Foreign Key Customer ID

Type Varchar 10 Not Null Account Type

Balance Int 10 Not Null Account Balance

DoA Date 3 Not Null Date of Account

TABLE NAME: TRANSACTION

COLUMN DATA TYPE SIZE CONSTRAINT DESCRIPTION

TID Int 15 Primary Key Transaction ID

AID Int 15 Foreign Key Account ID

Type Varchar 10 Not Null Transaction Type

Particulars Varchar 150 Not Null Particulars

Amount Int 10 Not Null Amount

DoT Date 3 Not Null Date of

Transaction
TABLE NAME: LOAN APPLY

COLUMN DATA TYPE SIZE CONSTRAINT DESCRIPTION

LAID Int 15 Primary Key Loan Apply ID

CID Int 15 Foreign Key Customer ID

LName Varchar 30 Not Null Loan Name

Amount Decimal 15 Not Null Amount

LTerms Int 5 Not Null Loan Terms

IntPercen Int 10 Not Null Percentage

IntAmt Int 15 Not Null Interest Amount

EMI Int 15 Not Null Loan EMI

Paid Amount Decimal 12 Not Null Paid Amount

Bal Amount Decimal 12 Not Null Bal Amount

Paid Terms Int 10 Not Null Paid Terms

Bal Terms Int 15 Not Null Bal Terms

Date of Loan Date 3 Not Null Date of Loan

TABLE NAME: LOAN PAY

COLUMN DATA TYPE SIZE CONSTRAINT DESCRIPTION

PID Int 15 Primary Key Pay ID

LAID Int 15 Foreign Key Loan Apply ID

CID Int 15 Foreign Key Customer ID

EMI Int 12 Not Null Loan EMI

MoPay Varchar 12 Not Null Mode of Pay

DoPay Date 3 Not Null Date of Pay

DATA FLOW DIAGRAM

Data moves in a specific direction from an origin to destination

PROCESS

Procedure s people or devices that use or transform data

EXTERNAL ENTITY

This defines a source (originator) or destination of system data.

DATA STORE

This indicates where data is stored in the system.

LEVEL 0

Request
Login Banking
Admin Admin
System

Response

LEVEL 1
Open Modules Store
Admin Customer Customer
Fetch

Store
Account Account
Fetch

Store
Transaction Transaction
Fetch

Store
Loan Loan

Fetch
Report
REPORT Generate
ER DIAGRAM

An entity–relationship diagram (ER diagram for short) describes interrelated

things of interest in a specific domain of knowledge. A basic ER model is composed of
entity types (which classify the things of interest) and specifies relationships that can
exist between instances of those entity types. In software engineering, an ER diagram is
commonly formed to represent things that a business needs to remember in order to
perform business processes. Consequently, the ER diagram becomes an abstract data
model that defines a data or information structure, which can be implemented in a
database, typically a relational database.

ER DIAGRAM SYMBOLS

ATTRIBUTE

ENTITY

RELATIONSHIP

ER DIAGRAM CARDINALITY

ZERO OR ONE (0/1)

MANY (M)

ONE (1)

ONE ( AND ONLY ONE ) (1&1)

ZERO OR MANY (0/M)

ONE OR MANY (1/M)

ER DIAGRAM

Username CID
1 M
Admin Customer
Password Name
1
Addr

AID
Mob
Account Has
1 CID Aadhaar

Type
Contains Pam
Balance
M
TID
DoA
Transaction
Contains
AID

MLAID
Type
Loan Pay
CID Particular

LName Amount

Amount DoT

LTerms

IntPercen

EMI

DoL