Insurance Agency Management System Project
Insurance Agency Management System Project

Insurance Agency Management System Project

In today’s world life is full of risks so everyone wants to make himself secure, everyone wants to keep them on the safe side policy plays a vital role and provides them insurance about their money security, health security, accidental security, etc. This system has been proposed to maintain the record of the policyholder, agent details, policy detail, payment details.

So, this will be developed to manage the insurance of the clients and their relative records.

You can also check these posts:

The main menu will contain six parts which are as follow:

  • Client Login
  • Admin login
  • Agent Login
  • Policy Scheme
  • About us
  • Contact us

Now, we can see that nearly everything is very much possible to perform with a single click so this system will help you to computerize the system so that users and clients can access the system online.

These are some key features of the system which is as follow:

  • To reduce the data redundancy.
  • To reduce the cumbersome job of maintaining several documents.
  • It will eliminate the delays in the generation of reports.
  • Searching will become more efficient and faster.
  • It will also provide assurance to policyholders about their data privacy.
  • Overall, it will reduce the cost and time of the client as well as the admin.

Existing System Description

In this section, we will discuss the existing system and some of its drawbacks which force us to plan this whole idea of developing online insurance policy management.

Let us takes the few examples:

Vehicle Insurance

Initially, the customer visits the agent asked him to ensure his vehicle, at the request of the customer. The agent will take all the information regarding the client and vehicle afterward agent forward this information to the Company and get different quotation insurance coverages.

Then the agent will show all the quotation to the Client and ask him to choose one which he can afford, and to make payment then this payment will be sent to the company by the agent and request for the selected policy then company official will check the vehicle condition to ensure that whether the vehicle is in good condition or not so that they can decide to issue the policy.

After that company will issue the insurance form and commission to the agent which has decided by the company.

Drawbacks of This System

  • This process is so time-consuming.
  • There is a threat to the record of the client.
  • There is no proper way of getting new quotations from the agents there might be a possibility that they provide you old quotations.
  • It might be the case that the agent can take a commission as well as extra charges of transport from the client.

So, above this is the whole process of getting vehicle insurance by our system we can make it a little bit simpler and the fast process of automating it. We can automate this process by creating an application that will allow you to use these things in a fully functional way and the application will include the following entities (an entity is a real-world object).

The automated application help in following way:

  • The client can register himself directly on the application and generate a client id.
  • If the client is not aware of policies, then the agent will make him contact with this application and help him to complete the process.
  • Admin will maintain the record and security by using the encryption in saved records so that no one can access them.
  • The client needs not to bother about his/her data and without moving from his place or making so many phone calls he can get the policy.
  • No need for transportation to get policies.
  • The client can check new policies which have been uploaded by the Admin.
  • The whole process of getting work done will become faster than the conventional way of getting insurance.

Admin of Insurance Agency Management System

Admin will use this application to give access to the selected agents, even admin will add new policies so that agents can share the information with the clients or they can access it by themselves. Admin will provide a form and quotation to the user and client so that they can use it appropriately.

Agent of Insurance Agency Management System

The agent will make the clients know about the policies which have added by Admin, here agent can also send the form to the client so that he/she can fill in their necessary information like Name, Gender, Occupation, and the type of insurance he/she desires, for example, vehicle insurance, Health Insurance, etc.

The agent will also ask for the salary of the client so that Admin can decide related policies for a client, and a later agent will submit the form and a record will be created by him and Agent ID with client ID will start to reflect the Admin.

Client of Insurance Agency Management System

The client will get the most benefit from this application as we mentioned the advantages of this application user can log in and create his account to get the access of the application and maintain his record at the application so that agent and Admin can easily access it and provide his insurance according to his need and what he can afford, no need of moving here and there with an agent just a click will start your insurance process as well as end in the same way.

You just need to reply and stay in touch with the agent or admin to solve your queries. Now the best way to describe this whole process is an ER diagram which includes the entities and relations with different entities whereas their attributes so, we will design the ER diagram according to the description.

ERD of Insurance Agency Management System

Now we will discuss the whole ER-diagram to make better understanding.

Here we have different Entities such as Agent, Policy, Policy Holder, Claimer let looks one by one which is as follow:

Entity one Agent

This entity will interact with the users to provide them different facilities such as inform them about the new schemes and provide or notify them with a suitable quotation that will suit them.

Following are the few attributes which is possessed by the Agent entity they are:

  • Agent-ID: This is a unique id that will act as a primary key into the table and the client as well as Admin will locate the agent by this unique identity.
  • Name: This attribute will store the name of the Agent so if anyone wants to get the information they can easily search or directly access the database.
  • Password: This part will contain the password which allows the user to maintain the security in the application, this feature will help to get Authorize and Authenticate.
  • Phone: This field will help you to get in contact with the agent and the agent can also update his number whenever want, changes will also reflect in the application.
  • Address: Suppose if there is any confusion that takes place between the client and agent which they were not able to solve on phone then the client will move to the agent’s address to clear his confusion regarding any issue.

Entity Two Policy

This entity will interact with the agent and the relationship will be like the agent sell the policy.

