I am storing answers to an application form.
An example I am unsure of is the following:
What are the criteria for euthanasia? (Multiple-selection)
Options: a: sickness b: behavioural problems c: lack of space d: other, please describe:________________;
This is a one-to-many scenario and I have created 3 tables to map the question. My tables are as follows:
criteria stores the selections of a,b,c,d; EUTH_CRITERIA_OTHER stores the description if 'other' is chosen.
Is this a good way of storing data. I know it prevents null values being entered, I'm just not sure its the best way to do it. Are there any flaws that I'm not seeing? Your comments would be appreciated.
Last edited by grooverinthesouth; 05-05-06 at 08:52.
The EUTHANASIA table has a foreign key called 'soc_id' which refers to the society for which the euthanasia question refers to.
The tables store the answers. Its basically a data capture db which will produce reports and summaries on societies.
NOTE: I have included the foreign key in my original post now.
Last edited by grooverinthesouth; 05-05-06 at 08:51.