title: Android sqlite database design using triggers
body: <p>I need to design a sqlite DB for an Android application.</p>
  
  <p>Use Case: I have 2 tables A, B.</p>
  
  <p>A has 4 columns _id, roll_no, name, Marks.</p>
  
  <p>B has 4 columns roll_no, past_score, current_score, expected_score.</p>
  
  <p>With every record added to this table i need to make a network request by sending Marks. The response of this request needs to be parsed and populated in the columns past_score, current_score, expected_score of table B.</p>
  
  <p>Can you please guide me as what would be the best approach to design the DB?
  I have heard of Triggers (never used it before) which could be used to maintain data integrity and foreign key constraint. Can i use trigger for the use case mentioned above or do i need to populate both the tables independently ?</p>
  
  <p>Pardon me if this question sounds silly. </p>