Database Cell with multiple values?
I am designing an app where I want to search for diseases based on
symptoms. I am trying to design the database using MySql, but as a
beginner I run into some trouble with the design philosophy.
Basically a disease is going to have multiple symptoms, so on the
"disease" table I wanted to have these columns:
disease_id, disease_name, disease_description, disease_symptoms
The thing is, one disease is not going to have only a single symptom, and
putting multiple values in a single cell goes against DB design philosophy
from what I found out online.
So the best solution I found so far was to make a table with multiple
columns, 1 for disease id and then like 10 columns called: symptom_0,
symptom_1, symptom_2 ect. ect., so when I do an sql query it can return
all the diseases that have a specific symptom.
I was just wondering if there is a more efficient way to do this. Thank
you for your help.
No comments:
Post a Comment