title: database design for dictionary application
body: <p>Currently I'd like to develop dictionary application for mobile device. The dictionary itself use offline file/database to translate the word. it just translates for two languages, for example english - spanish dictionary.
  I've a simple design in my mind. it would be two tables: English Table and Spanish Table. 
  for each table contain of:</p>
  
  <ul>
  <li>word_id = the id which would be a foreign key for other table</li>
  <li>word = the word</li>
  <li>word_description</li>
  <li>correspond_trans_id = the id of other table which is the translation for this word to other language.</li>
  </ul>
  
  <p>and also because of this is for mobile application, the database use SQLite.</p>
  
  <p>The definition data for each table has been provided order by field <em>'word'</em> on the table. However I'm still thinking the problem if there is addition for the data definition. Because the table would be order by field <em>'word'</em>, is there any method to put (insert) the new record still in order by word ? or any idea to make it more efficient ?</p>