INSURANCE MANGEMENT SYSTEM [14-10-2019]

Kamala Education Society’s

Pratibha College of Commerce & Computer Studies, Chinchwad, Pune-19

A
Project Report
On
“INSURANCE MANAGEMENT SYSTEM”

Developed by,
37040 : Sachin Jadhav
37043 : Jefin Daniel

T.Y.B.B.A.(C.A.)
Under
Savitribai Phule Pune University
(2019-2020)
Kamala Education Society’s

1
INSURANCE MANGEMENT SYSTEM [14-10-2019]

Pratibha College of Commerce & Computer Studies, Chinchwad, Pune-19

Certificate
This is to certify that Student Name has/ have satisfactorily
completed the Visual Basic Project titled “Project Name” for
T.Y.B.B.A.(C.A.) under the Savitribai Phule Pune University in the
academic year 2019-2020.

____________________ ___________________ ____________________

Prof. Guide Name Prof. Hemalata Chavan Dr. Babasaheb Sangale
Project Guide Head of Department Principal

__________________ _________________
Internal Examiner External Examiner

Date:

ACKNOWLEDGEMENT
2
INSURANCE MANGEMENT SYSTEM [14-10-2019]

Any effort to produce successful creation requires the help,

guidance and support of many people and their experience. We
would like to express our sincere and heartfelt gratitude to all of
them.
We would like to take this opportunity to thanks all the people
who have directly or indirectly helped this project. We would
like to thank our guide Prof. Hemalata Chavan for her valuable
guidance.

- Sachin Jadhav

- Jefin Daniel

Table of Content
Sr. No. Contents Page No.
3
INSURANCE MANGEMENT SYSTEM [14-10-2019]

1 Introduction
2 Problem Definition
3 Need for System
4 Scope of Proposed System
5 Feasibility Study & Fact Finding Technique
6 Hardware and Software Requirement
7 Design Specification
7.1 Data Flow Diagram
7.2 ER Diagram
8 Data Dictionary
9 Table Design
10 Sample Input & Output Screen
11 Testing Strategy
12 Limitations
13 Future Enhancement
14 Conclusion
15 Bibliography
1. INTRODUCTION

This software is developed to help the Insurance organization to

automize the daily working. This software is about the details about
insurance agent, policy holders and the management. So this will be
developed for managing the Insurance management system, Total work
4
INSURANCE MANGEMENT SYSTEM [14-10-2019]

is done by various modules which will save time and reduce paperwork.
And it will also saves human efforts.
Main advantage of this software is it stores and tracks all insurance
details. If the customer want any details about his Insurance, then the
agent of the insurance company can provide complete details about
insurance. ie, Policy premium, renewal, nominee details, claiming
process etc.
Software is the major system which has got now computerized. In the
big cities number of employees are handled. As the existing system is
manual.
The system will help the people to maintain their reward in proper
manner. This system will also helpful for all insurance system to
maintain their record.
It will help to reduce time and manpower
There are four modules:-
1) New Policy
2) Payment
3) Agent
4) Customer

2. PROBLEM DEFINITION

The Proposed system is for making easier to managed policy holder

details etc. So this will be developed for managing the Insurance
Management System.

5
INSURANCE MANGEMENT SYSTEM [14-10-2019]

In existing system procedure is followed where the records are used

to maintain data which is a time taking procedure and require more
manpower and calculating commission, dues, etc. are done manually.

3. NEED OF THE SYSTEM

We know today we are living in a techno savvy world and everything is

now systematic. System is the one if the major system which has got
computerized. In the big city the number of employees are handled. As
the existing system is manual. It has some drawbacks such as time

6
INSURANCE MANGEMENT SYSTEM [14-10-2019]

consuming, less accuracy, possibility of quick access etc. To overcome

the drawbacks computerization is very essential.
Advantages of computerized system are:-
1) Speed
2) Accuracy
3) Large storage capacity

4. SCOPE OF THE SYSTEM

This system will help people to maintain their records in proper manner.
This system is helpful for all Insurance system to maintain their staff,
agent, management etc. in a proper way
It will reduce time and manpower.
7
INSURANCE MANGEMENT SYSTEM [14-10-2019]

