title: When is the right instance or scenario to have multiple foreign keys in a table
body: <p>It is definitely possible to have multiple foreign keys on a table. But when is the right instance to do that?</p>
  <p>Is it right to have an instance whereby you have 2 foreign keys where the second foreign key references a foreign key that the second table that is being referenced already has as a foreign key?</p>
  <p><strong>Context</strong></p>
  <p><code>Id Int</code><br>
  <code>SecondTableId Int(FK)</code><br>
  <code>ThirdTableId Int(FK)</code> <br>
  <code>....</code></p>
  <p><strong>Third Table</strong> <br>
  <code>ThirdTableId Int</code><br>
  <code>SecondTableId Int(FK)</code><br>
  <code>....</code></p>