insurnce project report-4th sem

8/22/2019 Insurnce Project Report-4th Sem

1/55

1

ACKNOWLEGMENT

It is great pleasure to present this report on the project named INSURANCE MANEGMENT

SYSTEM undertaken by me as part of my B. Tech (CSE) curriculum.

I am thankful to PTU and IGCE ABHIPUR for offering me such a wonderful challenging

opportunity and I express my deepest thanks to all coordinators, of IGCE ABHIPUR for

providing all the possible help and assistance and their constant encouragement.

It is a pleasure that we find ourselves penning down these lines to express our sincere thanks to

the people who helped us along the way in completing our project. We find inadequate words to

express our sincere gratitude towards them.

First and foremost we would like to express our gratitude towards our training guide ER. AMIT

JAIN for placing complete faith and confidence in our ability to carry out this project and forproviding us his time, inspiration, encouragement, help, valuable guidance, constructive criticism

and constant interest. He took personal interest in spite of numerous commitments and busy

schedule to help us complete this project. Without the sincere and honest guidance of our

respected project guide we would have not been to reach the present stage.

We are also thankful to Mr. Ashish Kumar (Coordinator) for their support in guiding us and

giving us the right direction every time we need.


2/55

2

ABSTRACT

The insurance company needs to keep track of details of its target companies, agents,

policyholders, their premium payments and the various products that are available with it.

Hence it is under tremendous pressure maintaining their day-to-day activities, which is currently

being done manually.

Entire records have to be updated timely, even a slight mistake could complicate things.

It is very difficult to handle bulk data since human memory is weaker than electronic counter

part. It is time consuming to summarize these details to produce the reports.

The Insurance management system is a complete solution for organizations, which need to

manage insurance for their vehicles, Health, Life. Organizes and tracks insurance vendors and

the policies provided under different coverage.

We are offering a robust web based insurance solution, which has the flexibility of

customizations to match the specific needs of clients.

Hence there is need for an automated system, which can efficiently manage the company,

records, provides instant access and one that improves the productivity. As a result of this

automated system, the activities of the company are performed with in the stipulated time and

the reliable and efficient service is ensured to its users.

We are offering a robust web based insurance solution, which has the flexibility of

customizations to match the specific needs of clients for achieving their business goal of good

service and revenue generation.


3/55

3

PREFACE

Learning comes from doing. To learn something one has to go through Practical conditions.

Recognizing this fact, the University has made it essential for Computer Science and

Engineering (CSE) students to undergo Industrial Training for six weeks. During this period,

the student learns about the functioning of the organization and the actual business environment.

Also this training helps the student how to implement the theoretical knowledge into practical

life, in our day to day life. This project report was prepared during the training period in the

month of MayJune.

During this period, an effort was made to understand INSURANCE MANEGEMENT

SYSTEM and to finish the project work assigned to us. This report lays special emphasis on the

operational work, tasks and projects carried out during the training period.


4/55

4

L I ST OF CONTENT

CONTENTS PAGE NO

Acknowledgement 1

Abstract 2

Preface 3

Company Profile 6

Project Description 7

Utility 8

Component of Project 9

Requirement Analysis 11

Module 12

Introduction To tools 13

1. Front End

2. Back End

Why J2EE? 14

J2EE History 15

About JSP 16

MySQL 19

Analysis 20


5/55

5

1. Requirement analysis

2. System analysis

Design Phase (Screen shots) 22

Source Code 26

ER Diagram 44

Data Base Design 47

Conclusion 51

Bibliography 52


6/55

6

COMPANY PROFILE

NIELIT (erstwhile DOEACC Society), an Autonomous Scientific Society under theadministrative control of Department of Information Technology, Ministry of Communications

and Information Technology, Govt. of India, was set up to carry out Human ResourceDevelopment and related activities in the area of Information, Electronics & CommunicationTechnology (IECT).

The Society is engaged both in the Formal & Non- Formal Education in the area of IECT besidesdevelopment of industry oriented quality education and training in the stateof-the-art areas and

to establish standards to be the countrys premier institution for Examination and Certification in

the field of IECT. It is also a National Examination Body, which accredits

institutes/organizations for conducting courses in IT in the non-formal sector of IT Education &Training.

The Certificate Course on Computer Concepts (CCC) of NIELIT has got recognition fromvarious State Governments and Central Govt. Departments as basic course of IT/ ComputerLiteracy. Since inception of the CCC course, 5.16 lakhs candidates have appeared for

examination and 3.74 lakh candidates have been certified.

The Society is also undertaking government sponsored projects in the field of ICT & related

activities. The Society is also embarking upon training program to develop entrepreneurs and

provide IECT based services to users.


7/55

7

PROJECT DESCRIPTION

Online Insurance is a web application which is used to tracking the details about the

