title: Android Development: multiple tables or a huge single table whilst designing database?
body: <p>I am developing an android app and I am required to save data which needs to be distinguished via date of entry. </p>
  
  <p>To do this, I've thought of these approaches:</p>
  
  <ol>
  <li><p>Create a new table for each date and store the data in it.
  Thus, the table would consist of only 2 attributes, i.e item_number and amount</p></li>
  <li><p>Create a huge table which also contains the date attribute and unique_id. </p></li>
  </ol>
  
  <p>Would making multiple tables make it simpler to add data belonging to a specific date? However would it also degrade performance or take up more space?  </p>