



Request
===========================
1. Write a script to map the attached claims.sql fields to Table : claims_table.
2. Let the script to insert into Table : claims_table




claims.sql
====================
`claim_id`, `policy_number`, `policy_product`, `classification`, `amount`, `status`, `cheque_date`




Table : claims_table
====================
id
claims_no : claim_id
master_policy_number : policy_number
policy_product : policy_product
claim_type : classification
claim_amount : amoun
claim_status : status
claims_paid_date : cheque_date
created_at
updated_at












Request
===========================
1. Write a script to map the attached payment.sql fields to Table : payment_transactions.
2. Let the script to insert into Table : payment_transactions
3. Break it into 5 scripts



payment.sql
====================
`Policynum`, `fullname`, `policy_product`, `commence_date`, `amountreceived`, `paymentmethod`, `deduction_date`, `paiddate`, `agent_code`, `agent_name`, `branch`

note : break  fullname into  lbfirstname  & last_name 

Table : payment_transactions
===========================
id
master_policy_number = Policynum
mobile_number : 0
first_name : lbfirstname
last_name  : last_name
policy_product : policy_product
commence_date : commence_date
payment_frequency : N/A
amountreceived : amountreceived
paymentmethod : paymentmethod
referencenumber : N/A
paid_date : deduction_date
payment_status : Paid
agent_code : agent_code
agent_status
agent_name : agent_name
sales_manager
branch_name : branch
created_at  : paiddate
updated_at