insurance policy, customer details and company details. This project is useful for any kind of

insurance company to manage the insurance details, to sanction the insurance for customer,

process the insurance policy details and all kind of insurance process through online.

In this online process the user enter into the website it will show details about insurance

and its types, also it will show the details about different duration schemes to the corresponding

insurance type or insurance policy. In this process contains the user registration form which is

used to apply for insurance policy through online. It also helps the customer to view their own

insurance status information.

If the user registered insurance policy to this website, it will process that registrationform by verification and immediately give the temporary policy holder ID to the user. After

submission of registration form the admin will process to verify that particular details registered

by the customer and sanctioned the insurance policy. Then the admin send the permanent policy

holder ID and password to the customer and also send status information about insurance policy

to the corresponding policy holder.

If the policy holder wants to view the information about their own policy details, he/she

login to policy status page by using the policy holder ID and password had already given by

insurance company and view their own details and also they give feedback to the insurance

company.


8/55

8

UTILITY

In the present situation where the technology is the buzzword and has revolutionized the way

we work and live, we would be the losers if we do not keep up with the changing world.Moreover, it makes a world of difference and a whole of sense to break-up from the age old

work culture and embrace the effective, cost, and time saving ways of looking and working a

things.

In this Project a user can buy a new policy online and can pay the amount via online transfer.

User can also choose the method of paying to Companies agent through Demand Draft ,

Cheque and by cash method. Then agent can enter the detail of cash, demand draft no and

Cheque no. on the data base by login in the system.

This is precisely where the Online Insurance supports and improves many of the core

functionality of the insurance organization i.e. insurance project helps in quick easy monitoring

of the reports that have been automatically generated as and when the admin and policy agent

performs transactions in the system. Using such a system helps the organization in minimizing

the time consumed in fulfilling the day-to-day functionalitys and cutting down the expenses

incurred on the same


9/55

9

COMPONENTS OF PROJECT

The proposed system is for making easier to manage policy holder details, agent details,

policy details, claimant details and payment details. So this will be developed for managing the

insurance management system. The overall system is control through the main menu.

The main menu contains 6 parts.

1. Home

2. About Us

3. Customer Services

4. Our Planes

5. Media Center

6. Contact usThe Tabs of Side Bar are:

1. Register

2. Login

3. Life Insurance

4. Health Insurance

5. Vehicle Insurance

6. Why You Need Insurance?

7. Downloads

8. Premium Calculator

9. Premium Claim

10.Track Your Application

11.Branch Locator

POLICY SCHEMES:-

Various policy schemes are:-

1. LIFE INSURANCE

2. HEALTH INSURANCE

3. VEHICAL INSURANCE


10/55

10

AGENT LOGIN

The agent login form links to-

1. Basic agent information like contact details and address which will be shown in customer

insurance information window.

2. All the information related to insurances which he has made to his clients.

3. Option to create a new policy to any existing/new client.

4. Option to edit the contact information of its client.

CUSTOMER LOGIN:-

The form contains the agent information like-

1. Personal information required by insurance agency.2. Next premium due of respective insurances by the client along with maturity date,

agent info etc.

ADMINISTRATOR LOGIN:-

Administrator has rights to-

1. Create new agent

2. Edit agents information and its commission percentage.

3. Delete an agents database and all its policies respectively.

ABOUT US:-

It contains information about the organizations history and its achievements.

CONTACT US:-

It contains the contact details of the organizations various branches located in different parts of

a country.


11/55

11

REQUIRMENT ANALYSIS

Hardware Selection:

Processor PENTIUM IV

RAM 128 MB

Hard Disk 40 GB

Cache Memory 11,011,968 Bytes

Virtual Memory 32 MB

Display Card Super Video Graphics Adapter (SVGA)

Mouse Logitech Serial Mouse

Keyboard Standard 104 Enhanced Keyboard

Software Selection:

Web Server Apache Tomcat Server 7.0

Browser Google Chrome, Mozilla FireFox

Server side scripting JSP

Database MySQL

Language J2EE

Client side scripting HTML


12/55

12

MODULES

User Login Form :- User can enter the application by providing username and password

and Buy Police

User Registration Form:- User can register using Name, password, User name,

Gender, Date Of Birth Occupation, age, address, e-mail id, Office Address.

Policy Buyer Registration form:- New Policy Holder gives their

information like, Name, Documents, Gender, Date Of Birth Occupation, age,

address, e-mail id, Nominee

Payment Mode:- Policy buyer can buy the required policy by Different mode

of payment like self payment or payment trough agent.

Administrator :Administrator can add, View, modify, and delete the Policy detail.


13/55

13

INTRODUCTION TO TOOLS

FRONT END: Java Server Page (JSP)

