title: Do I really need to normalize my database?
body: <p>Ok I recently asked a question and users answered is that I should normalize my database but I don't think I should really do it..</p>
  
  <p>The logic goes like this</p>
  
  <p>Am storing scripts in the database which are executed dynamically according to the user..</p>
  
  <p>So for example there's a script table</p>
  
  <pre><code>script_id | script_name
  +----------------------+
  12345       demo1
  54462       demo2
  90874       demo3
  43058       demo4
  </code></pre>
  
  <p>And now the user table</p>
  
  <pre><code>allowed_script_ids
  +-----------------+
  21345|90874
  </code></pre>
  
  <p>So this is simple here, but what happens is if I delete say <code>script_id</code> <code>90874</code>, but it doesn't remove the record from the user table so they suggested me for normalizing the database, but what if user has access to 1000 scripts? do I need 1000 records for that? Or I should continue with the way am going? Even If I insert each record entry for each access, I need to delete those everytime I revoke the access for that user.</p>