Banking Management System Project documentation

Banking Management System Project documentation

1. BANK MANAGEMENT SYSTEM

DELIVERABLE # 02 : Full Documentation













STUDENT NAME: CHAUDHRY SAJID (GROUP LEADER)
STUDENT NAME: MOHSIN RIAZ
STUDENT NAME: EBAD UR RAHMAN
STUDENT NAME: AFFAN SHAHZAD
PROJECT SUPERVISOR: MR. AHMAD ASLAM
SUBMISSION DATE: 8
TH
March , 2018

2. TABLE OF CONTENTS

ACKNOWLEDGEMENT …………………………… ………………………………… 3
DECLARATION……………………………………………………………………… .. 4
PROJECT IN BRIEF…………………………………………………………………... . 5
ABSTRACT………………………………………………………………………… ….. 6
INTRODUCTION…………………………………………………………………………………………………… …. 7-11
PRODUCT MANAGEMENT SYSTEM………………………………………………..12 -14
REQUIREMENTS........................................................................................................... 15-18
DESIGN & ARCHITECTURE......................................................................18-22
LINE GRAPH……………………………………………………………………………23
IMPLEMENTATION..................................................................................23-37
ADDITIONAL FEATURES……………………………………………………………..38 -40
MAIN CODE…………………………………………………………………………….. 40-50
USER GUIDE…………………………………………………………………………… .50
CONCLUSION………………………………………………………………………… …51

3. DEDICATION
We dedicate our project to the love of our parents, who always prayed for our success in
every walk of life, the love of our teacher, who guides us with an honorable touch.
The love of our friends, who helped us in every difficulty we faced and encouraged us in
difficult times.
“Keep your dreams alive. Understand to achieve anything requires faith and believe in
yourself, vision, hardworking, determination and dedication. Remember all things are
possible for those who believe.”

ACKNOWLEDGMENT
In the partial fulfillment for the degree in Computer Science of University Of Central
Punjab, Rawalpindi Which is a record of their own work, carried out by them under my
guidance and supervision for the academic session 2017-2019.
Prof. Mr . Ahmad Aslam
Head of Department
Department Of Computer Science.
U.C.P, Rawalpindi.
Though perseverance and enthusiasm combined with effort in the right direction can bring
forth the thing called success. But the realization of the harsh reality that the path towards
success is full of my riads, temptatious, impediments and pitfalls often proves to be
disheartening in such situation, it is the able guidance of knowledgeable person that steers
one through difficulties and help him achieve success.
I am highly obliged to express our deep sense of gratitude and grateful thanks to my
erudite guide Prof. Ahmad Aslam for her valuable guidance and support which led to the
successful and timely completion of my seminar report.
I am secondly very thankful to our H .O. D, Dept. of Computer Science for his
valuable suggestions & guidance.
Last but not the least, I deeply appreciate the cheerful encouragement of all staff
members of my department and my friends.

Thanks.

MR. CHAUDHRY SAJID
MR. MOHSIN RIAZ
MR. Affan Shahzad
MR. EBAD UR RAHMAN

4. DECLARATION
We hereby declare that this project, neither whole nor as a part has been copied out from any
source. It is further declared that we have developed this project and accompanied report
entirely on the basis of our personal efforts.
If any part of this project is proved to be copied out from any source or found to be
reproduction of some other. We will stand by the consequences.
No Portion of the work presented has been submitted of any application for any other degree
or qualification of this or any other university or institute of learning.
MR. CHAUDHRY SAJID
MR. MOHSIN RIAZ
MR. Affan Shahzad
MR. EBAD UR RAHMAN

PROJECT IN BRIEF

Project Title: Bank Management System

Organization: University Of Central Punjab

Undertaken By: Chaudhry Sajid
Ebad Ur Rahman
Mohsin Riaz
Affan Shahzad
Supervised by: Mr. Ahmad Aslam

Date Started: 29
th
Febraury, 2019

Date Completed: 3
rd
March, 2019

Technology Used: Oracle Database 13G

Operating System: Windows 10

System Used: HP Core i7, 700 GB HDD, 7 GB RAM