LANGUAGES USED: HTML, Java Server Page (JSP) , Java Scripts (JS), JQuery

BACK END: MySQL

FRONT END

LANGUAGES USED

HTML:- It is used to generate web page. HTML, an initialism of Hypertext Markup

Language, is the predominant markup language forweb pages. It provides a means to

describe the structure of text-based information in a documentby denoting certain text

as headings, paragraphs, lists, and so on.

JSP :- JavaServer Pages (JSP) is a technology that helps software developers create

dynamically generated web pages based on HTML, XML, or other document types.

Released in 1999 by Sun Microsystems,[1] JSP is similar to PHP, but it uses the Java

programming language.

To deploy and run JavaServer Pages, a compatible web server with a servlet container,

such as Apache Tomcat or Jetty, is required.

JAVASCRIPT :It is used for checking User information before sending to JavaScript

is a scripting language most often used forclient-side web development. It is a dynamic,

weakly typed, prototype-based language with first-class functions. Currently,

"JavaScript" is an implementation of the ECMAScript standard

BACK END

My SQL is a relational database management system (RDBMS) which has more than 6

million installations. MySQL stands for "My Structured Query Language". The program

runs as a server providing multi-user access to a number of databases.

PLATFORM

APACHE TOMCAT:- - Apache is a web container, orapplication serverdeveloped at the

Apache Software Foundation (ASF).It adds tools for configuration and management but can

also be configured by editing configuration files that are normally XML-formatted. Apache

includes its own internal HTTP server.
http://en.wikipedia.org/wiki/Markup_languagehttp://en.wikipedia.org/wiki/Web_pagehttp://en.wikipedia.org/wiki/Scripting_languagehttp://en.wikipedia.org/wiki/Client-sidehttp://en.wikipedia.org/wiki/Dynamic_languagehttp://en.wikipedia.org/wiki/Weak_typinghttp://en.wikipedia.org/wiki/Prototype-based_programminghttp://en.wikipedia.org/wiki/First-class_functionhttp://en.wikipedia.org/wiki/ECMAScripthttp://en.wikipedia.org/wiki/Relational_database_management_systemhttp://en.wikipedia.org/wiki/Web_containerhttp://en.wikipedia.org/wiki/Application_serverhttp://en.wikipedia.org/wiki/Apache_Software_Foundationhttp://en.wikipedia.org/wiki/XMLhttp://en.wikipedia.org/wiki/Hypertext_Transfer_Protocolhttp://en.wikipedia.org/wiki/Hypertext_Transfer_Protocolhttp://en.wikipedia.org/wiki/XMLhttp://en.wikipedia.org/wiki/Apache_Software_Foundationhttp://en.wikipedia.org/wiki/Application_serverhttp://en.wikipedia.org/wiki/Web_containerhttp://en.wikipedia.org/wiki/Relational_database_management_systemhttp://en.wikipedia.org/wiki/ECMAScripthttp://en.wikipedia.org/wiki/First-class_functionhttp://en.wikipedia.org/wiki/Prototype-based_programminghttp://en.wikipedia.org/wiki/Weak_typinghttp://en.wikipedia.org/wiki/Dynamic_languagehttp://en.wikipedia.org/wiki/Client-sidehttp://en.wikipedia.org/wiki/Scripting_languagehttp://en.wikipedia.org/wiki/Web_pagehttp://en.wikipedia.org/wiki/Markup_language


14/55

14

WHY J2EE?

J2EE stands for Java 2 Platform Enterprise Edition. It is one of the most widely used platform-

independent Java-centric environments for developing and deploying enterprise-grade web

applications. A set of services, APIs and protocol make up the J2EE platform.

They provide facilities and functionalities to build multitier web applications.Java is a very useful language as it lets you build a cross-platform application that can

communicate with multiple devices. Codes can be developed on a desktop computer and runacross all Java enabled devices like computers, routers, mobile phones and others. Java is a

portable language and its main feature has made it one of the most successful programming

languages. SUN has given this feature an acronym WORA that represents the concept of "WriteOnce Run Anywhere".

Numerous computers, mobile phones, mainframe computers and even electronic devices are now

powered by the Java platforms and Java language.

J2EE is a variant of Java. J2EE development is a better option for enterprise applications. It istypically used for large scale applications. The reasons are quite clear:

- Heterogeneous environment - An organization uses a variety of servers, e.g. Windows, Linux,

Solaris, AS400, etc. J2EE has WORA capability that allows developers to reuse the codes across

enterprise.- Neutral selection of vendors- The basic function of J2EE is to provide generic interface for

developers and service providers. It enables organizations to choose hosting products without

thinking about their suitability. Integration of J2EE applicationsis also easy and quick.

- Productivity- Programmers can use J2EE APIs to reduce the time spent on coding as it has a

