For this example we are going to deal with a very basic insurance company scenario. We are only going to look at the information about automobile insurance here. You need to figure out the relationships among the entities and add fields to what I have set up where necessary so that you can relate the information correctly. You also need to establish primary and foreign keys. You need to give me the tables you have designed and an explanation of the design.

The entities that we are going to deal with are:

• The person holding the policy (we want an id, name, address and other contact information)
• A policy (policy #, type of policy, starting date, ending date, premium, status, there will also be specific fields about the contents of the policy and amounts but you do not have to enter that, there should also be a way to connect the policy to the person holding the policy – please note that a person can have more than one policy but a policy belongs to a specific person)
• An insured item (license plate number, state, make, model, year, value, registration)
• A claim (claim id, description, policy claim is against, date of event, date complaint filed, police record #, amount of claim)
• A payment on claim (information about the recipient, amount, date of payment)