INDEX
SR NO. TITLE SLIDE NO.
10.4 Sequence Diagram 24
10
10.5 Collaboration Diagram 26
11 Data Dictionary
12 Input Design 40
13 Output Design 82
14 Testing 88
I5. Post Implementation Review 91
16 Future Enhancement 92
17. Bibliography 93
ABSTRACT (PROJECT PROFILE)
Project Title: Loan Management System
Objective: Main objective is to provide good interaction & communication facilities
between customers & Administrator. Loan management system has been
designed to online the back office activities of bank and finance company
which offers any type of loan., Administrator manage customer information
database more efficiently. Loan details , maintain loan type and interest rate
information. Admin can use calculator to give exact payable loan amount for
the customer & generate all these work info as a report of each customers.
Platform : Web-Base
Front End : Java
Back End : MYSQL 5.1
Project Duration : 90 Days
Internal Guide: RUCHIRAI
External Guide : RUCHI RAI
Submitted To : Department Of Computer Science .Ganpat Vidyanagar, Kherva
4
EXISTING SYSTEM
>Here the existing system is a manual that doesn't maintain details with proper security and can't
track details casily.
>It doesn't allow the customer to check their profile in proper way which leads customer dis
satisfaction.
>Does not provide option to download loan form
>Existing system docsn't contains functionalities of fast retrieval infomation such as customer
details and maintenance of all the loan details so it involves lots of paperwork.
>Doesn't user-friendly interface.
>Lots of time is required to manage customer info & details so it feels that existing system not
accurate and therefore maintenance becomes very complicate.
> It used to take more time to find customers because there are required extra manual effort such
as to hire candidate.
>Difficulty in generating different reports as per the business requirement
NEED FOR NEW SYSTEM
>Interest rates and the loan details are also available at the click of a mouse.
>Customer cun apply for a loan and after approved it they can track their details from online.
>This system provides detail about the customers, their loan details,EMI details and its rate details.
>System provides download option to download different type of loan form in MS word
document.
>Using with this system admin can find customer casily and it's a paperless system so workloud is
reduced.
> The decision process becomes faster and more consistent
>After registration and login customer can use the system casily and also customer can view any
query about loan details as well as EMI details in their profile. So this system saves timne.
>Provides good communication for the customer
>In this system there are used EMI(Equated Monthly Installment) caleulators.
>Provides a facility to generate the reports very casily.
MAIN MODULES HE SYSTEM WITH FUNCTONALITY
" There are Following Modules of this System:
o User management:
> Registration:
Customer, User can registration with basic information like User name. Mobile no, email id etc.
> Login:
Admin,Users can login with username and password.
> Manage Profile:
Admin,User can manage profile and update information.
o Loan Application:
> Admin manage loan application which is sent by customer using the system.
o Download Loan Form:
> Once loan is approved customer can download loan form in MS word document to sign of
them und their guarantor.
oCustomer Information Module:
> It shows all an information & details of the customer database which includes all the details like
customer name, address, contact no, bank account no, PAN no, email id. etc. Only Admin can
manage customer record.
o Loan transaction module:
> Loan transaction module includes Loan Type. Customer, Issuing Loan. EMI
Caleulation.
Home Loan, Kece Loan,
e payments. The System Administrator can able to add, modify loan type like
Personal Ioaneof customer and can modify the interest rate.
> One customer can have more than one loan, System generate unique loan no, Admin can add,
modify loan details like loan type, loan amount, tenure, mortgage details, guarantor details.
> EMI Calculation - System have EMI calculator which can provides details of
particular loans, System take input from user like Loan Amount, Interest Rate, Tenure, Issue Date and
give details output like monthly EMI, total interest, total cost.
>Receive payment - using with this System admin can enter payment information for particular emi,
in this system late fine charges can mention if receipt date is greater than the enmi dale.
System user can find customer by their name to get customer
oA Query Module:
> It shows EMI Payment details
>A query module give information for particular customer, Customer user can search information by
entering customer ID.
>It displays details like No of payment, EMI amount, EMI date, Receipt date ,Late fine charge if any
ete,
User
There are main two users:
1.Admin
2.Customer
USERS OF STEM WITH SPECIFIC ROLE
Admin
" Admin can login the system with his user name and password.
" Admin can change paSsword.
" He can manage loan type and interest rate in the system.
" Admin can manage loan application sent by customer using the system to decide to give loan and for that
customer will be contacted by company's agent to get document of loan
" He can maintain information & details to the customer such as customer name, address, contact no, bank
account no, pan n0, email id, elc. Only Admin can manage customer record.
" He can manage loan details such as Loan no, loan type, Loan Amount, loan tenure, interest rate, Issue date etc.
for the customer.
He can calculate und manage EMI details .
" He can mange at the time of receiving EMI which contains details of given an EMI and the EMI hat are
remain in future to get next time of customer.
" Report generation module provides user to take print out.
HARDWARE & SOFTWARE REQUIREMENT
The minimum requirements of hardware & software for unning the web application is as follow.
O MINIMUM HARDWARE REQUIREMENT:
Server Slde
Processor 2.4GHz
Hard Disk 40 GB Fee Space
RAM 2 GB
Client Slde
Processor 1.9GHz
Hard Disk 20 GB Free Space
RAM GE
11
O MINMUM SOFTWARE REQUIREMENT:
Server Side
Operating System windows server 2003
Web Server Apache Tomcat ver. 7.0
Front-End Tools Java/jdk I.6.0 (JSP/Servlet)
Back-End Tools MYSQL Server 5.1
Cllent Side
Operating System Windows XPor Any compatible OS
Web Browser
Internet Explorer 5.0 or Any
compatible Browser
12
pply nline l
Download Loan Fom
17
Vie
Vicw
Recei
No pt ID
EMI ApplicationlD
LAppication
PaymentDetails EMI Details EMI
Dale Receipt Amount EMI
type Loan
Manage Manage
Manage
Apply
View CustomerlD
Manage Admin Customer
Detuils Customer
Name Manage Vew
ID
Loan Custonier Manage
type Loan
Details Loan
Rate Loan
type Loan
NoRate
DIAGRAMI E-R
000000
Admin Side :
00002600
Customer
19
Customer Side:
Start
Visit site
No Yes
Registration Login
Register user or not
No
Is Valid
Loan Details Loan EMI Detail Loan EMI
Payment Detal
Pald EMI Detail ChangeDasswword
Logout
21
Customer Side :
11kequest for Registration
2:1:Request for Login
3Request EMI Detail
4.1Request Paid est Rate /EMI Detail
System Database
111Response for Registration
EResponse for Login
1:1:1:1:Registration Successfully 4:1:1:get Detail
1:Registration
21Login
2:1:1:1:login Successully
3:1:1:1:Response Profile
nEMI Detail
4:Paid EMI Detail 4:1:1:1:Successully get Detail
5:Logout
5:1: Logout Successfully
Customer
22