rich set of high quality APIs.

- Future-proofing - If you decide to go with J2EE, consider that you are securing the future of

your web application. In case anything new happens in the Java technology, SUN quickly offers

required support to the applications developed using J2EE.

Why should you go with J2EE application development?

J2EE is already popular among the community of developers. Quick support is available.

Any J2EE application development remains object-oriented to provide very fine modular

approach to applications.

There are many similarities among the syntaxes of Java, C and C++. It helps developers easily

understand Java programming. Development requires less time as well.

Java is the ideal language for developing securest web based applications.

Java is already in use as a enterprise-grade programming language.


15/55

15

J2EE History

Java Platform, Enterprise Edition or Java EE (formerly known as Java 2 Platform, Enterprise

Edition or J2EE up to version 1.5), is a programming platformpart of the Java Platformfor

developing and running distributed multitier architecture Java applications, based largely on

modular software components running on an application server. The Java EE platform is definedby a specification.

The year 2000 has seen Java 2, Enterprise Edition (J2EE) compliancy move out of the realm ofmarketing and into nine shipping products. J2EE vendor strategic positioning has continually

changed, from focusing on core products, to an integrated range of J2EE services, to J2EE

compliancy and finally to avoiding commoditization by leveraging J2EE servers as platforms for

WebServices, Wireless and EAI development.

The dominant players in the game have surfaced, but a variety of strategic takeovers may

reshape J2EE app. server market share for 2001. In short, the server side java industry has gone

through a whirl wind of change, this article will walk you through the years events and explainthe trends and the players that will change the server side java landscape in 2001.

The original J2EE specification was developed by Sun Microsystems.

Starting with J2EE 1.3, the specification was developed under the Java Community Process. JSR

58 specifies J2EE 1.3 and JSR 151 specifies the J2EE 1.4 specification.The J2EE 1.3 SDK was first released by Sun as a beta in April 2001. The J2EE 1.4 SDK beta

was released by Sun in December 2002.

The Java EE 5 specification was developed under JSR 244 and the final release was made onMay 11, 2006.

Java EE includes several API specifications, such as JDBC, RMI, e-mail, JMS, web services,XML, etc, and defines how to coordinate them. Java EE also features some specifications unique

to Java EE for components.These include Enterprise Java Beans, servlets, portlets (following the Java Portlet specification),

JavaServer Pages and several web service technologies. This allows the developer to create an

enterprise application that is portable between platforms and scalable, while integrating withlegacy technologies.

Other added bonuses are, for example, that the application server can handle the transactions,

security, scalability, concurrency and management of the components that are deployed to it,meaning that the developers can concentrate more on the business logic of the components rather

than the lower level maintenance tasks.


16/55

16

ABOUT JAVA SERVER PAGE(JSP)

JavaServer Pages (JSP) is a technology that helps software developers create dynamically

generated web pages based on HTML, XML, or other document types. Released in 1999 by Sun

Microsystems, JSP is similar to PHP, but it uses the Java programming language.

To deploy and run JavaServer Pages, a compatible web server with a servlet container, such as

Apache Tomcat or Jetty, is required.

JSP may be viewed as a high-level abstraction of Java servlets. JSPs are translated into servlets

at runtime; each JSP's servlet is cached and re-used until the original JSP is modified.

JSP can be used independently or as the view component of a server-side modelviewcontroller

design, normally with JavaBeans as the model and Java servlets (or a framework such as Apache

Struts) as the controller. This is a type of Model 2 architecture.

JSP allows Java code and certain pre-defined actions to be interleaved with static web markupcontent, with the resulting page being compiled and executed on the server to deliver a

document. The compiled pages, as well as any dependent Java libraries, use Java bytecode rather

than a native software format. Like any other Java program, they must be executed within a Java

virtual machine (JVM) that integrates with the server's host operating system to provide an

abstract platform-neutral environment.

JSPs are usually used to deliver HTML and XML documents, but through the use of

OutputStream, they can deliver other types of data as well.

The Web container creates JSP implicit objects like pageContext, servletContext, session,request & response

Compiler

A JavaServer Pages compiler is a program that parses JSPs, and transforms them into executable

Java Servlets. A program of this type is usually embedded into the application server and run

automatically the first time a JSP is accessed, but pages may also be precompiled for better

performance, or compiled as a part of the build process to test for errors.

Some JSP containers support configuring how often the container checks JSP file timestamps to

see whether the page has changed. Typically, this timestamp would be set to a short interval(perhaps seconds) during software development, and a longer interval (perhaps minutes, or even

never) for a deployed Web application.


17/55

17

Comparison with similar technologies

JSP pages are similar to PHP pages and ASP.NET Web Forms, in that all three add server-side

code to an HTML page. However, all three terms refer to a different component of the system.

