Hi there, i have been given this description of a database that needs to be created, but am getting very confused as to what tables and Primary and forign keys i need to be using in the tables.
"An insurace agent deals with a number of insurance companies. A policy-holder may have a number of policies with the insurace agent. Each policy is given a policy number and relates to a single policy holder. The company has a range of insurance products and may put together a range of products to form a policy. Examples of motor products are: Third party, fire, theft, accidental damage, legal cover, windscreen cover ect. Claims are make against policies. A claim relates to only one policy. The company's products are grouped by business area i.e. life, motor, marine, home etc. Any particular product belongs to only one business area. Besides general update operations, the following processes must be supported by the system:
1. The production of renewal notices to be issued a month in advance.
2. List all policy details held by an individual customer.
3. List all claims made in the last 12 months; group by insurance company and customer."
I have started work on it and know i need:
Customer table (Customer ref, First name, Surname, ect)
Claims table (Claims ref, policy ref.)
But im a little confused as to how i am to do the rest.
Any help at all would be much appreciated, Thanks Adam
"An insurace agent deals with a number of insurance companies. A policy-holder may have a number of policies with the insurace agent. Each policy is given a policy number and relates to a single policy holder. The company has a range of insurance products and may put together a range of products to form a policy. Examples of motor products are: Third party, fire, theft, accidental damage, legal cover, windscreen cover ect. Claims are make against policies. A claim relates to only one policy. The company's products are grouped by business area i.e. life, motor, marine, home etc. Any particular product belongs to only one business area. Besides general update operations, the following processes must be supported by the system:
1. The production of renewal notices to be issued a month in advance.
2. List all policy details held by an individual customer.
3. List all claims made in the last 12 months; group by insurance company and customer."
I have started work on it and know i need:
Customer table (Customer ref, First name, Surname, ect)
Claims table (Claims ref, policy ref.)
But im a little confused as to how i am to do the rest.
Any help at all would be much appreciated, Thanks Adam