MCSP-060 ENROLLMENT NO.

170159640

TITLE OF THE PROJECT

ONLINE VEHICLE LOAN

TABLE OF CONTENT
S. N CONTENTS PAGE NO

1
MCSP-060 ENROLLMENT NO. 170159640

1. INTRODUCTION………………………………………………………………………………. 3

2. OBJECTIVE………………………………………………………………………………………. 4

3. PROBLEM DEFINATION…………………………………………………………………… 5

4. SOFTWARE REQUIREMENT SPECIFICATION…………………………………….. 7

5. USER OF SYSTEM……………………………………………………………………………. 9

6. FUNCTIONAL REQUIRMENT……………………………………………………………. 10

7. MODULE AND WORKING……………………………………………………………….. 11

8. PROJECT CATEGORY………………………………………………………………………. 12

9. HARDWARE AND SOFTWARE SPECIFICATION ……………………………….. 14

10. TOOL AND PLATFORM TO BE USED……………………………………………….. 15

11. DATA FLOW DIAGRAM …………………………………………………………………. 25

12. ER DIAGRAM ………………………………………………………………………………… 32

13. DATA STRUCTURE…………………………………………………………………………. 34

14. TESTING TO BE USED…………………………………………………………………….. 37

15. SECURITY MECHANISM…………………………………………………………………. 38

16. FUTURE AND SCOPE ENHANCEMENT ……………………………………………. 39

17. BIBLIOGRAPHY………………………………………………………………………………. 40

2
MCSP-060 ENROLLMENT NO. 170159640

INTRODUCTION OF PROJECT

ONLINE VEHICLE LOAN is web based project. it will be used by any banking and non-banking company
that is providing loan facility for vehicles like bike, car etc. vehicle loan is very much growing sector that
involves lots of paper work due to this customer get very difficulty to get vehicle loan. this project will
help company to automate loan approval process where any one can easily apply for loan and can get
approval within 24 business hour.

This is the project for the online vehicle loan system, it will be used by loan providing company
which in most cases has problems with loan approval and scheduling process. This project
intends to computerize and provide web based services in which loan can be provided easily to
customer. Company can provide the easier way for staff to manage software.

In this, customer can online apply for loan and check loan status. This project will give focus on finance
management of finance company. In this finance company can decide on the basis of document
submitted by customer to approve loan amount.

ONLINE VEHICLE LOAN enables the customer to apply loan online, check approval status, pay EMI
Online, and ask for information online easily. It also provides facility for staff of loan providing
company to access system from anywhere and can approve loan and update details.

3
MCSP-060 ENROLLMENT NO. 170159640

OBJECTIVE

The purpose of this system is to manage and control vehicle loan system for customer and
provide facility to view available loan, amount and interest rate online.

The vehicle finance system is a web based software that will be designed to manage loan
application and EMI payment to ensure better service with optimized cost online.

In this software, customer can easily apply for providing loan on line, after approval, all details
of loan, status, can be checked easily.

The main objective of finance system is to provide complete and easy loan solution for customer
so that any customer can apply loan easily form anywhere and anytime as per their
requirement.

This will reduce manual work a lot for loan processing and customer can get approval instantly
and easily. They need to wait long time for approval. This system will increase more customer to
apply for loan hence finance company can generate more and more revenue.

4
MCSP-060 ENROLLMENT NO. 170159640

PROBLEM DEFINITION

Problem with current system

PROBLEM OF THE MANUAL OPERATION

Problem of manual operation occurs when loan providing company want to view loan details for
old customer quickly.

PROBLEM OF RELIABILITY

In the manual system, the data would not be reliable. Because any changes made need to be
update on all places that is very difficult to maintain. If data is not update at every place then
we will have inconsistent data that means reliability will be low.

PROBLEM OF ACCURACY

Problem of accuracy occur when the staff member forgets to update EMI details paid by
customer.

PROBLEM OF VALIDITY

In manual operation, there is very difficult to update all the information of customers and loan
details.

Need for proposed system

There are some advantages over the old version of this system.

This version of the system is fully computerized and online. In this system, some
advantages as are follows :--

Computerized system

The present system gives result faster than the old version of the system and also
online facility to work from multiple location.