JSP refers to the JSP pages, which can be used alone, with Java servlets, or with a framework

such as Apache Struts. PHP is itself a programming language, designed for dynamic Web

pages.[11] ASP.net is a framework comparable to Struts or JavaServer Faces that uses pages

called Web Forms.

While JSP pages use the Java language, ASP.NET pages can use any .NET-compatible language,usually C#.

ASP.NET is designed for a Microsoft Windows web server, while PHP and Java server

technologies (including JSP) are fairly operating system agnostic.


18/55

18

Caching to improve performance

The popularity of JavaServer Pages has meant that it is being used quite frequently in developing

high-traffic web apps. And, this is causing performance bottlenecks as you try to add more users

and transaction load on your JavaServer Pages application.

Although, JavaServer Pages application can scale very nicely to multiple web servers, the

database server cannot. The main reason for the database becoming a bottleneck is that while you

can add more and more servers to the JavaServer Pages application server farm, you cannot do

the same at the database tier.

This results in limited scalability at the data tier. You can remove these JavaServer Pages

Servlets performance bottlenecks by using a distributed cache for storing the frequently used

data.


19/55

19

MYSQL

MySQL is a relational database management system (RDBMS) which has more than 6 million

installations. MySQL stands for "My Structured Query Language". The program runs as a server

providing multi-user access to a number of databases.

The project's source code is available under terms of the GNU General Public License, as well as

under a variety ofproprietary agreements. MySQL is owned and sponsored by a single for-profit

firm, the Swedish company MySQL AB, now a subsidiary ofSun Microsystems, which holds

the copyright to most of the codebase.

MySQL is commonly used by free softwareprojects which require a full-featured database

management system, such as WordPress, phpBB and other software built on the LAMP software

stack. It is also used in very high-scale World Wide Webproducts including Google and

Facebook.

Uses:- MySQL is used in web applications and acts as the database component of the LAMP

software stack. Its popularity for use with web applications is closely tied to the popularity of

PHP, which is often combined with MySQL.

Several high-traffic web sites (including Flickr, Facebook, Wikipedia, Google (though not for

searches), Nokia, Auctionmarts and YouTube) use MySQL for data storage and logging of user

data.
http://en.wikipedia.org/wiki/Relational_database_management_systemhttp://en.wikipedia.org/wiki/Source_codehttp://en.wikipedia.org/wiki/GNU_General_Public_Licensehttp://en.wikipedia.org/wiki/Proprietary_softwarehttp://en.wikipedia.org/wiki/Businesshttp://en.wikipedia.org/wiki/Swedenhttp://en.wikipedia.org/wiki/MySQL_ABhttp://en.wikipedia.org/wiki/Subsidiaryhttp://en.wikipedia.org/wiki/Sun_Microsystemshttp://en.wikipedia.org/wiki/Free_softwarehttp://en.wikipedia.org/wiki/WordPresshttp://en.wikipedia.org/wiki/PhpBBhttp://en.wikipedia.org/wiki/LAMP_%28software_bundle%29http://en.wikipedia.org/wiki/World_Wide_Webhttp://en.wikipedia.org/wiki/Googlehttp://en.wikipedia.org/wiki/Facebookhttp://en.wikipedia.org/wiki/Web_applicationhttp://en.wikipedia.org/wiki/LAMP_%28software_bundle%29http://en.wikipedia.org/wiki/PHPhttp://en.wikipedia.org/wiki/Flickrhttp://en.wikipedia.org/wiki/Facebookhttp://en.wikipedia.org/wiki/Wikipediahttp://en.wikipedia.org/wiki/Googlehttp://en.wikipedia.org/wiki/Nokiahttp://en.wikipedia.org/wiki/YouTubehttp://en.wikipedia.org/wiki/YouTubehttp://en.wikipedia.org/wiki/Nokiahttp://en.wikipedia.org/wiki/Googlehttp://en.wikipedia.org/wiki/Wikipediahttp://en.wikipedia.org/wiki/Facebookhttp://en.wikipedia.org/wiki/Flickrhttp://en.wikipedia.org/wiki/PHPhttp://en.wikipedia.org/wiki/LAMP_%28software_bundle%29http://en.wikipedia.org/wiki/Web_applicationhttp://en.wikipedia.org/wiki/Facebookhttp://en.wikipedia.org/wiki/Googlehttp://en.wikipedia.org/wiki/World_Wide_Webhttp://en.wikipedia.org/wiki/LAMP_%28software_bundle%29http://en.wikipedia.org/wiki/PhpBBhttp://en.wikipedia.org/wiki/WordPresshttp://en.wikipedia.org/wiki/Free_softwarehttp://en.wikipedia.org/wiki/Sun_Microsystemshttp://en.wikipedia.org/wiki/Subsidiaryhttp://en.wikipedia.org/wiki/MySQL_ABhttp://en.wikipedia.org/wiki/Swedenhttp://en.wikipedia.org/wiki/Businesshttp://en.wikipedia.org/wiki/Proprietary_softwarehttp://en.wikipedia.org/wiki/GNU_General_Public_Licensehttp://en.wikipedia.org/wiki/Source_codehttp://en.wikipedia.org/wiki/Relational_database_management_system


