When a patient comes into the Sports Physical Therapy, they often have insurance to cover some or all of the cost of the therapy sessions. Assuming that a few patients might use two insurance companies (e.g., a spouse’s insurance might supplement the patient’s insurance), how would you record the insurance information ensuring that the table is normalized?

a. Add two fields to the Patient table: InsuranceCompany and PolicyNumber. For patients with two policies, enter an additional record.

b. Create a new table that includes all the data from the Patient table and the new fields, InsuranceCompany and PolicyNumber.

c. Create a new Insurance table that includes the PatientNum, InsuranceCompany, and PolicyNumber fields. The Insurance table could have an autoincrementing key field or a compound key, PatientNum and PolicyNumber.

d. Add two fields to the Session table: InsuranceCompany and PolicyNumber. For patients with two policies, enter an additional record.