BANK MANAGEMENT SYSTEM

SYNOPSIS
ON

BANK
MANAGEMENT
SYSTEM

Submitted in the partial fulfillments of the Requirements

For the award of

Master of Science in Information Technology

From

……….

1
BANK MANAGEMENT SYSTEM

Submitted By:--

INTRODUCTION
In day-to- day work process of an organization, there are lots of things happening,
which need to be keep tracked. For our ease in future, we do too. Of course there
is lots of way to perform this task. We can either maintain these records manually
or by using computerized system. In current scenario, where we always thing to
increase productivity utilizing our working hours more and more, it’s always
recommended to go for such automated system, which provide me maximum
facility to do the same in a less time and minimum manpower. So I think and
design a commercial project for Bank Management System system.
A computer based management system is designed to handle all the primary
information required to calculate monthly statements of customer account which
include monthly statement of any month. Separate database is maintained to
handle all the details required for the correct statement calculation and generation.
This project intends to introduce more user friendliness in the various activities
such as record updation, maintenance, and searching. The searching of record has
been made quite simple as all the details of the customer can be obtained by
simply keying in the identification or account number of that customer. Similarly,
record maintenance and updation can also be accomplished by using the account
number with all the details being automatically generated. These details are also
being promptly automatically updated in the master file thus keeping the record
absolutely up-to-date.
For processing the data we have chosen Access as back end and Visual Basic as
front end, which can manage database for a very large class of the possible
application.
This project is client-server based application system, to computerize at bank
work. The modules involved currently in this system are: Open Account, Close or
Edit Account, Monthly statement, Bank summary

2
BANK MANAGEMENT SYSTEM

INDEX

Title of the Project 4

Objective of the Project. 5

Languages & Tool to be used. 6

Requirement Analysis. 7

Module Description. 9

Data Structure. 12

Table Structure. 13

Data Flow Diagram. 16

Future Scope of the Project. 17

3
BANK MANAGEMENT SYSTEM

TITLE OF THE PROJECT

BANK MANAGEMENT
SYSTEM

4
BANK MANAGEMENT SYSTEM

OBJECTIVE OF THE PROJECT

During the past several decades personnel function has been transformed from a
relatively obscure record keeping staff to central and top level management function.
There are many factors that have influenced this transformation like technological
advances, professionalism, and general recognition of human beings as most
important resources.

A computer based management system is designed to handle all the primary

information required to calculate monthly statements of customer account which
include monthly statement of any month. Separate database is maintained to handle all
the details required for the correct statement calculation and generation.
A computer based management system is designed to handle all the primary
information required to calculate monthly statements of customer account which
include monthly statement of any month. Separate database is maintained to handle all
the details required for the correct statement calculation and generation.
The main objective of our project is provide the different typed of customers facility ,
the main objective of this system is to find out the actual customer service . Etc.

It should fulfill almost all the process requirements of any Bank.

It should be user friendly.

• It should increase the productivity of bank by utilizing the

working hours more and more, with minimum manpower.

This project includes the entire upgraded feature required for the computerization
banking system. This system is very easy to use, so that any user can use without
getting pre-knowledge about this. Its very much user friendly and meet almost all
daily working process requirements. This system is completely GUI based and can
be use by mouse and as well as keyboard. This system is melded in such a way
that has got all features to upgrade without making much change in existing
components.

5
BANK MANAGEMENT SYSTEM

LANGUAGE TOOLS TO BE USED

After considering all the above-mentioned factors, we decided to go
for following software specification.

• Visual Basic.

• Microsoft Access (back end database).

1. Visual Basic 6.0:- --For this project I have used VISUAL BASIC.
Because it Is a very powerful programming language to develop
sophisticated windows?
Program quickly. It is one of the rapid application tools, as it enables to
develop
Application very easily and quickly.

2. MS Access: -- I have used MS.ACCESS for database. It is a RDBMS

Package developed by Microsoft. It is a relational database management
system
That efficiently stores, retrieves and manages large amounts of data.

3. Package and Development Wizard: -- IT IS

