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:
EUTHANASIA (euth_id, soc_id[FK], .........) ;parent table
EUTH_CRITERIA (id, euth_id[FK], criteria);
EUTH_CRITERIA_OTHER (id, euth_id[FK], other_description);
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.