Online loan application and verification 2016
Chapter 1
Introduction & objectives of project
1.1 Introduction
1.2Scope
1.3Objective
1.4Project overview
1
Online loan application and verification 2016
1.1 Introduction:-
For implementing this system is designed to automate the loan process from both,
bankers as well as customer’s side.
In this system customer get information about various loans provided along with rate of
interest and required documents. The loan is based on the different profiles. There are
different types of loans for ex (personal loan, business loan, house loan, car loan, education
loan etc.)
The main aim of the project is to help people & allocate loan to the peoples who send the
loan request application.
Our program wants the user’s current situation that why he needs money for further
process. Furthermore, this program stores CNIC & bank account no of the user for securing
the transaction.
Our user has to provide some guarantee on behave of which we can pay loan to them. As
per policy of our system or program attach 7% interest on whatever the credit wants.
1.2Scope:-
The main aim of the project is to help people & allocate loan to the peoples who send
the loan request application.
Our program wants the user’s current situation that why he needs money for further
process. Furthermore, this program stores CNIC & bank account no of the user for securing
the transaction.
Our user has to provide some guarantee on behave of which we can pay loan to them. As
per policy of our system or program attach 7% interest on whatever the credit wants.
This system will provide lower rates and Saves the people’s time.
2
Online loan application and verification 2016
1.3 Objective:-
Main objective is to provide good interaction & communication facilities between
customer and verifier. Loan management system has been designed to online the back
office activities of bank which offers any type of loan. Verifier manage customer
information database more efficiently, Loan details, and maintain loan type and interest rate
information. Verifier can use calculator to give exact payable loan amount for the customer
& generate all these work info as a report of each customer.
1.4 Project overview:-
Secure registration of all users including a personal profile.
Customer can 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 and its rate details.
Using with this system admin can find customer easily and it’s a paperless system so
workload is reduced.
After registration and login customer can use the system easily and also customer can
view any query about loan details as well as their profile. So this system saves time.
3
Online loan application and verification 2016
Chapter 2
Tools/platform/languages
2.1Hardware requirements
2.2Software requirements
2.3Brief description of technology
4
Online loan application and verification 2016
2.1 Hardware requirements:
RAM: 1 GB and above
Processor: Intel dual core and above
Hard disk: 180GB
2.2 Software requirements:
1) Operating system:-
Windows XP and above
2) Platforms:-
Front End:-PHP
Back End:-MYSQL Database server
Wamp server (local server testing)
Dreamweaver (user interface development-HTML, CSS)
2.3 Brief description of technology:-
5
Online loan application and verification 2016
PHP:-
PHP was created by Ramus Lerdrof in 1994. He released PHP to public in 1995 and
called it PHP version 2.
In 1997, Ramus rewrites the PHP and called it PHP 3.0.
PHP 4.0 was launched in 2000.
PHP 5.0 was released in 2004 with (OOP)Object Oriented Programming concept.
PHP scripts run on web server.
PHP is a server-side scripting language designed for web development but also used
as a general-purpose programming language.
PHP stands Hypertext Preprocessor.
PHP code may be embedded into HTML code, or it can be used in combination with
various web template systems, web content management systems and web
frameworks.
PHP scripting is Simple and easy to learn because it’s clean and easy to understand.
MySQL Server:-
MySQL is relational Database Management System based on SQL (Structured Query
Language).
In Relation Database Management System every database consists of one or more
table inside it.
Thus, database is a collection of one or more tables which are related to each other.
MySQL runs on virtually all platforms including Linux, UNIX and Windows.
MySQL used in a wide range of application, including data warehousing, e-
commerce, web database, logging application and distributed application.
What can MySQL do?
MySQL can execute Queries against a database
MySQL can retrieve data from a database
MySQL can insert records in a database
MySQL can update records in a database
MySQL can delete records from a database
MySQL can create new databases
MySQL can create new tables in a database
MySQL can create views in a database
6
Online loan application and verification 2016
Chapter 3
Complete Structure of Project
3.1 E-R Diagram
3.2 DFD Diagram
3.3 Use Case Diagram
3.4 Process Flow Diagram
3.5 Sequence Diagram
3.6 Data Dictionary
3.1 E-R Diagram:-
7
Online loan application and verification 2016
E-R Diagrams can express the overall logical structure of a database graphically. E-R
Diagram are simple and clear qualities that may account that may account in large part for
the widespread use of the e-e model…
Symbols are used in this diagram:-
Entity Sets
Attribute
Relationship Set
Line
8
Online loan application and verification 2016
Application Customer
ID Name
Interest Rate Rate No
Loan Type Cus_id
Loan Type
Loan Application
Loan id Loan Details * *
Manage *
*
1 id
Verifier
1 Password
View 1 1
Verify
Manage
Manage EMI EMI
Date amount
EMI ID
EMI Payment
1 Details
Cus_id * 1 *
Customer
View
*
Address
1
Apply
Contact No Customer
Name
3.2 DFD Diagram:-
9
Online loan application and verification 2016
In the DFD, there are four symbols
1. A square define a source (originator) or destination of system data
2. An arrow identifies data flow; it is pipeline through which the information flows. Data
move in a specific direction from an origin to a destination.
3. A circle or a bubble represents a process that transforms incoming data flow into
outgoing data flows.
4. An open rectangle is a data store, data at rest or a temporary repository of data.
Symbols Elementary reference
Process that transforms data flow
Data flow
Source or destination of data
Data Store
10
Online loan application and verification 2016
Customer
Customer details
Request for
Acknowledgment data
Online loan
application &
Verifier verification Database
details system
Response
Verifier
Acknowledgment
0 level Diagram
11
Online loan application and verification 2016
View loan type
list Request info
Loan Loan Type
Customer Type List
List
Acknowledgment Get info
View
Interest Customer
Rate Details
1.1
View loan
application list 12
Online loan application and verification 2016
Loan Get info Loan
Verifier Application Application
list list
Acknowledgment
Select Loan
Application
Verify
Send
alert
1.2
13
Online loan application and verification 2016
Apply for Loan
Get info
Apply
Loan Loan application
Customer List
Application
Acknowledgment
Provide
Document
Receive
alert
2.1
14
Online loan application and verification 2016
Insert, update,
delete
Customer info
Online Loan
Verifier application
&Verification
System
Loan
Insert, Update, application list
Delete
2.2
3.3 Use case diagram:-
15
Online loan application and verification 2016
Login
View interest rate &
loan type
Add Customer details
Manage loan type &
interest rate
Registration & Apply
loan application form
Verifier Customer
Paid EMI
Send email
Generate report
3.4 process flow diagram:
16
Online loan application and verification 2016
Start
Customer Verifier
Yes
If
Login
register?
Home Page
No
View loan type
View loan
& interest rate
application list
Registration &
Apply online Verify document
loan application
Provide document No
If
qualified?
Login
Yes
View update details Approved loan
Paid EMI
Send email
details
Generate Report
Show Report
Log out
Stop
3.5 sequence diagram:-
17
Online loan application and verification 2016
Customer Server Database
Login Request for Login
Login Successfully Response
Apply loan application Manage loan application
Apply Successfully Response
Provide document Manage document
Response Return Document
Paid EMI Detail Detail
Response Update Detail
Logout
Logout successfully
18
Online loan application and verification 2016
Verifier Server Database
Login Request for Login
Login Successfully Response
Verified document Verify
Verify Successfully Response
Manage Customer Details Manage Customer Details
Successfully Update Customer Details
Logout
Logout successfully
3.6 Data Dictionary:
19
Online loan application and verification 2016
1) Verifier:-
Name Data Type Constraint
Username Varchar(50) Primary key
Password Varchar(50) Not null
2) Loan Application:-
Name Data Type Constraint
Application id Int(50) Primary key
Loan type Varchar(50) Not null
Loan amount Int(50) Not null
Monthly_income Int(100) Not null
Cus_id Int(10) Foreign key
Cust_name Varhar(50) Not null
3) Customer details:-
Name Data Type Constraint
Cus_id Int(10) Primary key
Customer Name Varchar(50) Not null
Contact no Varchar(50) Not null
Address Varchar(200) Not null
Email id Varchar(50) Not null
PAN No Int (50) Not null
4) Loan Details:-
20
Online loan application and verification 2016
Name Data Type Constraint
Loan id Int(10) Primary key
Loan type Varchar(50) Not null
Loan months Varchar(50) Not null
Loan amount Int (100) Not null
Interest rate Varchar(50) Not null
Rate no Int(10) Not null
5) EMI Payment Details:-
Name Data Type Constraint
EMI Id Int(10) Primary key
EMI Date Date time Not null
EMI Amount Int (100) Not null
21
Online loan application and verification 2016
Chapter 4
Snapshots
22
Online loan application and verification 2016
1) Bank Details:-
23
Online loan application and verification 2016
2) Loan Rate Details:-
3) Loan Application :-
24
Online loan application and verification 2016
4) Login:-
25
Online loan application and verification 2016
5) About Us:-
26
Online loan application and verification 2016
27
Online loan application and verification 2016
Chapter 5
Future Enhancement
5 Future Enhancement
it is not possible to develop a system that makes all the requirement of the user.
User requirements keep changing as the system is being used. Some of the future
enhancements that can be done to this system are:
28
Online loan application and verification 2016
Add online transaction.
Add email facility.
Add SMS facility.
29
Online loan application and verification 2016
Chapter 6
Conclusion
6 Conclusion:-
So at last we conclude that this website will be useful to that verifier and customer.
30
Online loan application and verification 2016
Doesn’t contains functionalities of fast retrieval information such as customer details
and maintenance of all the loan details so it involves lots of paperwork and lots of
time is required to manage customer info & details so this website very useful them…
31
Online loan application and verification 2016
Chapter 6
Bibliography
BIBLOGRAPHY:-
Web Sites:-
32
Online loan application and verification 2016
[Link]
[Link]
[Link]
Books:-
1. PHP and MYSQL web development
Author: Luke Welling
Laura Thomson
2. Dynamic Web Page Development
Author: Jitendra patel
33
Online loan application and verification 2016
34