COMES WITH VISUAL STUDIO 6.0 UNDER “MICROSOFT
VISUAL STUDIO 6.0 TOOLS “. WE WILL USE THIS TOOL FOR
MAKING SETUP DISK OR INSTALLER OF THIS SOFTWARE
TO INSTALLING IT IN THE CLIENTS SYSTEM EASILY .IT
FULLY SUPPORT THE VISUAL BASIC PROJECT FILES OR IT
IS MADE FOR VISUAL BASIC. SO WE USE THIS SOFTWARE
IN PLACE OF INSTALLED SHELLED

6
BANK MANAGEMENT SYSTEM

REQUREMENT ANALYSIS
We have spent a week to do the analysis of this system. The analysis phase
include three-sub phase: these are Requirement Analysis, Software Analysis and
Hardware Analysis.
To collect the requirement information about this system we visited few Bank
organization including SBI, CBI, ICICI, IDBI etc. We obseb all the manual
process. How they keep track of the opening account, transaction and also are
bank employee transaction. Seen the format of enquiry and account form. After
reviewing the entire format for the above bank we design the format of enquiry
form bank account any all transaction, so that maximum facility can be provided.
Hope after the release of automated system, user will be able to do work much
faster than what they currently do and also manpower can be better utilized.

1. Software Analysis: To freeze the software requirement for this specific

system , we analyst few existing system available on internet and also take guide
line from software professionals. The factor we considered and analyst the
software is:
 The process time to execute the use request.
 Database communication with the front end.
 Multi user sport for database side.
 Easy availability of software.
 Less development time.
 Easy up gradation.
 Attractive user interface.
 Easy to available the input fields.
 Less source code writing.
 Easy to learn the tool.
 Compatible with hardware.
 Easy to access the system recourse.

7
BANK MANAGEMENT SYSTEM

 Security.
After considering all above-mentioned factors we decide to go for following
software specification.
 Visual Basic 6.0 (front end).
 Microsoft Access (back end database).

2. Hardware Analysis: To analyze the hardware requirement, we consult little

software developer and considered the following factors:
 Capability with software.
 Minimums memory requirement to development the software as well as
the application system we are going to developed.
 Minimum cost.

By considering the above factor we decide the following hardware

specification.
 Pentium I-above.
 64 MB RAM and above.
 10 GB HDD.
 Keyboard.
 Mouse.
 FDD.

8
BANK MANAGEMENT SYSTEM

MODULE DESCRIPTION
To develop software which maintain all the record of day to day -Open
Account, Close or Edit Account, Monthly Statement, Bank summary and
Transaction detail etc. All the record and information is going to be store in
Microsoft Access Database.

Overall description: -
The project consists of four parts mainly

1. Open Account: -
It consists of new bank account form. A consist new enquiry information who
come to the bank for enquiry about new account (saving, current). Then he or she
fill up the new account form according to their account number generated
automatically and also generate cheui no automatically.

2. Close or Edit Account:-

It consists or provides editing and closing account form and also such
particular account information.

3. Monthly Statement: -
It consists of two sided form monthly statement of bank employee
and monthly statement of saving and current account employee.

4. Bank Summary: -
It consists of all information detail of bank employee account
transaction detail summary, recode of all branches and also record of
draft and chewy.

9
BANK MANAGEMENT SYSTEM

Functional Module: -

The whole project divided in to six main modules. They are following:
-

i. Login module.
ii. Account open module.
iii. Edit or close module.
iv. Transaction module.
v. Summary module.
vi. Account statement module.
Main module:-

Bank Management System

Statement
Module
Login
Module
Account Summery
open Module
Module

Edit Or close
Module Transaction
Module

10
BANK MANAGEMENT SYSTEM

i. Login Module: -
Login module consists of three forms.

Frmsplash: - frmsplash is responsible to load the project for use.

Frmlogin: - Frmlogin is responsible for accepting the login name and password
from the user. This security the system from unauthorized access. A user has
change the password has three times only. If or she inter wrong password thrice,
then it will automatically exit.

