title: Database Cell with multiple values?
body: <p>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.</p>
  
  <p>Basically a disease is going to have multiple symptoms, so on the <code>disease</code> table I wanted to have these columns:</p>
  
  <pre><code>disease_id, disease_name, disease_description, **disease_symptoms** 
  </code></pre>
  
  <p>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.</p>
  
  <p>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: <code>symptom_0</code>, <code>symptom_1</code>, <code>symptom_2</code>, ect. So when I do a SQL query it can return all the diseases that have a specific symptom.</p>
  
  <p>I was just wondering if there is a more efficient way to do this.</p>