Bank Loan Management System

Mitesh PatelProject4free.blogspot.com

Company Overview• Name Of Company:-State Bank Of India• Type of Company :- Inter National• Other Detail :-

Branches:- 16,000 over in India• Other Information:-

• Type :- Public(BSE :500112,LSE:SBID)• Founded :- 1 July 1955• Headquarters:- Mumbai,Maharastra,India• Product:-Investment Banking, Consumer and Commercial Banking, Retail and Private

Banking, Assets Management and Pensions…etc

• Revenue :- $28.212 billion(2010)• Profit :- $ 2.4732 billion(2010)• Total Assets :- $323.04 billion(2010)• Total Equity :- $18.519 Billion(2010)

Company Profile• Logo:-

• Slogan:-With You – All the Way

Department/Overview Of Company• Cashier:- Accept the cash form customer and make payment

of withdrawal• Clearance:-Check the detail of payment and data entry in

passbook.

Organization Chart

Front endFront end

Microsoft .net (pronounced “.net “) is a software Microsoft .net (pronounced “.net “) is a software components that run on the windows operating components that run on the windows operating system.system..net provides tools and libraries that enable .net provides tools and libraries that enable developers to create windows software much developers to create windows software much faster and easier.faster and easier.. Net benefit end –user by providing application . Net benefit end –user by providing application of higher capability, quality and security.of higher capability, quality and security.The . Net framework must be installed on a The . Net framework must be installed on a user’s PC to run . Net application.user’s PC to run . Net application.

BackBack andand( SQL server )( SQL server )

• SQL means structured query language SQL means structured query language • SQL is a universal language for manipulating SQL is a universal language for manipulating

table.table.• Almost every DBMS support SQL Almost every DBMS support SQL • SQL consist of a small number of key-words SQL consist of a small number of key-words

and is optimized for selecting , inserting , and is optimized for selecting , inserting , updating and deleting data. updating and deleting data.

Need of projectNeed of project

• We want to make this system computerize so that we need this project.• We are also put that facility, by this user can

search and ask query so we can give them answer.

• The existing system is totally manual.The existing system is totally manual.• It is time consuming.It is time consuming.• It requires lot of stationary to store data & that also It requires lot of stationary to store data & that also

required lot of space & cares to keep it.required lot of space & cares to keep it.• Chances of errors are quite more.Chances of errors are quite more.• Chance of loss of record or being destroyed & there Chance of loss of record or being destroyed & there

retrieval of data is also slow.retrieval of data is also slow.• No backup facilities are there.No backup facilities are there.• Generating the invoice storing the data also is a tedious Generating the invoice storing the data also is a tedious

job.job.• Referring to each transaction & its effect to decisions Referring to each transaction & its effect to decisions

accordingly will consume lot of time.accordingly will consume lot of time.• Security of data is low as the same transaction is to be Security of data is low as the same transaction is to be

moved on paper to various persons & this may cause data moved on paper to various persons & this may cause data integrity.integrity.

Existing system AdvantagesExisting system Advantages

• We can give constraint.We can give constraint.• Any person can use this system.Any person can use this system.• Easy package of database.Easy package of database.• It reduce the cost of software & hardware It reduce the cost of software & hardware

purchasing.purchasing.• Minimum chance of data lost Minimum chance of data lost • There is no requirement of highly educated There is no requirement of highly educated

personspersons

Existing system (Disadvantages)Existing system (Disadvantages)

Time consuming lots.Time consuming lots.

Data mining are not accurate compare with Data mining are not accurate compare with SQL server .SQL server .

It is not efficient & Flexible.It is not efficient & Flexible.

Multiple reports can’t get.Multiple reports can’t get.

Proposed system & ObjectivesProposed system & Objectives

DefinitionDefinition Loan Management System for BankLoan Management System for Bank

ObjectiveObjective:-:- Customer Satisfaction:Customer Satisfaction: