title: Can a table have two foreign keys?
body: <p>I have the following tables (Primary key in <strong>bold</strong>. Foreign key in <em>Italic</em>)</p>
  
  <h3>Customer table</h3>
  
  <ul>
  <li><strong>ID---Name</strong>---Balance---<em>Account_Name</em>---<em>Account_Type</em></li>
  </ul>
  
  <h3>Account Category table</h3>
  
  <ul>
  <li><strong>Account_Type</strong>----Balance</li>
  </ul>
  
  <h3>Customer Detail table</h3>
  
  <ul>
  <li><strong>Account_Name</strong>---First_Name----Last_Name---Address</li>
  </ul>
  
  <p>Can I have two foreign keys in the Customer table and how can I implement this in MySQL?</p>
  
  <hr>
  
  <p><strong>Updated</strong></p>
  
  <p>I am developing a web based accounting system for a final project.</p>
  
  <p><strong>Account Category</strong></p>
  
  <p><strong>Account Type</strong>--------------Balance</p>
  
  <p>Assets<br>
  Liabilities<br>
  Equity<br>
  Expenses<br>
  Income   </p>
  
  <p><strong>Asset</strong>  </p>
  
  <ul>
  <li><strong>Asset_ID</strong>-----Asset Name----Balance----<em>Account Type</em></li>
  </ul>
  
  <p><strong>Receivable</strong></p>
  
  <ul>
  <li><strong>Receivable_ID</strong>-----Receivable Name-------Address--------Tel-----<em>Asset_ID</em>----<em>Account Type</em></li>
  </ul>
  
  <p><strong>Receivable Account</strong></p>
  
  <ul>
  <li>Transaction_ID----Description----Amount---
  Balance----<em>Receivable_ID</em>----<em>Asset_ID</em>---<em>Account Type</em></li>
  </ul>
  
  <p>I drew the ER(Entity relationship) diagram using a software and when I specify the relationship it automatically added the <em>multiple foreign keys</em> as shown above. Is the design not sound enough?</p>