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.
3
17
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).
Microsof t 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
Summery Module
Account open 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
Frmsphlas
FrmMain 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: Fieldname Actno Name Address Phone Act type City Date
Account Field Type Number Text Text Number Text Text Date/time
Field size Constraint Primary Long int 50 50 Double 20 50 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
13
Constraint
BANK
MANAGEMENT SYSTEM
Type code
Text
50
Type name Text Int rate Number
50 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: Field name Actno Balance
Balance table Field type Field size
Number Number
Constraint
Default Long int
This table the balance of all type of account, saving or current account.
iv. Cheque Table: -
Field name
Cheque table Field type Field size
Actno
Number
Default
No _from
Number
Default
No _to
Number
Default
14
Constraint
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: -
Field name
Pass table Field type Field size
Name
Text
50
Pswd
Text
50
Constraint
vi. Tamp Table: Field name Actno
Tamp table Field type Field size Number Long int
Temp type
Text
50
Ckequeno
Number
Long int
Amount
Number
Long int
Date
Date/time
Constraint
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 Actno
Field type Number
Field size Long int
Tran type
Text
50
15
Constraint Primary
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 customer
Fills enquiry Form
Enquiry New Account
Request for New Account
Provide Account Type
Send New 16
Control Management
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
