Bank Management System.docx

This is my College Project Documentation on Bank Management System. Which includes mainly Problem Definition, Existing System, Proposed System, Requirement Analysis, Scope of the System, Feasibility Study, Hardware & Software Requirement, ER Diagram, DFD Diagram, Data Dictionary for Project, Sample Output Screenshots, Conclusion

1. 1

Bank Management System
SUBMITED BY
1. Nikhil Ishwar Patil
GUIDED BY :- Mrs. Chavhan Pallavi

Department Of Computer Science.
K.K.Wagh Arts, Commerce, Science and Computer Science College.
Nashik 422003
Academic Year2020-2021

2. 2


KarmaveerKakasahebWagh Education Society’s
K. K. Wagh Arts Commerce, Science,
&ComputerScienceCollege Saraswati Nagar Nashik-422003
C E R T I F I C A T E


This is to certify that
Mr./Miss . Nikhil Ishwar Patil_____ Has satisfactorily
completed his/her/their project on Bank Management System
fulfilment in SY.BBA (CA) Department for the
academic year 2020- 2021.




Prof. Chavhan Pallavi. Prof BAVA V.H.
(Project Guide ) H.O.D. of BBA(CA)

Internal Examiner External Examiner

3. 3


ACKNOWLEDGEMENT
We own our sincere gratitude to all those people who have given us their constant
support and encouragement without which our project report would not have
reached this stage.
We would like to express our thanks to Prof.Chavhan Pallavi For her /his advice
and encouragement. She/he has been pillar of strength right through the project till
the preparation of this report and helped by boosting moral, so we could surmount
the difficulties that came across during completion of this project.
We would like to express our gratitude to Dr.A.P.Rajput, Principal, K.K.Wagh
Arts, commerce, science and Computer Science College. And Prof. Bava V.H.
Head of BBA(CA) department for the support and the infrastructure they
have provide, so that we could successfully complete the project on time.
Last but not the list we would like to express our sincere thanks to all staff
members and our friends for their help and cooperation in all phases of
the project.

4. 4

INDEX


Sr.No Title Page NO.
1. Problem Definition.
5
2. Existing System.
6
3. Proposed System.
7
4. Requirement Analysis
8
5. Scope of the system
9
6. Feasibility study
10
7. H/w and s/w requirement.
12
8. ERD.
13
9. DFD
14
10. Data Dictionary.
16
11. Sample I/O Screen.
17
12. Conclusion
21
13. Future Enhancement
22
14. Bibliography
23

5. 5





























Problem Definition

Technology has changed the way many tech-savvy customers do their banking.
The onset of online banks has made it possible for customers to conduct all banking
virtually, without ever having to visit a brick-and-mortar location. Choosing between
online banking and traditional banking is mainly a matter of preference, but the latter
does offer plenty of features many customers would consider a major disadvantage.
Limited Accessibility -
Accessibility at traditional banks is limited, as you can only conduct
business at their brick-and-mortar locations. If you’re traveling or unable to make it
into the location during standard hours of operation, you won’t be able to do business.
Less Efficient -
Getting in the car, driving to a bank and waiting in line to be served takes
up your valuable time. It is more efficient to do your banking online, where you can
open new accounts, set up auto bill pay, check account balances and transfer funds all
from your own computer.
Recognition of problem -
A new opportunity that the present system cannot handle pressures
Managers, non- managers or environment elements usually recognize problems very
rarely by information specialists. Managers find out where the problem exists & what
the cause might be.

6. 6





























Existing System

In the existing system the transactions are done only manually but in proposed system we
have to computerize all the banking transaction using the software Banking system.
Disadvantages of existing system:
 Lack of security of data.
 More man power.
 Time consuming.
 Consumes large volume of pare work.
 Needs manual calculations.
 No direct role for the higher officials.
 Damage of machines due to lack of attention. To avoid all these limitations and
make the working more accurately the system needs to be computerized.

7. 7






























The aim of proposed system is to develop a system of improved
facilities. The proposed system can overcome all the limitations of the existing system. The
system provides proper security and reduces the manual work. 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.
Advantages of Proposed system:
The system is very simple in design and to implement. The system requires very low
system resources and the system will work in almost all configurations. It has got
following features Security of data.
 Ensure data accuracies.
 Proper control of the higher officials.
 Reduce the damages of the machines.
 Minimize manual data entry.
 Minimum time needed for the various processing.
 Greater efficiency
Proposed System

8. 8






























I have designed the given proposed system to automate the process
of day to day activities of Bank like Branch activities, Account, Loans facilities, and
many other facilities to the multiple users etc.
The complete set of rules & procedures related to Bank’s day to day activities and
generating report is called “BANK MANAGEMENT SYSTEM”. My project gives a
brief idea regarding automated Bank activities.
The following steps that give the detailed information of the need of proposed
system are:
Performance: During past several decades, the Bank management system is supposed
to maintain manual handling of all the Bank daily activities. The manual handling of the
record is time consuming and highly prone to error. To improve the performance of the
Bank management system, the computerized Bank management system is to be
undertaken. The computerized Bank project is fully computerized and user friendly even
that any of the Bank A/c holders can see the and their related activities and statements.
Requirement Analysis

9. 9






























The main goal of the system is to automate the process carried out in the bank with
improved performance an realize the vision of paperless banking.
Some of the goals of the system are listed below:
 Manage large number of customer details with ease
 Mange all details of the student who are registered with bank and send
appropriate details about latest policy of the bank to each of its customer
 Create customer account and maintain its data efficiently and effectively
 View all the details of the customer
 Create a statistical report to facilitate the finance department work
 Activities like updating, modification, deletion of records should be easier