5
MCSP-060 ENROLLMENT NO. 170159640

More accurate

The present system gives the result more accurate than the old system and provide
central approach in which any change made would be reflected to all users of system.

Easy maintenance

In the present system, the maintenance of record is easy than manual Operation

More reliable

Data in this system is more authentic than the old system.

Less time

In the present system, the data retrieves faster than the old System.

Easy search

In the present system the searching of loan details or Emi detail be can be done
easily.

Database maintenance

In the new computerized system the database maintenances can be done easily.

6
MCSP-060 ENROLLMENT NO. 170159640

ANALYSIS DOCUMENTS
SOFTWARE REQUIREMENT SPECIFICATION

The software requirement specification (SRS) is very important part of the software building

process, which describes the actual user level requirement from technical point of view. i.e. what

the user exactly wants? The objective of preparing the software requirement specification is to

represent the requirements of the software in such a manner that ultimately leads to successful

software implementation. It is the result of the analysis process of the software development. It

should contain all the data the software is going to process, the function it will provide, and the

behavior it will exhibit.

This Software Requirements Specifications (SRS) is defined in IEEE Std. 830-1993, IEEE

Recommended Practice for Software Requirements Specifications. The synopsis is prepared in

the way to fulfill almost all the points needed in S.R.S. There is a format of SRS that contains

followings.

TECHNICAL REQUIREMENT

7
 MCSP-060 ENROLLMENT NO. 170159640

 Productivity :- Proposed software must accomplish the all task of

institution according to the management.

 Reliability :- Operation must perform complete or accurate task.

 Security :- All information must be secure.

 Scalability: - The architecture adopted to develop this project must

Have technical flexibility to adopt the change in future.

 Integration : - All modules must be property integrated with each

Other so that performance of system must be better.

Designing Software

Photoshop and Flash are used to make attractive colorful user interface of the forms of the project
and make effective animation.

SYSTEM ANALYSIS

The analysis model must achieve three primary objectives: -

 The information domain of a problem must be represented and understood.

 The functions that the software is to perform must be defined.

 The behavior of the software (as a consequence of external events) must be

represented.

 The models that depict information function and behavior must be partitioned in a
manner that uncovers detail in a layered (or hierarchical) fashion.

 The analysis process should move from essential information toward

implementation detail.

8
MCSP-060 ENROLLMENT NO. 170159640

USER OF THE SYSTEM

Customer: customer will use this system to apply loan online and fill all required
information for processing of vehicle loan. After apply, customer can also check
loan application status submitted by customer after specific period of time.
Customer can also check calculate emi details on loan amount, can view loan
details after approval, can pay emi online much more.

Company staff: Vehicle finance company can process loan application on line and
can also view all the documents submitted by customer online. Staff can also
update, view, verify information of customer online by using this system.

Company manager: Vehicle finance company manager can check loan status, and
generate various reports for taking decisions for further business improvements.
And also can check process of company.

Vehicle Showroom: Once loan is approved vehicle showroom will get payment
from Finance company. Also Vehicle showroom can check status of customer loan.

9
MCSP-060 ENROLLMENT NO. 170159640

FUNCTIONAL REQUIREMENTS

For customers

1. Easy interface to find loan details and apply for loan.

2. Easily online payment system for EMI.
3. Easy way to calculate loan EMI and interest rate.
4. Any time can pay full amount as per their convenience.
5. Print out details online form anywhere.

Finance company Staff

1. Easy interface to check member details and approve interface.

2. Easy interface to update and delete irrelevant information.
3. Easy Way to generate Reports for manager.
4. Easy way to Ensure user safety.

Vehicle showroom

1. Interface to track loan applied by customer.

2. Easy way to check payment details.

NON-FUNCTIONAL REQUIREMENT

1. 24X7 Availability.
2. Secure access control.
3. Error correction: Ensure user can correct errors with minimal problems.

10
MCSP-060 ENROLLMENT NO. 170159640

MODULE AND WORKING

Login Module: this module will be used by loan providing company staff and managers to login
into system. It will also be used by vehicle showroom staff to track payment details received
form loan providing company.

Registration Module: this module will be used by customer to apply for loan online and upload
all necessary documents as required.

Check Status Module: this module will be used to check online loan status by just providing
registration no.

