Car Insurance Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Car Insurance Management System

Car Insurance Management 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 Car,Insurance,Booking,Payment,Bill. Admin user can manage all the operations of Payment,Bill,Car,Customer,Insurance and their details. Admin can create different type of reports of Car,Insurance,Booking,Payment,Bill according to their choise and filters. You can Download PHP and MySQL Project Car Insurance Management System with source code and database from this site. We also provide Project Report of Car Insurance Management System.

Functionalities and their descriptions of Car Insurance Management System are as follows:

  • You can search records on various criterias. Such as Car, Booking, Payment, Bill
  • Create, read, update and delete (CRUD) application has been implemented on Car,Insurance,Booking,Payment,Bill
  • Keep the track logs of Insurance, Customer, Payment ect
  • Advance search has been implemented on Insurance,Customer, Payment
  • You can see all the details of the Car, Booking, Customer, Payment
  • All the modules Customer, Payment, Insurance,Bill, Car are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Payment.
  • All the Insurance,Customer, Payment 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 Car data.

Modules of Car Insurance Management System and their descriptions:

  • Car Module : Manage all the operations of Car
  • Insurance Module : Manage all the operations of Insurance
  • Customer Module : Manage all the operations of Customer
  • Booking Module : Manage all the operations of Booking
  • Payment Module : Manage all the operations of Payment
  • Bill Module : Manage all the operations of Bill

Classes and their methods of Car Insurance Management System:

  • Car Methods : addCar(), editCar(), deleteCar(), updateCar(), saveCar(), searchCar()
  • Insurance Methods : addInsurance(), editInsurance(), deleteInsurance(), updateInsurance(), saveInsurance(), searchInsurance()
  • Customer Methods : addCustomer(), editCustomer(), deleteCustomer(), updateCustomer(), saveCustomer(), searchCustomer()
  • Booking Methods : addBooking(), editBooking(), deleteBooking(), updateBooking(), saveBooking(), searchBooking()
  • Payment Methods : addPayment(), editPayment(), deletePayment(), updatePayment(), savePayment(), searchPayment()
  • Bill Methods : addBill(), editBill(), deleteBill(), updateBill(), saveBill(), searchBill()

Database tables and attributes of the Car Insurance Management System:

  • Car Entity : Attributes of Car are car_id, car_owner_id, car_number, car_company car_type, car_description
  • Insurance Entity : Attributes of Insurance are insurance_id, insurance_bike_id, insurance_number, insurance_date, insurance_expiry, insurance_amount, insurance_type, insurance_description
  • Customer Entity : Attributes of Customer are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
  • Booking Entity : Attributes of Booking are booking_id, booking_title, booking_type, booking_ticket, booking_date, booking_description
  • Payment Entity : Attributes of Payment are payment_id, payment_customer_id, payment_date, payment_bill, payment_type, payment_description
  • Bill Entity : Attributes of Bill are bill_id, bill_customer_id, bill_number, bill_type, bill_receipt, bill_description

Database definition of Car Insurance Management System:

  • The details of Car is store into the Car tables respective with all tables
  • Each entity (Bill, Customer, Payment, Insurance, Car) contains primary key and unique keys.
  • The entity Customer, Payment has binded with Car, Insurance entities with foreign key
  • There is one-to-one and one-to-many relationships available between Payment, Booking, Bill, Car
  • All the entities Car, Payment, Customer, Bill are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Car Insurance Management System tables for fast query execution.

Super admin functionality of Car Insurance Management System:

  • Admin can add, edit, delete and view the records of Car, Payment, Customer, Bill
  • Admin can manage all the details of Insurance, Customer, Booking, Payment
  • Admin can also generate reports of Car, Insurance, Customer, Booking
  • Admin can search the details of Car, Payment, Customer, Bill
  • Admin can apply different level of filters on report of Car, Customer, Bill
  • Admin can tracks the detailed information of Payment, Bill, Car, Insurance

Report of Car Insurance Management System:

  • Generates the report on Customer,Booking,Car,Insurance,Payment,Bill,
  • Booking,Payment,Bill 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 Booking,Payment,Bill
  • Excel Sheet report has also been integrated for Insurance,Booking,Bill
  • You can create the CSV reports for Car,Payment,Customer

Limitation of Car Insurance Management System

  • Run time report generation is not available in Car Insurance Management System.
  • We have not implemented the dynamic report for Car,Booking,Payment,Insurance,Customer,Bill
  • This project Car Insurance Management System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Car, Booking, Bill cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Car Insurance Management System

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database