5. ABSTRACT
The adoption of Electronic Banking by commercial enterprises has been inexistence since the
mid 90s, much greater in number due to lower operating costs associated with it. Electronic
banking has initially been in the form of automatic teller machines and telephone
transactions.

More recently, it has been transfer made by the Internet, a new delivery channel for
banking services that benefits both customers and banks. Internet banking system services
can include: Open an account, Balance enquiry, Request for Cheque book, Beneficiary
payments (EFT),Viewing monthly. Furthermore, customer’s application for electronic
banking facilities is expanding as the cost savings on
transactions over the Internet are
significant.

INTRODUCTION
SQL is a standard computer language for accessing and manipulating databases.
 SQL stands for Structured Query Language.
 SQL allows you to access a database.
 SQL is an ANSI standard computer language.
 SQL can execute queries against a database.
 SQL can retrieve data from a database.
 SQL can insert new records in a database.
 SQL can delete records from a database.
 SQL can update records in a database.
 SQL is easy to learn.
 SQL is an ANSI (American National Standards Institute) standard computer language for
accessing and manipulating database systems. SQL statements are used to retrieve and
update data in a database. SQL works with database programs like MS Access, DB2,
Informix, MS SQL Server, Oracle, Sybase, etc.


 Unfortunately, there are many different versions of the SQL language, but to be in
compliance with the ANSI standard; they must support the same major keywords in a
similar manner (such as SELECT, UPDATE, DELETE, INSERT, WHERE, and others).

6.  SQL Database Tables: -
A database most often contains one or more tables. Each table is identified by a name (e.g.
"Customers" or "Orders"). Tables contain records (rows) with data.
Below is an example of a table called "Persons": -
Last Name First Name Address City
Hansen Ola Timoteivn 10 Sandnes
Svendson Tove Borgvn 23 Sandnes
Pettersen Kari Storgt 20 Stavanger

 The table above contains three records (one for each person) and four columns (Last
Name, First Name, Address, and City).

 SQL Queries: -
With SQL, we can query a database and have a result set returned.
 A query like this: -
SELECT Last Name FROM Persons
 Gives a result set like this: -
Last Name
Hansen
Svendson
Petersen
SQL Data Manipulation Language (DML)

7.  SQL (Structured Query Language) is syntax for executing queries. But the SQL language
also includes syntax to update, insert, and delete records.
 These query and update commands together form the Data Manipulation Language
(DML) part of SQL: -
 SELECT - extracts data from a database table
 UPDATE - updates data in a database table
 DELETE - deletes data from a database table
 INSERT INTO - inserts new data into a database table

SQL Data Definition Language (DDL)
 The Data Definition Language (DDL) part of SQL permits database tables to be created
or deleted. We can also define indexes (keys), specify links between tables, and impose
constraints between database tables.

 The most important DDL statements in SQL are: -
 CREATE TABLE - creates a new database table
 ALTER TABLE - alters (changes) a database table
 DROP TABLE - deletes a database table
 CREATE INDEX - creates an index (search key)
 DROP INDEX - deletes an index MS SQL SERVER 2000

8. PRODUCT MANAGEMENT SYSTEM


View Of Project

 The main aim of this project is it gives information about the functioning of databases
in banking system.
 All the functionalities of banking systems are credited in this project.

General Information
Usually all persons want money for personal and commercial purposes. Banks are the oldest
lending institutions in Pakistan scenario. They are providing all facilities to all citizens for
their own purposes by their terms. To survive in this modern market every bank implements
so many new innovative ideas, strategies, and advanced technologies. For that they give each
and every minute detail about their institution and projects to public.
They are providing ample facilities to satisfy their customers i.e. net banking, mobile
banking, door to door facility, instant facility, investment facility, demat facility, credit card
facility, loans and advances, account facility etc. And such banks get success to create their
own image in public and corporate world. These banks always accepts innovative notions in
Pakistan banking scenario like credit cards, ATM machines, risk management etc. So, as a
student business economics i take keen interest in Pakistan economy and for that banks are
the main source of development.
So this must be the first choice for me to select this topic. At this stage every person
must know about new innovation, technology of procedure new schemes and new ventures.
Because of the following reasons, i prefer this project work to get the knowledge of the
banking system.


 Banking is an essential industry.

 It is where we often wind up when we are seeking a problem in financial crisis and