Verify process module: this module will be used by vehicle loan providing company staff to
verify details of customer online so that they can process loan application further.

Payment module: this module will be used by loan providing company staff to update details of
payment for vehicle showrooms.

Check payment Status: this module will be used by vehicle showroom to track payment status
and details of payment made by loan providing company.

EMI Calculator: This module will be used by customer to calculate emi and interest rate on loan
amount.

EMI Process: this module will be used by authorized exiting customer to pay emi online and can
also check previous payment made and remaining EMI’s.

LOAN Details: this module will be used by authorized customer to check their approved loan
details and amount that has been sent to vehicle showrooms.

Report modules: this module will be used by staff of loan providing company to generate and
view various reports.

11
MCSP-060 ENROLLMENT NO. 170159640

PROJECT CATEGORY

The synopsis work entitled “ONLINE VEHICLE LOAN” comes under category “RDBMS”.
Hence before discussing anything about the project, a brief discussion of the related
basic concept is necessary.

As a software developer or as a programmer, we are expected to designing and

develop every programme that works correctly, efficiently and at the same time is easy
to be used by any person who may or may not be well versed with the computer and its
capabilities. The application programs written in any language must be such that not
much effort is/ should be required on the part of the user to understand and use its
application. The package should be user-friendly.

BASIC DATABASE CONCEPT

A database is a collection of related information stored so that it is available to may

users for different purposes. It consist of a collection of interrelated data and a set of
programs sot access those data. It is a coherent collection of data with some inherent
meaning and design built and populated with data for a specific purpose. A database
stores data that is useful to us. This data is only a part of the entire data available in the
world around us.
To be able to successful design and maintain database, we have to do the following:

Identify which part of the world’s data is of interest to us.

Identify what specific objects in the part of the world’s data are of interests.
Identify a relationship between the objects.
Hence, the objects, their attributes and the relationships between them that are of interest to
us are in the database which is designed, built and populated with data for a specific purpose.

CHARACTERISTICS OF DATABASE MANAGEMENT SYSTEM

12
MCSP-060 ENROLLMENT NO. 170159640

 Provides creation of a file, addition & deletion & modification of data, creation, addition
and deletion of entire files.

 Provides retrieval of data collectively or selectively by database.

 Proves storing and indexing the data stored at user’s discretion and direction.

 Provides performance of Mathematical function and manipulation of the data stored in

the database to perform the desired calculation.

 Provides form-based interface for easy accessibility and data entry.

 Provides maintenance of data integrity and database use.

 Provides complex a tight control over data redundancy.

 Provides enforcement of user defined rules to ensure the integrity to table data.

 Provides a centralized data dictionary for the storage of information pertaining to data
and its manipulation.

 Provides ensuring the data can be shared across applications.

 Provides automatic intelligent backup and recovery procedures for data.

 Provides different interfaces via which users can manipulate data.

Hardware & Software Specification

13
MCSP-060 ENROLLMENT NO. 170159640

HARDWARE SPECIFICATION:

PROCESSER INTEL PENTIUM

RAM 2 GB

HARD DISK 160GB

SOFTWARE SPECIFICATION:

OPERATING SYSTEM Window XP/2007/2008

PROGRAMMING LANGUAGE JAVA

TECHNOLOGY AND FRAMEWORK JSP, STRUTS, HIBERNET, SPRING etc.

SOFTWARE (FRONTEND) ECLIPSE

SOFTWARE (BACKEND) POSTGRES SQL

14
MCSP-060 ENROLLMENT NO. 170159640

TOOLS AND PLATFORM TO BE USED

HTML
HTML(Hypertext Markup Language) is the predominant markup language for web pages. It
provides a means to describe the structure of text-based information in a document by
denoting certain text as headings, paragraphs, lists, and so on and to supplement that text with
interactive forms, embedded images, and other objects. HTML is written in the form of labels
(known as tags), surrounded by angle brackets.

Advantages

 A HTML document is small and hence easy to send over the net. It is small
because it does not include formatted information.
 HTML is platform independent.
 HTML tags are not case-sensitive.

JavaScript

JavaScript is a script-based programming language that was developed by Netscape

