title: Importance of normalization in SQLite
body: <p>I have developed a blackberry app(ledger management system) which makes use of SQLite for data storage.</p>
  
  <p>There are several relations among the tables that i have created in my app</p>
  
  <p>Following are some of the tables and their columns:</p>
  
  <pre><code>1. Customer Details-Name,Phone,Email
  2. Bills-Name,Amount
  3. Update Customer-Name
  4. Update Bills-ID
  </code></pre>
  
  <p>and many other temporary tables.</p>
  
  <p>While i developed the app, i never really bothered to look up whether my tables were normalized.</p>
  
  <p>Now after i have completed my app, i wonder whether normalization was required or not.</p>
  
  <p>Most of my queries were based on selecting the records that were inserted into Customer and bills form and then manipulating on them.</p>
  
  <p>For instance, i have Customer Details table which captures all the customer data.Now once a name is recorded in the database,i do not want the same name to again be present in the table,so will this require normalization concept.</p>
  
  <p>Also in a RDBMS like SQLite is normalization essential.Does it hold the same meaning as with DBMS based tables.</p>
  
  <p>Also is there any difference between a OLAP and OLTP system wrt to database normalization.
  If yes, what would my blackberry app be categorized into?</p>
  
  <p>Appreciate a guidance if any one sound on this.</p>