Maybe this question has been asked already, but I don't know if my approach is correct.
Once I was modelling a database for my university. It was meant to store information about the health of the students, and then analyze it to give the student a feedback.
For example: in one question it was asked who have or had diabetes, with multiple options as an answer, for example:
And the student could select one or many options. I needed to store that in the database.
First the values in the DB where stored in a string where values were separated by a comma. (I know, this isn't the best way).
So I thought about doing the next things:
I thought about creating a table for each field where the value was stored like a comma separated array.
Having the same fields, but just to identify which relative has/had the disease.
What I did was correct?