Communication Corporation. JavaScript was originally called Live Script and renamed as
JavaScript to indicate its relationship with Java. JavaScript supports the development of both
client and server components of Web-based applications. On the client side, it can be used to
write programs that are executed by a Web browser within the context of a Web page. On the
server side, it can be used to write Web server programs that can process information
submitted by a Web browser and then update the browser’s display accordingly.

15
MCSP-060 ENROLLMENT NO. 170159640

Java Technology

Initially the language was called as “oak” but it was renamed as “Java” in 1995. The primary
motivation of this language was the need for a platform-independent (i.e., architecture neutral)
language that could be used to create software to be embedded in various consumer electronic
devices.

 Java is a programmer’s language.

 Java is cohesive and consistent.
 Except for those constraints imposed by the Internet environment, Java gives the
programmer, full control.
 Finally, Java is to Internet programming where C was to system programming

Java Database Connectivity

JDBC is a Java API for executing SQL statements. (As a point of interest, JDBC is a trademarked
name and is not an acronym; nevertheless, JDBC is often thought of as standing for Java
Database Connectivity. It consists of a set of classes and interfaces written in the Java
programming language. JDBC provides a standard API for tool/database developers and makes it
possible to write database applications using a pure Java API.

Using JDBC, it is easy to send SQL statements to virtually any relational database. One can write
a single program using the JDBC API, and the program will be able to send SQL statements to
the appropriate database. The combinations of Java and JDBC lets a programmer write it once
and run it anywhere.

What Does JDBC Do?

Simply put, JDBC makes it possible to do three things:

 Establish a connection with a database

16
MCSP-060 ENROLLMENT NO. 170159640

 Send SQL statements

 Process the results

JDBC connectivity

The JDBC provides database-independent connectivity between the J2EE platform and a wide
range of tabular data sources. JDBC technology allows an Application Component Provider to:

 Perform connection and authentication to a database server

 Manager transactions
 Move SQL statements to a database engine for preprocessing and execution
 Execute stored procedures
 Inspect and modify the results from Select statements

SQL

Structured Query Language (SQL) is the language used to manipulate relational databases. SQL
is tied very closely with the relational model.

In the relational model, data is stored in structures called relations or tables.

SQL statements are issued for the purpose of:

Data definition: Defining tables and structures in the database (DDL used to create, alter and
drop schema objects such as tables and indexes).

Data manipulation: Used to manipulate the data within those schema objects (DML Inserting,
Updating, Deleting the data, and Querying the Database).

17
MCSP-060 ENROLLMENT NO. 170159640

SERVLETS
Introduction

The Java web server is Java Software own web Server. The Java web server is just a part of a
larger framework, intended to provide you not just with a web server, but also with tools. To
build customized network servers for any Internet or Intranet client/server system. Servlets are
to a web server, how applets are to the browser.

About Servlets

Servlets provide a Java-based solution used to address the problems currently associated with
doing server-side programming, including inextensible scripting solutions, platform-specific
APIs, and incomplete interfaces.

Servlets are objects that conform to a specific interface that can be plugged into a Java-based
server.

Attractiveness of Servlets

There are many features of Servlets that make them easy and attractive to use. These include:

 Easily configured using the GUI-based Admin tool

 Can be loaded and invoked from a local disk or remotely across the network.
 Can be linked together, or chained, so that one Servlets can call another Servlets,
or several Servlets in sequence.
 Can be called dynamically from within HTML pages, using server-side include
tags.
 Are secure - even when downloading across the network, the Servlets security
model and Servlets sandbox protect your system from unfriendly behavior.
Features of Servlets:

 Servlets are persistent. Servlet are loaded only by the web server and can maintain
services between requests.

18
MCSP-060 ENROLLMENT NO. 170159640

 Servlets are fast. Since Servlets only need to be loaded once, they offer much better
performance over their CGI counterparts.
 Servlets are platform independent.
 Servlets are extensible. Java is a robust, object-oriented programming language,
which easily can be extended to suit your needs
 Servlets are secure.
 Servlets can be used with a variety of clients.

Java Server Pages (JSP)

Java server Pages is a simple, yet powerful technology for creating and maintaining dynamic-
content web pages. Based on the Java programming language, Java Server Pages offers proven
portability, open standards, and a mature re-usable component model .The Java Server Pages
architecture enables the separation of content generation from content presentation. This
separation not eases maintenance headaches; it also allows web team members to focus on
their areas of expertise. Now, web page designer can concentrate on layout, and web
application designers on programming, with minimal concern about impacting each other’s
work.

Features of JSP

Portability:

Java Server Pages files can be run on any web server or web-enabled application server that
provides support for them. Dubbed the JSP engine, this support involves recognition,
translation, and management of the Java Server Page lifecycle and its interaction components.

Components

It was mentioned earlier that the Java Server Pages architecture can include reusable Java
components. The architecture also allows for the embedding of a scripting language directly
into the Java Server Pages file. The components current supported include Java Beans, and
Servlets.

Processing

19
MCSP-060 ENROLLMENT NO. 170159640

A Java Server Pages file is essentially an HTML document with JSP scripting or tags. The Java
Server Pages file has a JSP extension to the server as a Java Server Pages file. Before the page is
served, the Java Server Pages syntax is parsed and processed into a Servlet on the server side.
The Servlet that is generated outputs real content in straight HTML for responding to the client.

Eclipse IDE

Eclipse is an open-source software framework written primarily in Java. In its default form it is
an Integrated Development Environment (IDE) for Java developers, consisting of the Java
Development Tools (JDT) and the Eclipse Compiler for Java (ECJ). Users can extend its
capabilities by installing plug-ins written for the Eclipse software framework, such as
development toolkits for other programming languages, and can write and contribute their own
plug-in modules. Language packs are available for over a dozen languages.

STRUTS
Apache Struts 2 is an elegant, extensible framework for creating enterprise-ready Java
web applications. The framework is designed to streamline the full development cycle,
from building, to deploying, to maintaining applications over time. Apache Struts 2 was
originally known as WebWork 2.

This tutorial will teach you how to use Apache Struts for creating enterprise-ready Java
web applications in simple and easy steps.

Struts2 is popular and mature web application framework based on the MVC design
pattern. Struts2 is not just the next version of Struts 1, but it is a complete rewrite of
the Struts architecture.

The WebWork framework started off with Struts framework as the basis and its goal
was to offer an enhanced and improved framework built on Struts to make web
development easier for the developers.

After some time, the Webwork framework and the Struts community joined hands to
create the famous Struts2 framework.

Struts 2 framework features:

20
MCSP-060 ENROLLMENT NO. 170159640

Here are some of the great features that may force you to consider Struts2:

POJO forms and POJO actions - Struts2 has done away with the Action Forms that were an
integral part of the Struts framework. With Struts2, you can use any POJO to receive the form
input. Similarly, you can now see any POJO as an Action class.

Tag support - Struts2 has improved the form tags and the new tags allow the developers to
write less code.

AJAX support - Struts2 has been recognized the takeover by Web2.0 technologies, and has
integrated AJAX support into the product by creating AJAX tags, that function very similar to
the standard Struts2 tags.

Easy Integration - Integration with other frameworks like Spring, Tiles and SiteMesh is now
easier with a variety of integration available with Struts2.

Template Support - Support for generating views using templates.

Plugin Support - The core Struts2 behaviour can be enhanced and augmented by the use of
plugins. A number of plugins are available for Struts2.

Profiling - Struts2 offers integrated profiling to debug and profile the application. In addition
to this, Struts also offers integrated debugging with the help of built in debugging tools.

Easy to modify tags - Tag markups in Struts2 can be tweaked using Free marker templates. This
does not require JSP or java knowledge. Basic HTML, XML and CSS knowledge is enough to
modify the tags.

Promote less configuration - Struts2 promotes less configuration with the help of using default
values for various setti ngs. You don't have to configure something unless it deviates from the
default setti ngs set by Struts2.

View Technologies: - Struts2 has a great support for multiple view options (JSP, Free marker,
Velocity and XSLT)

21
MCSP-060 ENROLLMENT NO. 170159640

This hibernate tutorial provides in-depth concepts of Hibernate Framework with simplified
examples. It was started in 2001 by Gavin King as an alternative to EJB2 style entity bean. The
stable release of Hibernate till July 16, 2014, is hibernate 4.3.6. It is helpful for beginners and
experienced persons.

H IBERNATE FRAMEWORK
Hibernate framework simplifies the development of java application to interact with the
database. Hibernate is an open source, lightweight, ORM (Object Relational Mapping) tool.

An ORM tool simplifies the data creation, data manipulation and data access. It is a
programming technique that maps the object to the data stored in the database.

The ORM tool internally uses the JDBC API to interact with the database.

ADVANTAGES OF HIBERNATE FRAMEWORK

There are many advantages of Hibernate Framework. They are as follows:

1) Open source and Lightweight: Hibernate framework is open source under the LGPL license
and lightweight.