money related query.


 Banking is one of the most regulated businesses in the world.

 Banks remain important source for career opportunities for people.


 It is vital system for developing economy for the nation.

 Banks can play a dynamic role in delivery and purchase of consumer durables.

9. Problem in Current System:

The Bank Management System is an application for maintaining a person’s account in a
bank. The system provides the access to the costumer to create an account, deposit/withdraw
the cash from his account, also to convert currency. The following documentation provides
the specification of the system.

We are mainly concerned with developing a banking system where a Customer can
submit his/her deposit amount to bank if he/she has an account or can create a new account in
this bank. Customer can also view the status and change currency of his/her bank account,
can view account balance. One can easily maintain the above things if he/she has an account
by login through his unique account number.

Proposed System:
The application will be extremely beneficial for the Customers intending to use and operate
their bank account and will get various benefits in the field of management of accounts on a
clean and user-friendly platform.

“Bank Account System”, is a simple application, which is especially generated and
designed for the bank in order to enter the applicant information about his or her bank
account and can perform other function like currency change. It is user name and ID
protected as well.

Following are the major objectives behind the new proposed system:

 It creates a user friendly environment, where a normal user can access through all the
benefits of the system.
 It provides security from unauthorized access, only admin or authorized users are
access granted to the system.
 It increases efficiency and saves the time.
 No any danger and obstacles from external entities.
 Easy access of saved data inside the system.
 Complex Banking operations and Transaction operations are efficiently handled by
the application
 It has ease of use along with complete reference
 It is highly secured and less time consuming; hence time wastage can be avoided
 Up to date records of the customers are maintained by the authority.

Benefits of Proposed System:
The aim of Bank Manager System (BMS) is to automate all the activities of the Bank
Transaction to increase the performance. This will be the desktop application that will be
used to maintain the following:

• User friendly GUI.
• Fully Efficient
• Easy to handle customer account
• Improved services
• Provides better account management facilities
•

10. MODULES & SUB-MODULES DESCRIPTION

Modules Description
Module Description Create File Selecting This Create A New File For The
User By Accepting Input Such As Account Number, Name And Amount
Open Account Opens The New
Account For The User By
Accepting Input Such As Account
Number, Name And Minimum
Balance
Search Enables To Search For The Details Of The
Given Account Number Deposit Provides Option To Deposit Amount
From The Given Account Number Withdraw Provides Option To Withdraw Amount
From The Given Account Number View Account Displays Only One Account Detail At A
Time Currency Exchange Provides Option To Exchange Currency


Bank Management
 Dealing In Money
Bank is a financial institution which deals with other people's money i.e. money given
by depositors.
 Individual / Film / Company
A bank may be a person, firm or a company. A banking company means a company
which is in the business of banking.
 Acceptance Of Deposit
A bank accepts money from the people in the form of deposits which are usually
repayable on demand or after the expiry of a fixed period. It gives safety to the
deposits of its customers. It also acts as a custodian of funds of its customers.
 Giving Advances
A bank provides various banking facilities to its customers. They include general
utility services and agency services.
 Payment & With Withdrawal
A bank provides easy payment and withdrawal facility to its customers in the form of
cheques and drafts, It also brings bank money in circulation. This money is in the
form of cheques, drafts, etc.
 Agency & Utility Services
A bank provides various banking facilities to its customers. They include general
utility services and agency services.
 Profit & Services Orientation
A bank is a profit seeking institution having service oriented approach.
 Ever Increasing Function
Banking is an evolutionary concept. There is continuous expansion and diversification
as regards the functions, services and activities of a bank.

11.  Connecting A link
A bank acts as a connecting link between borrowers and lenders of money. Banks
collect money from those who have surplus money and give the same to those who
are in need of money.
 Banking Business
A bank's main activity should be to do business of banking which should not be
subsidiary to any other business.


Report
 Clint Report
We can show all the saved data regarding account management within the database.

 Account Report
We can show the money transaction by client, time, date, and the total amount of
account.

 Final Report
At last the final reports, which will show every record regarding client, total amount
and withdraw by client.

Tool & Technology Used

 Language: SQL Database
 Software: Oracle Database 13G
 OS:Window 10