FrmMain: - frmmain is the main form of the whole project. Through which we
can access form of project this is a sdi form include other form in these main form
like open Account form, Close and edit Account form, transaction form summery
form statement form.

Login
Module

FrmMain
Frmsphlas
Frmlogin

11
 BANK MANAGEMENT SYSTEM

DATA STRUCTURE
Database design including details table structure their relation and the use for
specific modules. The complete listing of table is as follows:

 Account.
 Account type.
 Balance.
 Cheque.
 Pass.
 Temp table.
 Transaction table.

DATABASE

Account Transaction table

Temp Table.
Account Type

Balance. Pass

Cheque.
Pass.
12
BANK MANAGEMENT SYSTEM

TABLE STRUCTURE

The detail structure and description of table are as follows:

Table Structure and Description:
1. Account: -

Account
Fieldname Field Type Field size Constraint
Actno Number Long int Primary
Name Text 50
Address Text 50
Phone Number Double
Act type Text 20
City Text 50
Date Date/time Medium
date
Chequebook Yes/no

This table is used to maintain open account details. Where employee come
from new account. Which keep all information about employee. Here act no
define primary key.

ii. Account Type: -

Account type
Fieldname Field type Field size Constraint

13
BANK MANAGEMENT SYSTEM

Type code Text 50

Type name Text 50

Int rate Number Default

This table is used for which type of account opens a employee, type of account
– saving or current account and also give a account type code.

iii. Balance table: -

Balance table
Field Field type Field size Constraint
name
Actno Number Default
Balance Number Long
int

This table the balance of all type of account, saving or current account.

iv. Cheque Table: -

Cheque table
Field name Field type Field size Constraint
Actno Number Default
No _from Number Default
No _to Number Default

14
BANK MANAGEMENT SYSTEM

This table content all account detail and if you open new account and chose
cheque option so give cheque no of your account.

v. Pass table: -

Pass table
Field name Field type Field size Constraint
Name Text 50
Pswd Text 50

vi. Tamp Table: -

Tamp table
Field name Field type Field size Constraint
Actno Number Long int
Temp type Text 50
Ckequeno Number Long int
Amount Number Long int
Date Date/time

This table show the tamp let of all account information and transaction of per
day of bank.

Vii. Transaction.1 table: -

Transaction table
Field name Field type Field size Constraint
Actno Number Long int Primary
Tran type Text 50

15
BANK MANAGEMENT SYSTEM

Amount Number Long int

act Type Text 50
Chequeno Number Long int
Date Date/time Default
Time Date/time Default

. This table contain all per day transaction of bank and also summarized all
money transaction updating and editing

DATA FLOW DIAGRAM

Diagram (Design) :- Designing if system demonstrates the exact flow of I-P-O
cycle of the system. I-P-O cycle is Input-Process-Output cycle of the system, where
we need to define what are input we need to take to produced the output, which is our
requirements. According to this input and output we design the processing phase.
There are lot of category define to design the system few of them are begin discus
here.
Data Flow Diagram: -

New Fills enquiry

Enquiry
Request for
customer Form New Account
New Control
Account Management

Provide Account Type

Send

New

16
BANK MANAGEMENT SYSTEM

Account

Request.

Provide Account Number / Cheque Number

Account
Process

Account Details

FUTURE SCOPE OF THE PROJECT

This project can be used in the bank after adding some more useful modules in
the project for which banks are providing services, like – opening saving or
current account, giving loans, providing credit or debit card services, ATM
services, services like payment of electricity bills, telephone bills.
Utmost care and back-up procedures must be established to ensure 100%
successful implementation of the computerized banking system. In case of
system failure, the organization should be in a position to process the
transaction with another organization or if the worst comes to the worst, it
should be in a position to complete it manually.
This project has been designed in such a way that, its can further upgraded
very easily. The main advantage of this system is it’s modularity. This system
helps the management to manage to eternal as well as external work. It can
also used to sentinel database of all bank, so that all the transaction will be
online and easily manageable. This system can also be integrated with account
department. The employee module can also be integrating onto this system, so
the bank employee record also is automated.

17