22
MCSP-060 ENROLLMENT NO. 170159640

2) Fast performance: The performance of hibernate framework is fast because cache is

internally used in hibernate framework. There are two types of cache in hibernate framework
first level cache and second level cache. First level cache is enabled by default.

3) Database Independent query: HQL (Hibernate Query Language) is the object-oriented version
of SQL. It generates the database independent queries. So you don't need to write database
specific queries. Before Hibernate, If database is changed for the project, we need to change the
SQL query as well that leads to the maintenance problem.

4) Automatic table creation: Hibernate framework provides the facility to create the tables of
the database automatically. So there is no need to create tables in the database manually.

5) Simplifies complex join: To fetch data form multiple tables is easy in hibernate framework.

6) Provides query statistics and database status: Hibernate supports Query cache and provide
statistics about query and database status

POSTGRESQL

PostgreSQL is a powerful, open source object-relational database system. It has more than 15
years of active development and a proven architecture that has earned it a strong reputation for
reliability, data integrity, and correctness.

PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI
IRIX, Mac OS X, Solaris, Tru64), and Windows.

Key features of PostgreSQL

PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI
IRIX, Mac OS X, Solaris, Tru64), and Windows. It supports text, images, sounds, and video, and
includes programming interfaces for C / C++ , Java , Perl , Python , Ruby, and Open Database
Connectivity (ODBC).