Limitation
 Stand Alone
 Not Supported Web Base

12. REQUIREMENTS
As “National Bank Limited” doesn’t have such software which can be used to manage
clients money and other accountabilities. So, we decided to develop a “Bank Manager” that
will contain all those features fulfilling the client basic need by having a professional yet
welcoming Interface. “Bank Manager” is providing solution to that problem.
Our system is user specific and is for all types of users. Our system operates on
window’s operating system. Easily accessible to all type of users.
ADMINISTRATIVE REQUIREMENT
Functional Requirement
Functional requirements in our system are as follows:
 Purpose
To register a new customer.
 Inputs
The required data for registration of a new customer in the bank (Like Name,
Address, Designation etc).

 Outputs
A Success Message be displayed on successful registration or else an error
message will be displayed.

Non Functional Requirement

Non-functional requirements are requirements that are not directly concerned with the
specific functions delivered by the system. They may relate to emergent system properties
such as reliability, response time and store occupancy. They may specify system
performance, security, availability, and other emergent properties.

Safety Requirement

 Backup, recovery & business continuity Banks should ensure adequate back up of
data as may be required by their operations. Banks should also have, well documented
and tested business continuity plans that address all aspects of the bank’s business.

 Both data and software should be backed up periodically.

 An off-site back up is necessary for recovery from major failures / disasters to ensure
business continuity.

13. Security Requirement

 Account ID and Password (PIN) Protection
 Auto Timeout Screen Blanking
 Sign-off Button
 Failed Log-on Attempts
 Encryption
DESIGN CONSTRAINTS
To use this system, only admin has rights to change or modify the information.
SOFTWARE REQUIREMENTS
For developing the application, the following are the software requirements:
Operating System: Windows 7/8/10
Language: SQL Database
Software: Oracle Database
Technologies Used: Oracle Database
For running application following are the software requirements:
Operating System: Windows 7/8/10
HARDWARE REQUIREMENTS
For developing application following are the hardware requirements:
Processor: Intel Core 2duo, i3, i5, i7
For running application following are hardware requirements:
Device: Windows 7/8/10

DESIGN & ARCHITECTURE
SYSTEM DESIGN
Once the features implemented and architecture drafted, system design is also needed to
implement the application. The following are the four diagrams that are used to implement
and test the application.

 Case Diagram

 Class Diagram

14.  Entity Relationship Diagram (ERD)

Use Case Diagram
A use case diagram captures the objects and the role or functions they perform in system.
There are two objects in case of our project.
USE CASE DIAGRAM

15. Class Diagram
The class diagram below represents the important classes that are implemented in our
application with their attribute, operations and return types. Class diagram also represents
how each class is associated with other class and each activity, broadcast and service is
represented as a class.

16. E- R Diagram


ESTIMATED RESULTS (LINE GRAPH)

17. IMPLEMENTATION
Bank Management System of “National Bank Limited” is a desktop based application is
designed from owner point of view and user friendly design of our application helps the
owner of the bank and faculty in accomplishing their task with ease. We have made attempts
to keep design simple and easy to understand.
USER INTERFACE
 The system is user friendly.
 Interface of the system is easily understandable.
 User need not take any additional effort to understand the functionality and navigation
in our application.
 The colors are chosen in such a way that user can easily understand where the input
has to be given.

18. Welcome Screen

19. Creating Account

20. Logging in as existing customer

21. Depositing Amount

Withdrawing Amount

22. Viewing Details

Converting Currency

23. PROCESS & VALIDATION
Main menu:
There are number of options regarding users to creating a new account or logging in as
existing customer to access the facilities system providing or exit the system after accessing
the user requirements.

Creating new account:
All the requirements should be filled with proper with correct
identification such as account number, name and initial deposit.


Logging in as existing customer:
Correct account number should be required to access through existing customer otherwise
this facility is not executable. There are also number of options regarding users to avail the
facilities system is giving to the user.

Depositing and Withdrawing account:
This required a amount customer want to deposit or withdraw and show the current balance
after executing customer’s requirement.

Viewing details:
Correct account number should be required in order to view details of customer’s account .If
not entered correct account number, then it can’t be accessed.

Converting currency:
This required a number of money user want to convert and also
required the name of currency user wish to convert in.

