title: SQLite: how to organize my data base
body: <p>I am having a simple android app and want to know the best way to organize my database tables (mysql).
  The idea of the app is a list of categories then the user presses on one of these categories and he gets another list of items and when he clicks on one of them, he gets details about it.</p>
  
  <p>For example, the first list (countries) has (UK, US, China, Japan, and other countries)</p>
  
  <p>You click on US, you get another list (states) has (California, NY, Arizona,...)</p>
  
  <p>You click on California, you get its details (population, area, capital)</p>
  
  <p>Same thing would happen if you click UK then London...</p>
  
  <p>So, how should I arrange my data, should I make:</p>
  
  <ol>
  <li><p>one table for countries and another table for each country, </p></li>
  <li><p>only one big table for all states and it will have a column to say which country does it belong to.</p></li>
  <li><p>any other suggestion?</p></li>
  </ol>