20/55

20

REQUIREMENT ANALYSIS

Goal of Thesis

The goal of our thesis is to develop a website that can be used as an enrollment website with the

features of interaction and problem solving. The whole project will be based on JSP with

MYSQL as the database with certain security constraints added to it.

Our aim is also to implement the Administrator part in to the project so that the server or

administrator himself can view, add, delete and modify.

A. Administrator

He has to see whether the website is working properly and whether the details available in the

system are relevant and correct. He can view, add, modify, delete details.

B. Database

The database keeps all the records of all the users i.e. name,course, phone no.,dob, city,

country,etc. For creating such records it takes the help of tables which is created in the MYSQL.

The tables can have infinite entries of all the registered users as well as administrators.

C. Clients

Our aim will also to provide efficient way by which client can enter to see his profile, ask

questions to his teacher and download softwares.

D. Security Constraints

There need to be certain constraints which have to be implemented on the database as well as on

the administrator in order to work properly the whole system, such as declaring the primary key,

or such constraints in order to keep the database work properly.

Some of such constraints are as follows:

1. Each user has a field called username which can be used to differentiate between different

users.

2. The administrator has his own password known to no one else to access a unique page.

3. Only the administrator has the right to delete, modify users and questions.


21/55

21

4. Administrator has to first login to get access to myaccount part and modify some data

available in the website.

5. A new user cannot have same username and password as of some already registered user.

6.When user or administrator click on logout the session of the user ends and he has to again

login using his/her username and password to access the same functionality.

7. Checks are implemented so that the mandatory fields are filled by users when the user is

entering some information in the system.

8. Latest firewalls and other antivirus and anti hacking modules are to be used with the website

so as to protect the website from external attacks.

SYSTEM ANALYSIS

The Analysis model:

The analysis model must achieve three primary objectives:

To describe what the customer requires.

To establish the basis for the enhancement of a software design.

To define a set of requirements that can be validated once the software is completely

enhanced. The main elements of the analysis model are briefly described below.

At the core of the model lies the data dictionary, which is a repository that contains

descriptions of all the data objects consumed or produced by the software .Three different

diagrams surround the core.

The entity relation diagram depicts relationships between data objects.

The data flow diagram provides an indication of how the data is transformed as they

move through the system.

The state transition diagram indicates how the system behaves as a consequence ofexternal events.


22/55

22

DESIGN PHASE

HOME SCREEN:

Home page gives user the initial view of the website of insurance management system. Itcontains menu bar where user can redirect to the related tab. It have a sidebar from where he can

login and register to the site.


23/55

23

REGISTERATION SCREEN:

From this page new user can register in the site. User have to give al the information asked in the

form.


24/55

24

POLICY BUYERS SCREEN:

In this page user can buy a new policy and become a policy holder.


25/55

25

LOGIN SCREEN:

In this page a existing user/Agent can login using its distinct user name and password. to view

his profile he has entered while filling the registration formed.


26/55

26

SOURCE CODE OF REGISTRATION PAGE:

Insurance theme

Assurity Of Life

Ab Zindagi Muthi Mein

Toll Free: 9530760965, 9915844814, 9814548197

Home

About UsCustomer Services

Our Plans

Media CenterContact Us

Register

Login

Life Insurance


27/55

27

Health Insurance

Vehicle Insurance

Why you need Insurance

Downloads

Premium Calculator

Premium Claim

Track Your Application

Branch Locator


28/55

28

Mother's Name

Father's Name

GenderMale

Female

Marital Status

MarriedUnmarried

Correspondence Address

City

State

Chandigarh

New DelhiBangalore

Pune


29/55

29

Permanent Address

City

State

ChandigarhNew Delhi

Bangalore

Pune

Username

Email Address

Occupation

Office Address


30/55

30

Password

Confirm Password

Connection c;Statement s;

ResultSet rs;