5. FEASIBILITY STUDY AND FACT FINDING

TECHNIQUE

5.1 Feasibility Study:

Technical Feasibility :-
In Technical Feasibility of function, performance and constraints that
many affect the ability to achieve an acceptable system are considered

8
INSURANCE MANGEMENT SYSTEM [14-10-2019]

Technical Feasibility centers around existing computerized system and

what extends it can support the proposed system. In the proposed system
if networking in required then it will support the system. To improve the
effective and effectiveness the organization may adopt the new
technology will be applied in the proposed system.

Economical Feasibility:-
Economical Feasibility is the most frequently used method of evaluation
of effectiveness of a proposed system. Cost benefits and saving are
determined from proposed system and compared with the cost.
The different types of considers are;

Manpower cost
Hardware cost
Operating cost
1. Manpower cost
My proposed system can be communicated with the department in the current
system so the single person can handle the work of overall system. No extra
manpower is required.

2. Hardware cost
As the detail provided by selection of hardware and software requirement we have
provided the minimum requirement to handle the system. It will not much more
cost as per our manual system.

3. Operating systems

9
INSURANCE MANGEMENT SYSTEM [14-10-2019]

Commonly we not require much more training to train the operator to the computer
the current system. So obviously it will reduce the operational cost in the form of
training. Within a few period time a normal user can himself strained in the system.

5.2 FACT FINDING TECHNIQUE

1. Observation:

This method is mostly use to visits the organization and observes and
understandable the flow of the documents, working of the existing system,
the users of the system etc. For developing the system we visited some of
the insurance offices and agents .We observed their working procedure in
office and from that we tried to develop our project which is helpful for
Insurance office for their day-to day work.

2. Record view:

10
INSURANCE MANGEMENT SYSTEM [14-10-2019]

We read some information related to system which is published in the

sources like newspaper, documents, etc. This record view helps to get
valuable information about system.

3. Interview:

This method is used to collect the information that groups or individuals. We

selected some people who are related with system for the interview like
Policy agents etc. From this method we got a help to discuss the problem for
future purposes.

6. HARDWARE AND SOFTWARE REQUIREMENT

Hardware Requirements:

Processor Intel core i3-4005U CPU @ 1.70GHZ

11
INSURANCE MANGEMENT SYSTEM [14-10-2019]

RAM 256MB or more

Hard disk 20 GB or above

Software Requirements:

Operating System Windows 8.1

Front End Visual Basic 6.0
Back End MS access 2010

7. DESIGN SPECIFICATION:

7.1 Data Flow Diagram

 7.1.1 Context Level Diagram:

0.0

CUSTOMER INSURANCE
12 CUSTOMER
MANAGEMENT
SYSTEM
INSURANCE MANGEMENT SYSTEM [14-10-2019]

POLICY POLICY

AGENT AGENT

POLICY HOLDER POLICY HOLDER

 7.1.2 First level Diagram

Pay amount Customer info

CUSTOMER POLICY
INSURANCE
MANAGEMENT
Personal info
SYSTEM
13
INSURANCE MANGEMENT SYSTEM [14-10-2019]

Premium Type
PREMIUM

Policy name

AGENT Personal info Bonus rate

MATURITY

7.2 Entity Relationship Diagram

Agent key

Name Phone

Address AGENT PWD

1
P Holder
Policy key
key key SALE

Commission Agent key

14
INSURANCE MANGEMENT SYSTEM [14-10-2019]

M
Type POLICY Policy key

Policy key
M

Time period
Amoun
t
Insured by
Name Claimed by

Name Name

Age
1 1
POLICY HOLDER CUSTOMER Age

Chooses
DOB
DOB
Address

Phone
Address
Phone

8. DATA DICTIONARY

Sr. No Field Name Data type Table name Description

1. Cust_No Number(5) Customer Customer Number

2. Cust_Name Text(10) Customer Customer Name

3. Address Text(10) Customer Customer Address

4. Contact Number(10) Customer Customer contact no

5. DOB Date/Time Customer Customer date of birth

6. Age Number(2) Customer Customer age

7. Gender Text(10) Customer Customer gender