PostgreSQL supports a large part of the SQL standard and offers many modern features
including the following:

23
 MCSP-060 ENROLLMENT NO. 170159640

 Complex SQL queries

 SQL Sub-selects

 Foreign keys

 Trigger

 Views

 Transactions

 Multi-version concurrency control (MVCC)

 Streaming Replication (as of 9.0)

 Hot Standby (as of 9.0)

You can check official documentation of PostgreSQL to understand above-mentioned features.

PostgreSQL can be extended by the user in many ways, for example by adding new:

 Data types

 Functions

 Operators

 Aggregate functions

 Index methods

24
MCSP-060 ENROLLMENT NO. 170159640

DFD (DATA FLOW DIAGRAM)

Data flow diagrams are widely used for modeling for requirements. DFDs show the flow of data through
a system. The DFD is also known as a data flow graph or a bubble chart.

Standard symbol used for DFD

1. Data flow

It is used to connect processes to each other, to sources or sinks, the arrowhead indication the direction
of data flow.

2. Process

It is used to represent some transformation of input data to yield output data.

3. Source or sink (External entity)

a source of system input or sink of system outputs.

4. Data store

It is used for repository of data. The arrowheads indicate net inputs and net outputs to stor

25
 MCSP-060 ENROLLMENT NO. 170159640

DFD OF 0 LEVEL

Apply loan

Verify details pass of fail loan

CUSTOMER
ONLINE
VEHICLE LOAN Finance company
Get approval or not
View report

Get payment for vehicle

Vehicle company

26
 MCSP-060 ENROLLMENT NO. 170159640

DFD 1st LEVEL

Do registration

Customer Registration
details Registration_table

Check status

Check status Status_table

process

Verify process

Company staff

User name/password If yes

Payment_table
Get payment
Payment
Login
Login_table process
process

Vehicle Showroom

Pay emi
Member EMI
payment EMI_table
process

View loan details

Loan details
Loan_table

Make
Finance
Company staff

Report
generation

27
 MCSP-060 ENROLLMENT NO. 170159640

View
Manager

Login Process

User name/password

Company Staff

Login Login_table
process
Member

Member id/password

User Registration process

give Registration

details

Customer

Registration_table

View/modify

details

