Insurace Policy Enquiry System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Insurace Policy Enquiry System

Insurace Policy Enquiry System is a web based application which has been developed over PHP and MySQL and runs on WAMP, XAMP or Apache2 server.. The main modules of the project is Insurance,Buyers,Payments,Taxes,User. Admin user can manage all the operations of Taxes,User,Insurance,Plans,Buyers and their details. Admin can create different type of reports of Insurance,Buyers,Payments,Taxes,User according to their choise and filters. You can Download PHP and MySQL Project Insurace Policy Enquiry System with source code and database from this site. We also provide Project Report of Insurace Policy Enquiry System.

Functionalities and their descriptions of Insurace Policy Enquiry System are as follows:

  • You can search records on various criterias. Such as Insurance, Payments, Taxes, User
  • Create, read, update and delete (CRUD) application has been implemented on Insurance,Buyers,Payments,Taxes,User
  • Keep the track logs of Buyers, Plans, Taxes ect
  • Advance search has been implemented on Buyers,Plans, Taxes
  • You can see all the details of the Insurance, Payments, Plans, Taxes
  • All the modules Plans, Taxes, Buyers,User, Insurance are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Taxes.
  • All the Buyers,Plans, Taxes modules has their unique record ID for fast transactions and searching
  • Editing, adding and updating of Records is improved which results in proper resource management of Insurance data.

Modules of Insurace Policy Enquiry System and their descriptions:

  • Insurance Module : Manage all the operations of Insurance
  • Buyers Module : Manage all the operations of Buyers
  • Plans Module : Manage all the operations of Plans
  • Payments Module : Manage all the operations of Payments
  • Taxes Module : Manage all the operations of Taxes
  • User Module : Manage all the operations of User

Classes and their methods of Insurace Policy Enquiry System:

  • Insurance Methods : addInsurance(), editInsurance(), deleteInsurance(), updateInsurance(), saveInsurance(), searchInsurance()
  • Buyers Methods : addBuyers(), editBuyers(), deleteBuyers(), updateBuyers(), saveBuyers(), searchBuyers()
  • Plans Methods : addPlans(), editPlans(), deletePlans(), updatePlans(), savePlans(), searchPlans()
  • Payments Methods : addPayments(), editPayments(), deletePayments(), updatePayments(), savePayments(), searchPayments()
  • Taxes Methods : addTaxes(), editTaxes(), deleteTaxes(), updateTaxes(), saveTaxes(), searchTaxes()
  • User Methods : addUser(), editUser(), deleteUser(), updateUser(), saveUser(), searchUser()

Database tables and attributes of the Insurace Policy Enquiry System:

  • Insurance Entity : Attributes of Insurance are insurance_id, insurance_plan_id, insurance_number, insurance_issue_date, insurance_premium, insurance_amount, insurance_type, insurance_description
  • Buyers Entity : Attributes of Buyers are buyer_id, buyer_insurance_id, buyer_name, buyer_mobile, buyer_email, buyer_username, buyer_password, buyer_address
  • Plans Entity : Attributes of Plans are plans_id, plans_insurance_id, plans_name, plans_type, plans_description
  • Payments Entity : Attributes of Payments are payment_id, payment_customer_id, payment_date, payment_amount, payment_description
  • Taxes Entity : Attributes of Taxes are tax_id, tax_insurance_id, tax_name, tax_type, tax_description
  • User Entity : Attributes of User are user_id, user_name, user_mobile, user_email, user_username, user_password, user_address

Database definition of Insurace Policy Enquiry System:

  • The details of Insurance is store into the Insurance tables respective with all tables
  • Each entity (User, Plans, Taxes, Buyers, Insurance) contains primary key and unique keys.
  • The entity Plans, Taxes has binded with Insurance, Buyers entities with foreign key
  • There is one-to-one and one-to-many relationships available between Taxes, Payments, User, Insurance
  • All the entities Insurance, Taxes, Plans, User are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Insurace Policy Enquiry System tables for fast query execution.

Super admin functionality of Insurace Policy Enquiry System:

  • Admin can add, edit, delete and view the records of Insurance, Taxes, Plans, User
  • Admin can manage all the details of Buyers, Plans, Payments, Taxes
  • Admin can also generate reports of Insurance, Buyers, Plans, Payments
  • Admin can search the details of Insurance, Taxes, Plans, User
  • Admin can apply different level of filters on report of Insurance, Plans, User
  • Admin can tracks the detailed information of Taxes, User, Insurance, Buyers

Report of Insurace Policy Enquiry System:

  • Generates the report on Plans,Payments,Insurance,Buyers,Taxes,User,
  • Payments,Taxes,User has been integrated with the dynamic filter. So you can filter the records run time
  • You can also import the report data into PDF of Payments,Taxes,User
  • Excel Sheet report has also been integrated for Buyers,Payments,User
  • You can create the CSV reports for Insurance,Taxes,Plans

Limitation of Insurace Policy Enquiry System

  • Run time report generation is not available in Insurace Policy Enquiry System.
  • We have not implemented the dynamic report for Insurance,Payments,Taxes,Buyers,Plans,User
  • This project Insurace Policy Enquiry System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Insurance, Payments, User cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Insurace Policy Enquiry System

  • We have added all the validations for input value on the modules Insurance,Buyers,Plans
  • Payments,Taxes,User can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Insurance,Plans,User
  • CSRF token has also been implemented on Payments,Buyers,Insurance, Taxes,User
  • All the Insurance,Payments,Taxes,Buyers,Plans,User has integrated with captcha for spam protections
  • Access level validation has been implemented on User,Taxes,Payments
  • Number and character validation has also been implemented on Plans,Taxes,Insurance

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database