8. City Text(10) Customer Customer city

9. Cust_No Number(2) Customer Policy Customer Number

10. Cust_Name Text(10) Customer Policy Customer Name

15
INSURANCE MANGEMENT SYSTEM [14-10-2019]

11. Policy_Name Text(10) Customer Policy Policy Name

12. P_Duration Number(5) Customer Policy Policy Duration

13. Payment Text(10) Customer Policy Policy Payment

14. P_Date Date/Time Customer Policy Policy Date

15. Amount Number(5) Customer Policy Policy Amount

16. Nominee1 Text(10) Customer Policy Nominee1

17. Nominee2 Text(10) Customer Policy Nominee2

18. Policy Benefit Text(10) Customer Policy Policy Benefit

19. Agent _No Number(5) Agent Agent Number

20. Agent_Name Text(10) Agent Agent Name

21. Address Text(10) Agent Agent Address

22. Phone_no Number(10) Agent Agent Phone_no

23. Gender Text(10) Agent Agent Gender

24. Date_of_Birth Date/Time Agent Date of Birth

25. Policy_No Number(5) Policy Policy Number

26. Policy_Name Text(10) Policy Policy Name

27. Policy_Duration Number(2) Policy Policy Duration

28. Bonus_rate Number(10) Policy Bonus Rate

29. Monthly Number(10) Policy Monthly payment mode

30. Quaterly Number(10) Policy Quaterly payment

31. Half Yearly Number(10) Policy Half Yearly payment

32. Yealy Number(10) Policy Yealy payment

33. P_no Number(5) Closure Payment Policy Number

34. P_Name Text(10) Closure Payment Policy Name

35. P_Date Date/Time Closure Payment Policy Date

36. P_amount Number(10) Closure Payment Policy amount

37. Bonus_rate Number(10) Closure Payment Bonus Rate

16
INSURANCE MANGEMENT SYSTEM [14-10-2019]

38. Bonus_amount Number(10) Closure Payment Bonus Amount

39. Maturity_amount Number(10) Closure Payment Maturity Amount

40. Maturity_date Date/Time Closure Payment Maturity Date

41. P_no Number(5) Initial Payment Policy Number

42. P_Name Text(10) Initial Payment Policy Name

43. P_Date Date/Time Initial Payment Policy Date

44. P_amount Number(5) Initial Payment Policy amount

45. P_no Number(3) Installment Payment Policy Number

46. P_Name Text(10) Installment Payment Policy Name

47. P_Date Date/Time Installment Payment Policy Date

48. P_duration Number(5) Installment Payment Policy Duration

9. TABLE DESIGN

 9.1 Customer Table

Description:- To store personal information of a customer.

Sr. No Field Name Data Type Size Constraints

1. Cust_No Number 5 Primary Key

2. Cust_Name Text 10 Not Null

3. Address Text 25 Not Null

4. Contact Number 10 Required

5. DOB Date/Time - Not Null

6. Age Number 2 Not Null

7. Gender Text 6 Customer Gender

8. City Text 10 Customer City

 9.2 Customer Policy Table

Description:- To store personal information taken by Customer
17
INSURANCE MANGEMENT SYSTEM [14-10-2019]

Sr. No Field Name Data Type Size Constraints

1. Cust_No Number 2 Primary Key

2. Cust_Name Text 20 Not Null

3. Policy_Name Text 20 Not Null

4. P_Duration Number 5 Not Null

5. Payment Text 10 Not Null

6. P_Date Date/Time - Not Null

7. Amount Number 10 Not Null

8. Nominee1 Text 10 Null

9. Nominee2 Text 10 Not Null

10. Policy Benefit Text 10 Null

 9.3 Agent Table

Description:- To store details of Agent

Sr. No Field Name Data Type Size Constraints

1. Agent _No Number 5 Primary Key

2. Agent_Name Text 10 Not Null

3. Address Text 25 Not Null

4. Phone_no Number 10 Not Null

5. Gender Text 5 Not Null

6. Date_of_Birth Date/Time - Null

 9.4 Policy Table

Description:- To store details of current policy

Sr. No Field Name Data Type Size Constraints

1. Policy_No Number 3 Primary Key