28
 MCSP-060 ENROLLMENT NO. 170159640

Check status process

Enter Id
View status

Customer

Status_table

Enter details to modify Modify/ Validate

process
Company staff
ompany staff

View Customers

View customer details to verify Verify process

Registration_table
Company staff
ompany staff
Status_table

29
MCSP-060 ENROLLMENT NO. 170159640

Payment process

Payment
Gives payment
Finance Company process
ompany staff

Payment_table
Gate payment
Vehicle Company
ompany staff

Validate Update
Finance Company
staff
ompany staff

Emi Payment process

EMI Payment
Pay EMI
View payment
Member
ompany staff

Emi_table

Validate Update
Finance Company
staff
ompany staff 30
MCSP-060 ENROLLMENT NO. 170159640

Loan Details

Loan Details
Update
Finance Company
staff
ompany staff
Loan_table

View Loan
Enter member Id details
Member
ompany staff

31
MCSP-060 ENROLLMENT NO. 170159640

ER DIAGRAM
An Entity-Relationship (ER) Diagram is a specialized graphic that illustrates the interrelationships
between entities in a database. ER diagrams often use symbols to represent three different types of
information. Boxes are commonly used to represent entities. Diamonds are normally used to represent
relationships and ovals are used to represent attributes. If the application is primarily a database
application, the entity-relationship approach can be used effectively for modeling some parts of the
problem. The main focus in ER modeling is the Data Items in the system and the relationship between
them. It aims to create conceptual scheme for the Data from the user’s perspective. The model thus
created is independent of any models are

Symbols used in E-R diagram

1. Entity box

This box contains a particular Entity, which may be any object of real world or hypothetical object.

2. Attribute symbol

This symbol is used or defining the attributes of a particular entity.

3. Diagonal symbol

This symbol is used to establish relationship among various departments or clients, which may also have,
attribute value.

32
 MCSP-060 ENROLLMENT NO. 170159640

Ph_no Address

Name

1
Vehicle Finance Company
1
Track_id Customer_name

has
Annual_incom
provides
Check_status

EMI Loan_id
1
Customer apply

Duration
Dob
1
Vehicle loan
Cust_address Sex
address
name N

Gets Staff id Loan company staff

1 1
duati
Loan_id Make
details
1 EMI
pays
Member N
N
amount pays

date N

Payment
gets
Payment_no

Address Comaney_name amount

Loan_id

Gets
1

Ph.no Vehicle showroom 33

MCSP-060 ENROLLMENT NO. 170159640

DATA STRUCTURE
1. Login_table

Filed Name Data type Validation

User_name Varchar(20) Not null
Password Varchar(20) Not Null

2. Vehicle Registration

Field Name Data type Validation

Registration_id Numeric(15) Primary key
Date_of_registraiton Date Not null
Amount Numeric(10) Not Null
Vehicle_name Varchar(20) Not nul
Model_no Numeric(10) Not null

3. Customer Registration

Filed Name Data Type Validation

Customer_id Numeric(15) Primary key
Name Varchar(20) Not null
Dob Datetime Not null
Address Varchar(20) Not null
Proof Varchar(20) Not null
Mob_no Numeric(11) Not null
Income_amount Numeric(10) Not null
Job_detail Varchar(25) Not null

4. Payment

Filed Name Data Type Validation

Transaction_id Numeric(10) Primary key
Customamer_id Numeric(10) Not null
Loan_amount Numeric(15) Not null
Date_of_payment Datetime Not null
Showroom_id Numeric(10) Not null
Amount Numeric(10) Not null
Type_of_payment Varchar(25) Not null

34
MCSP-060 ENROLLMENT NO. 170159640

5. Vehicle_ showrrom_details

Filed Name Data Type Validation

Showroom_id Numeric(10) Primary key
Address Varchar(25) Not null
Ph_no Numeric(11) Not null
Showroom_name Varchar(25) Not null

6. Loan_details

Filed Name Data Type Validation

Loan_id Numeric(10) Primary key
Customer_id Numeric(10) Not null
Loan_amount Numeric(10) Not null
Date_of_disbursed Datetime Not null

7. Emi_details

Fileld Name Data Type Validation