Following are the few attributes which are possessed by the Agent entity they are:

Policy-key: This attribute will help you to find the unique policy as all the policies will differ by their uniquely identifying key.

Type: This field will help you to know what kind of policy you are interested in such as health insurance, vehicle Insurance, Life insurance.

Time-Period: This attribute will help you in know about the installment and return policy of the insurance you are interested in also about the time period you need to be involved in a particular policy.

Entity Three Policy Holder

This entity will connect to the policy entity as the policyholder holds the policy and get any one of their choices.

Following are the few attributes which are possessed by the Agent entity they are:

PH-key: This attribute will contain the unique identity of the user so that we can identify the user who has taken the policy and served them according to their need, so this feature is very important to get the information about the policyholder because the name attribute can be same for many clients but their ID will differ.

Name: This attribute will provide the name of the policyholder, this field help in maintaining the quality record of the policyholder. That whenever we need to mention the name of the policyholder, we can match it with the unique id of the policyholder so that we can get the correct name and use it for better understanding and services for the clients.

Address: This attribute helps you in getting the full information about the policyholder his current address and permanent address so that if there is any case of forgery notice in the future, we can claim it and track the policyholder.

Age: This attribute provides complete information about the time period of the insurance by calculating the age factor of the policyholder.

Policy-key: This field will act as a foreign key in this entity table to maintain the unique record of the policyholder with respect to his policy, for example, if we want to track the policyholder’s name having the particular policy, we will simply use the policy key where policy equals to the particular insurance policy.

Entity Four Claimer

This entity has its own importance that placeholder will choose this entity actually this field will get the benefit in case something wrong happens to the policyholder so to get the advantage of the insurance policyholder chose a person who will get the benefit in his absence.

Following are the few attributes which are possessed by the Agent entity they are:

PH-key: This attribute will contain the unique identity of the user so that we can identify the user who has taken the policy and served them according to their need, so this feature is very important to get the information about the policyholder because the name attribute can be same for many clients but their ID will differ.

Name: This attribute will provide the name of the policyholder, this field help in maintaining the quality record of the policyholder. That whenever we need to mention the name of the policyholder, we can match it with the unique id of the policyholder so that we can get the correct name and use it for better understanding and services for the clients.

Address: This attribute helps you in getting the full information about the policyholder his current address and permanent address so that if there is any case of forgery notice in the future, we can claim it and track the policyholder.

Age: This attribute provides complete information about the time of the insurance by calculating the age factor of the policyholder.

Policy-key: This field will act as a foreign key in this entity table to maintain the unique record of the policyholder with respect to his policy, for example, if we want to track the policyholder’s name having the policy, we will simply be using the policy key where policy equals to the particular insurance policy.

Policy Scheme of Insurance Agency Management System

In the policy scheme user will get to know about the new policies and insurance scheme so that the user can easily get to know which policy will be best for him and which would not suit him, this field will have updated by the admin based on market policies after updating the new policies user can get the notifications if he has opted that.

A policy scheme will also allow you to compare the policies in the market which is suitable. Comparing policies in the outer market will give satisfaction to the user so this feature will be like by the user and above all, we have tried to make an interaction between agent and client through chatting where the client can post their queries and get the response from clients or agent.

So, this feature will really helpful for the user, and the notification part will add more sweetness to this feature and make the application more interactive.

Payment Module

This section of the module helps in making financial transactions so that users can pay them easily. Let’s do the comparison with the existing system.

  • Initially, we need to move from one place to another to pay the money to the bank or Insurance office to deposit the installments.
  • To deposit money, need to stand in a long queue.
  • Agents use to take commission even to deposit the money.
  • It was really a headache to give one working day of the month in depositing the installments.
  • Sometimes we forgot the deposit dates which causes us to pay a late fee.

So, changes happened after developing this application, people do not need to stand in a long queue to deposit the installments, no need to take holiday for placing the repayments. Simply we can deposit our money online through an application where you find different options to pay the money options such as pay by debit card, credit card, or through net banking.

In our application, we have designed it in such a way that users will get the notification if there are any pending instillments, prior to two to three days so that clients can deposit them without any late charges. Indirectly this application will maintain all our headache of depositing installments and remembering the dates of installments.

Advance Features in Insurance Agency Management System

In this application, if you don’t want to make any transactions manually you can simply add the account number of the bank or place, or person whom you want to deposit the installment this application simply detects the date and make a transaction on that date.

It means, the application simply deducts the money from our account and sends it to deposit for completing installments and make you free from all this hectic process of depositing money and remembering the dates of installments.

System Requirements of Insurance Agency Management System

  • The user should have the appropriate version of windows.
  • The system should have up to 2 GB ram minimum requirement for the application.
  • The application should be installed on the system.

So, this is the overall process of making the Insurance policy system worked, and users can get the policy without any headache from an agent and sometimes do not need to provide commission to them.

User Interface

This is one of the main tasks of the developer to design such an interface that user can use it easily in one word it should be user friendly and for this you should have a better understanding of the audience which going to use this application, initially we need to locate the targeting people that what kind of application do they need.

After getting all this information we should start to design the application.