2. Policy_Name Text 20 Not Null

18
INSURANCE MANGEMENT SYSTEM [14-10-2019]

3. Policy_Duration Number 5 Not Null

4. Bonus_rate Number 3 Not Null

5. Monthly Number 10 Not Null

6. Quaterly Number 10 Not Null

7. Half Yearly Number 10 Not Null

8. Yealy Number 10 Not Null

 9.5 Closure Payment

Description:- To store details about maturity Paid by customer

Sr. No Field Name Data Type Size Constraints

1. P_no Number 3 Primary Key

2. P_Name Text 20 Not Null

3. P_Date Date/Time Not Null

4. P_amount Number 3 Not Null

5. Bonus_rate Number 5 Not Null

6. Bonus_amount Number 10 Not Null

7. Maturity_amount Number 10 Not Null

8. Maturity_date Date/Time Not Null

19
INSURANCE MANGEMENT SYSTEM [14-10-2019]

 9.6 Initial Payment

Description:- To store payment details

Sr. No Field Name Data Type Size Constraints

1. P_no Number 3 Primary Key
2. P_Name Text 20 Not Null
3. P_Date Date/Time - Not Null
4. P_Amount Number 10 Not Null

 9.7 Installment Payment

Description :- To store premium details

Sr. No Field Name Data Type Size Constraints

1. P_no Number 3 Primary Key
2. P_Name Text 20 Not Null
3. P_Date Date/Time - Not Null
4. P_Duration Number 10 Not Null
5. P_Type Text 10 Not Null
6. P_Amount Number 10 Not Null

20
INSURANCE MANGEMENT SYSTEM [14-10-2019]

11. TESTING STRATEGY

1) Black Box Testing

In Black box testing, the structure of the program is not considered test cases
are decided individually on the basis of requirement or specification of the
program and the internal of the program is not considered. We have used black box
testing in which have tested our system individually on the basis of requirement.

2) White Box Testing

White Box Testing where the test cases are based on the actual code of the
program. This testing tells the programmic logic and data structure used in the
program. White box testing focuses specially on the internal knowledge of the
software. White box testing is totally based on the programming knowledge.

We have used white box testing where we have tested our systems programming
logic. We have tested our system for all if structures used on each form.

4) Unit Testing

Unit testing focuses on the smallest unit of the software design. Unit testing
uses the white box testing method and concentrate on testing individual
programming unit.

21
INSURANCE MANGEMENT SYSTEM [14-10-2019]

12. LIMITATIONS

1) In these we are not maintaining a separate record of each policy.

2) In these we are not giving any additional benefit for customer.

3) Payment is not done by credit card or any other card payments.

4) For the heart patients, cancer patients we are not giving policy

5) Diseases like kidney stone, piles, appendix for this we have 2 year
waiting period

6) We are not giving treatments for Pregnancy, AIDS or HIV

13. FUTURE ENHANCEMENT

22
INSURANCE MANGEMENT SYSTEM [14-10-2019]

1) In Future we can do payments via cards.

2) We can give additional benefit in policy

3) We can increase policy premium amount to customers who are having more
than two years

4) We can include less policy amount for age 50 to 60 yrs

5) We can add children(currently having no child members) of the family

policy in renewal of policy

6) We can include more treatments and medicine claim for senior citizens

7) We will Include Health card (smart card) to all our customers

14. CONCLUSION

The project “Insurance Management System” is for computerizing the

work done in Insurance office. The software takes care of the
23
INSURANCE MANGEMENT SYSTEM [14-10-2019]

requirements of Insurance offices and are capable to provide easy and

effective storage of information related to customer and policy that
comes in policy agent.
It can generate monthly report, quarterly report, half yearly or yearly
report and that based on customer requirement.
Thus system is a great improvement over the manual system. The
computerization of a system has speed up the process

15. BIBLIOGRAPHY

Reference Books:
1) The complete Reference VISUAL BASIC 6.0 - Noel Jerke.
24
INSURANCE MANGEMENT SYSTEM [14-10-2019]

2) Visual Basic 6.0 Black Book – Steven Holzner.

3) Mastering in VB 6.0 – Evangelos Petroutsos.

25