Database

ERD for a Insurance Premium Financing Database

business scenario: insurance premium financing, the way it works is a customer needs to purchase insurance but can’t pay for the full premium. So, a lender (this) pays for the insurance premium to the broker on be half of the customer. The customer then makes monthly payments back to the lender. This database belongs to the lender who can then track all the customers, who their broker is and the particulars of there insurance policy as well as their outstanding balance. All this information is required because in the even the customer doesn’t make payments the lender can request of the insurance company to cancel the insurance policy and have the insurance company pay any unearned premium to the lender to cover the outstanding loan.

• This sample to fabulous for two reasons.
• 1. Clean code
• 2. Detailed testing