Uniqueness:
Each account number should be unique throughout all the existing records. Name should be
of character type and account number should be of digit. Character and digits are not allowed.

Checking of size:
Account number cannot be greater than 2 of size.
Name can’t be greater than 20 characters.


ADDITIONAL FEATURES

MAXIMIZE SCREEN
In additional features context, maximize screen is most important as it enlarges the main screen from
its original size which is very small. We enlarged the screen to make its feel and look better & so that
user might find ease at using our software.

24. ALERT TONE
The second important part of the additional features is alert tone which will alert the user when he/she
choose wrong options or when there is an error to notify to the user. So, it holds most important part
to alert the user whenever he/she makes mistakes while using our software.
DATA STRUCTURE & DATA SPECIFI CATION
“ACCOUNT_INFO” Table: -
Field Name Type Constraints
Account_Number Int Reference Customerinfo
Account_Branch Varchar2(15) Not Null
Account_Type Varchar2(15) Not Null
Balance Int Not Null

“CUSTOMER_INFO” Table: -
Field Name Type Constraints
Account_Number Int Primary key
Account_Name Varchar2(10) Not Null
Gender Varchar2(20) Not Null
Age Int Not Null
Address Varchar2(20) Not Null
Branch Varchar2(20) Not Null

“CARD_INFO” Table: -
Field Name Type Constraints
Account_Number Int Reference Customerinfo
Card_Number Int Primary key
Card_Type Varchar2(10) Not Null

“LOAN_INFO” Table: -
Field Name Type Constraints
Account_Numer Int Reference Customerinfo
Loan_Type Varchar2(10) Not Null

25. Loan_Amount Int Not Null
Interest Int Not Null

“EMPLOYEE_INFO” Table: -
Field Name Type Constraints
Emp_Id Int Primary key
Emp_Name Varchar2(15) Not Null
Branch Varchar2(10) Not Null
Salary Int Not Null
Status Varchar2(10) Not Null



MAIN CODE
Now, in the end we will display our main code and concepts we used in our program.
Everything will be described briefly in a systematic concrete form with the code we made.

SELECT * FROM CUSTOMERINFO;
OUTPUT:

26. SELECT * FROM LOANINFO;
OUTPUT:


SELECT * FROM CARDINFO;
OUTPUT:

27. SELECT * FROM EMPINFO;
OUTPUT:


SELECT * FROM BRANCH;
OUTPUT:

28. SELECT * FROM CURRENCIES;
OUTPUT:

SELECT * FROM SERVICES;
OUTPUT:


SELECT * FROM CREDIT;
OUTPUT:

29. SELECT * FROM DEBIT;
OUTPUT:




SELECT * FROM EMPINFO WHERE BRANCH='Islamabad' AND STATUS='Manager';
OUTPUT:


SELECT * FROM EMPINFO WHERE SALARY BETWEEN 20000 AND 35000;
OUTPUT:

30. SELECT * FROM CARDINFO WHERE ACCOUNT_NUMBER BETWEEN '3212' AND
'3215';
OUTPUT:



SELECT * FROM CARDINFO WHERE CARD_TYPE='DEBIT';
OUTPUT:

SELECT * FROM CUSTOMERINFO WHERE GENDER='M' AND BALANCE>7500;
OUTPUT:

SELECT
ACCOUNT_NUMBER,ACC_NAME,GENDER,AGE,BALANCE,BRANCH,ADDRESS

31. ,ROW_NUMBER() OVER(ORDER BY (BALANCE) DESC) AS RANK FROM
CUSTOMERINFO;
OUTPUT:


CONCLUSION AND FUTURE WORK
CONCLUSION
Conclusion
"Bank Management System " keeps the day by day tally record as a complete batting. 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.
Future Work
Our whole documentation shows the work we had done up till now. So, particularly our
program is fully complete and we further want to focus on the future to making it a better and
more efficient product.
In future, we are thinking of adding more specifications and features to make it look
better and easy to use. We are thinking of making a formula that will generate cash flow
statement, daily transactions, owner’s equity; all will be generated after one full year to show
the progress of the business annually. Future plan is still being in our thought and our
concern, we will soon release a version far better than this one and we hope that our work
will be appreciated.