Loan_id Numeric(15) Not null
Customer_id Data type Primary key
Emi_amount Numeric(15) Not null
No_of_emi Numeric(10) Not null
Interest_rate Numeric(10) Not null
Complete_date_emi Datetime Not null

8. EMI_payment

Filed Name Data Type Validation

Loan_id Numeric(15) Primary key
Customer_id Numeric(15) Not null
Last_emi_paid_date dateTime Not null
Next_emi_paid_date Datetime Not null
Amont Numeric(10) Not null

35
MCSP-060 ENROLLMENT NO. 170159640

Mode_of_payment Varchar(15) Not null

REPORTS TO BE GENERATED

REGISTRATION DETAILS: this details will be provide all information of customer who is applying
vehicle loan like name, dob, address, proof, loan_amount, professional details, income, proof ,
date of registration etc.

CUSTOMER DETAILS: This report will generate all customer information like customer_id, name,
address, dob etc.

STATUS DETAILS: this report will generate status of previous applied loan like id, date of apply,
status.

LOAM COMPANY STAFF DETAILS: it will include staff_id, name, address, salary etc.

PAYMENT DETAILS: this will include payment id, amount, date of payment, customer id etc.

EMI PROCESS DETAILS: this will include, customer id, emi amount, date of emi etc.

LOAN DETAILS: it will include loan id, loan_ amount, customer _id, date of disbursed etc.

36
MCSP-060 ENROLLMENT NO. 170159640

VEHICLE SHOWROOM DETAILS: this will include all details of vehicle showroom like company
name, location, phno. etc.

TESTING TO BE USED

In order to ensure that the system works perfectly, it has to be rigorously tested. The testing
procedure would be used to check all the features developed for the “ONLINE VEHICLE FINANCE
SYSTEM” work efficiently, the test procedure would also be used to identify any hidden errors or
deficiencies the system may possess.

Test Strategies

There is a number of testing strategies that can be utilized to conduct adequate

testing processes, the black box and white box testing methods are the most popular method to
test software developed systems

Black Box Testing

This testing strategy which is also known as functional testing is used by a tester who has no
knowledge of the internal structure of the system. The tester does not test the programming
code itself but instead performs the test based on previously understood requirements. This
form of testing is usually conducted by the end user, who would enter an input into the system
and check for an expected output. The advantage of using black box testing is that the test can
be done by the users of the system, without them needing to have prior knowledge of the
system’s code

White Box Testing

This testing strategy which is also known as glass box or structural testing is used to test the
internal logic and structure of the programming code used to develop the system. The tester
would need to have unequivocal knowledge of the coding used for developing the system, in
order to uncover any malfunctioning code. In order to test system adequately both testing
strategies have to be utilized.

37
MCSP-060 ENROLLMENT NO. 170159640

SECURITY MECHANISM

As the project is developed using java the security policy of ONLINE VEHICLE
FINANCE SYSTEM, is quiet enhanced in nature.

There are several level of security that has been applied for this software as per
day-to-day functioning is concerned.

These securities are termed as

User level security

Form level security
Table level security

Table level security concerns with the recovery of the old and deleted records.

Similarly form level security deals with the validity of the messages that are
provided at front end.

38
MCSP-060 ENROLLMENT NO. 170159640

User level security deals with protection from unwanted access through any
unauthorized personnel.

FUTURE SCOPE AND ENHANCEMENT

This project has been prepared keeping in mind the standard rules and
regulations as well as standard data of Online loan system that may be similar
to another similar process. It means having changed slightly, this project can be
also used in other organization of this nature. As per as output of the project is
concerned it covers all-important details regarding the customer and their
respective online payments. Therefore, it will help:

 Storing large amount of data from future point of view

 Reducing manual efforts for processing the records
 Reducing manual efforts for maintaining the records
 Reducing the lead time

This project can also be used by financial institution whose principal business is to
providing loans or for any activity related to finance.

39
MCSP-060 ENROLLMENT NO. 170159640

BIBLIOGRAPHY

Books Reference:

Software Engineering -Pressman

Relational Database Management system -B.C. Desai

Java2 HerberiSchildi

Java7 Black book

Java server programming Allamaraju

Struts 2 with Hibernate Sharanam Shah, Vaishali Shah

40