Scope of the System

10. 10





–––

























 The technical issue usually raised during the feasibility stage of the
investigation includes the following:
 Does the necessary technology exist to do what is suggested?
 Do the proposed equipments have the technical capacity to hold the data required
to use the new system?
 Will The proposed system provide adequate response to inquiries, regardless of
the number or location of users?
 Can the system be upgraded if developed?
 Are there technical guarantees of accuracy, reliability, ease of access and Data
security?


Technical Feasibility

Feasibility Study

Preliminary investigation examines project feasibility, the likelihood
the system will be useful to the organization. The main objective of the feasibility study
is to test the Technical, Operational and Economical feasibility for adding new modules
and debugging old running systems. All systems are feasible if they are given unlimited
resources and infinite time. There are aspects in the feasibility study portion of the
preliminary investigation:

I. Technical Feasibility
II. Operation Feasibility
III. Economical Feasibility

11. 11









A system can be developed technically and that will be used if installed must
still be a good investment for the organization. In the economical feasibility, the
development cost in creating the system is evaluated against the ultimate benefit derived
from the new systems. Financial benefits must equal or exceed the costs. The system is
economically feasible. It does not require any additional hardware or software.

Economical Feasibility

Proposed projects are beneficial only if they can be turned out into
information systems, which will meet the organization’s operations.
requirements. Operational feasibility aspects of the project are to be.
taken as an important part of the project implementation.
Some of the important issues raised are to test the operational feasibility of a project
includes the following: -
 Is there sufficient support for the management from the users?
 Will the system be used and work properly if it is being developed and
implemented?
 Will there be any resistance from the user that will undermine the possible
application benefits?
 This system is targeted to be in accordance with the above-mentioned issues.
Beforehand, the management issues and user requirements have been taken into
consideration. So, there is no question of resistance from the users that can
undermine the possible application benefits.
 The well-planned design would ensure the optimal utilization of the computer
resources and would help in the improvement of performance status.

Operational Feasibility

12. 12




























System requirements

 Processor: Intel(R) Core i5-8265U CPU @ 1.60GHz 1.80GHz
 Operating system: Windows 10 enterprise
 Installed memory (RAM): 8.00 GB
 Hard disk: 1TB
 Keyboard: 101 keys
 Mouse: Optical mouse
Hardware and Software requirement

13. 13






























ER Diagram
N
1
ACCTS
ACCOUNT
Balance
Type
Acct_no
A_C
Ssn C_name
C_addr Phone
CUSTOMER
M
N
BRANCHES
BANK
Code Name Addr
1 N
BANK_BRANCH
Addr Branch_no
LOANS
LOAN
1
N
Amount
Type
Loan_no
L_C
N
M
1

14. 14






























Level 1 DFD
Level 0 DFD
DFD
login Administrator Customer
Work
Employee
Details
ACCOUNT
Customer
Registration
Service
Payment
BANK

15. 15





























Level 2 DFD
Login table
Staff
Customer
STAFF
distribution
ACCOUNT
details
Customer
detail

D
A
T
A
B
A
S
E
Login
ACCOUNT
Collection
User
Advertisement
ACCOUNT details
Report

16. 16




Bank Table:

Field Type Constrains
Code Int Primary key
name Char(30) Not null
Addr Char(30) Not null


Bank Branch table :
Field Type Constrains
Branch_no Int Primary key
Addr Char (30) Not Null

Account table:
Field Type Constrains
Acct_no int Primary key
Balance Int Not Null
Type Char(30) Not null

Loan table:
Field Type Constrains
Loan_no Int Primary key
Amount Int Not null
Type Char(30) Not null

Customer:
Field Type Constrains
SSN Int Primary key
C_addr Char(30) Not Null
C_name Char(30) Not null
Phone Int Not null




Data Dictionary

17. 17




Login table:


Main menu:

Output Screen

18. 18

Create account:


Credit:

19. 19

Credit card:



Debit:

20. 20


Transaction:



Loan:

21. 21























Conclusions
“Banking System " keeps the day by day tally record as a
complete banking. It can keep the information of Account type, account opening
form, Deposit, Withdrawal, and Searching the transaction, Transaction report,
Individual account opening form, Group Account. The exciting part of this project
is; it displays Transaction reports, Statistical Summary of Account type and Interest
Information.
Bank management system is a virtualization of transactions in
banking system. The banking system are used manual working but when we used
online banking system it is totally virtualization process which avoid manual
process and converts it in automatic process . If user can make a transaction in bank
management system it is available in any were also user can link aadhar with
account, change branch location easily. Bank management system is saving the time
with accuracy than bank manual system.

22. 22
























Future Enhancement
 We can go further for Online Banking.
 We can establish and start various Branches and available help centres for
Account Holder’s Queries.
 We can also deal through internet by creating web pages and a banking
website for internet dealing.
 To attract Account Holder’s we can offer various offers during festivals
months.
 We can also deal in various types of Banking Transactions.
 To have more and more customer satisfaction we will emphasize more and
more on our dealings.
 More branches of the bank, maybe it will be international, that means more
ATM machines outside.
 Customer issues development based on their needs, so the help desk will be
aware of their needs and easy to use.
 Developing a mobile App for banking system that help users to do the
obtained his operations without go to the bank only he need to sign in using
his A/C NO. And password and then use your own PIN. Finally the system
will update automatically.

23. 23




Bibliography
WEB REFERENCES

1. www.google.com
2. www.youtube.com
3. www.Slideshare.com (Reference)