try{class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

c=DriverManager.getconnection("jdbc:odbc:test");

s=c.CreateStatement();

String firstnames = request.getParameter("firstname");String lastnames = request.getParameter("lasname");

String mothernames = request.getParameter("mothername");

String fathernames = request.getParameter(fathersName");String gender= request.getparameter("sex");

String married=request.getparameter("maritalstatus")

String c_add = request.getParameter("cor_add");String c_city = request.getParameter("c-add-city");

String c_state = request.getParameter("c_state");

String p_add = request.getParameter("p_add");

String p_city = request.getParameter("p-add-city");String p_state = request.getParameter("p-state");

String email = request.getParameter("email");

String occupation = request.getParameter("occupation");

String off_add = request.getParameter("o-address");String password = request.getparamter("password");

String confirm_passwor = request.getParameter("confirmpassword");

String urname = request.getparamter("urname");


31/55

31

stmt="Insert into Registration

values("'firstnames'","'lastnames'","'mothernames'","'fathernames'","'gender'","'married'","'c_add'

","'c_city'","'c_state'","'p_add'","'p_city'","'p_state'","'urname'","'email'","'occupation'","'off_add'","'password'","'confirm_password'")";

rs=s.executeQuery(stmt);

response.sendRedirect("policy-register.jsp");%>

Privacy & PolicyRTI

Disclaimer

Site MapContact Us

Copyright 2013Assurity:A Company Who Cares For You And YourFamily| Designed by Sushant

Sinha


32/55

32

SOURCE CODE OF LOGIN PAGE:

Insurance theme

div.content-login{

float:right;width:800px;

}

div.main-content-login{

width:800px;

float:right;height:500px;

background-color:#B2CCFF;

}

div.main-content-login td h1{

font-size:100%;

font-family:"Times New Roman",Times,serif;color:#000033;

}

div.customer_login

{width:400px;

float:left;

}div.customer_login h3

{

color:#000033;font-size:20px;

}

div.cgent_login{

width:400px;

float:right;

}div.agent_login h3

{

color:#000033;font-size:20px;


33/55

33

}

Assurity Of Life

Ab Zindagi Muthi MeinToll Free: 9530760965, 9915844814, 9814548197

Home

About Us

Customer ServicesOur Plans

Media Center

Contact Us

Register

Login

Life Insurance


34/55

34

Health Insurance

Vehicle Insurance

Why you need Insurance

Downloads

Premium Calculator

Premium Claim

Track Your Application

Branch Locator


35/55

35

Customer Login

USER NAME:

PASSSWORD:

Connection c;

Statement s;

ResultSet rs;

try{class.class.forName("sun.jdbc.odbc.JdbcOdbcDriver");


s=c.CreateStatement();String stmt;

stmt=select * from customer_login where username="request.getparameter("username")+"and

password='"+request.getparameter("c_password")+"'";rs=s.executeQuery(stmt);

while(rs.next())

flag=1;

if(flag==1)response.sendRedirect("customer_profile.jsp");

else

response.sendRedirect("login.jsp");

%>


36/55

36

Agent LoginAGENT NAME:

PASSSWORD:

Connection c;

Statement s;ResultSet rs;

int flag=0;try{

class.class.forName("sun.jdbc.odbc.JdbcOdbcDriver");


s=c.CreateStatement();String stmt;

stmt=select * from agent_login where username="request.getparameter("agentname")+"and

password='"+request.getparameter("a_password")+"'";

rs=s.executeQuery(stmt);

while(rs.next())

flag=1;if(flag==1)


37/55

37

response.sendRedirect("agent_profile.jsp");

else

response.sendRedirect("login.jsp");%>

Privacy & Policy

RTI

DisclaimerSite Map

Contact Us

Copyright 2013Your Company Name| Designed by Sushant Sinha


38/55

38

SOURCE CODE OF POLICY BUYERS PAGE:

Insurance theme

div.content-policy{

width:1200px;

background-color:#B2CCFF;

}div.main-content-policy

{

font-size:10px;font-family:"Times New Roman",Times,serif;

color:#000033;

}

Assurity Of Life

Ab Zindagi Muthi MeinToll Free: 9530760965, 9915844814, 9814548197

HomeAbout Us

Customer Services

Our PlansMedia Center


39/55

39

Contact Us

Plan

plan A

plan B

plan Cplan D

Policy Holder's Name:

Nominee 1


40/55

40

Nominee 2

Relation between Policy Holder And Nominee1:

Relation between Policy Holder And Nominee2:

Sum Assured:

Date of Birth

Age

Policy Duration


41/55

41

Primium Paying Term

Premium Paying Type

Yearly

Half-yearlyQuaterly

Monthly

Connection c;

Statement s;

ResultSet rs;

try{class.forName("sun.jdbc.odbc.JdbcOdbcDriver");


s=c.CreateStatement();

String policy = request.getparameter("policy for");

String plan = request.getparameter("PLAN");

String poly_holder = request.getparameter("POLICY HOLDER'S NAME");String nominee1 = request.getparameter("NOMINEE 1");


42/55

42

String nominee2 = request.getparameter("NOMINEE 2");

String relation1 = request.getparameter("RELATION1");String relation2 = request.getparameter("RELATION2");

String sum_assured = request.getparameter("sum assured");

String dob = request.getparameter("DOB");String age = request.getparameter("age");String poly_duration = request.getparameter("poly_duration");

String pay_term = request.getparameter("pay_term");

String pay_type = request.getparameter("pay_Type");

stmnt="insert into policy_register

values("'policy'","'plan'","'poly_holder'","'nominee1'","'nominee2'","'relation1'","'relation2'","'su

m_assured'","'dob'","'age'","'poly_duration'","'pay_term'","'pay_type'")"rs=s.exectutQuery("stmnt");

response.sendRedirect("payment-mode.jsp");

%>


43/55

43

DATA BASE:

Data Flow Diagram:

Data flow diagram of the database used in this project.

Online Insurance

Admin Policy Agent Policy Holder

View Own

Policy Details

Policy Agent Policy Holder

Add / Modify / Delete and View

Operation

View Own

/Client Details

Data

Base


44/55

44

ER DIAGRAM


45/55

45

ER DIAGRAM OF ADMIN:

ER DIAGRAM OF MANEGER:


46/55

46

ER DIAGRAM OF AGENT:

ER DIAGRAM OF COUSTOMER:


47/55

47

DATABASE DESIGN

CUSTOMER_LOGIN TABLE:This table maintains member login details for users.

AGENT LOGIN TABLE:This table maintains member login details for users.

REGISTRATION TABLE:This table maintains details of registration of users.

FIELD NAME DATA TYPE CONSTRAINTUser_name Varchar Primary key Not null

C_password Varchar Not Null

FIELD NAME DATA TYPE CONSTRAINTagentname Varchar Primary key Not nulla_password Varchar Not Null

FIELD NAME DATA TYPE CONSTRAINT

Firstname Varchar Not Null

Lastname Varchar Not Null

Fathername Varchar Not NullMothername Varchar Not Null

Gender Varchar Not Null

Maritalstatus Varchar Not Null

Cor_add Varchar Not Null

Cor_city Varchar Not Null

Cor_state Varchar Not Null

Per_add Varchar Not Null

Per_city Varchar Not Null

Per_state Varchar Not Null

Username Varchar Primary Key

Email Varchar Not Null

Occupation Varchar Not Null

Off_add Varchar Not Null

Password Varchar Not Null


48/55

48

POLICY DETAIL TABLE:This table maintain the history of policies of users


Policy_for Varchar Not Null

Plan Varchar Not Null

Policy_holder_name Varchar Not Null

Nominee1 Varchar Not Null

Nominee2 Varchar Not Null

Relation_nominee1 Varchar Not Null

Relation_nominee2 Varchar Not Null

Sum_assured Integer Not Null

P_dob date Not Null

Age Integer Not Null

Policy_dur Integer Not NullPremium_term Integer Not Null

Premium_type Varchar Not Null

ADMIN TABLE: This table maintains the record of all the administrators


User_id Varchar Primary Key

User_name Varchar Not Null

Address Varchar Not Null

Contact Integer Not Null

Password Varchar Not Null


49/55

49

POLICY PROFILE TABLE:This table maintain the history of policies of users

WITHDRAWL TABLE :This table maintain the maturation of policies all the users

LIST TABLE : This table maintain the list of policies of users.

FIELD NAME DATATYPE CONSTRAINT

User_id Varchar Foreign key

Date from Date Not NullDate to Date Not Null

Type_insurance_policy Varchar Not Null

Total_amount Varchar Not Null

Current_balance Varchar Not Null

Remaining_balance Varchar Not Null

Policy_for Varchar Not Null

FIELD NAME DATATYPE CONSTRAINT

User_id Varchar Foreign Key

After_mature Integer NOT NULL

Discontinue_policy Integer NOT NULL

Policy_id Varchar Primary Key


User_name Varchar Foreign key

User_policy Varchar Not Null


50/55

50

NOMINEE TABLE:This table maintains the details of the nominees.


User_name Varchar Not Null

Nominee_name Varchar Not NullAddress Varchar Not Null

Contacts Integer Not Null

Relation_holdername Varchar Not Null


51/55

51

CONCLUSIONS

I have successfully implemented the site Online Insurance Manegment System.

With the help of various links and tools, we have been able to provide a site which

is live and running on the web.

We have been successful in our attempt to take care of the needs of both the

customers as well as the administrator. Finally we hope that this will go a long way

in popularizing the organization and making .

The system can be used to make better management described at appropriate time.

The user gets amount and timely information system.


52/55

52

BIBLIOGRAPHY

1) www.google.com

2) www.w3cschools.com

3) www.wikipedia.com

4) www.tutorialspoint.com/jsp

5) www.jsptut.com

6) www.javatpoint.com/jsp


53/55

53


54/55

54


55/55