title: Database design: Is there a way to improve on this design?
body: <p>Simple question- Below is the database design to hold the following records</p>
  
  <pre><code>account     TransactionType     TransactionName                 Amount      FeeTransactionId    TransactionId   RefTransactionId
  
  Alex        [Deposit from]      [Credit Card x-1234]            [-100.00]               b           a   
  Alex        [Deposit from]      [Credit Card Fee]               [-3.00]                             b           a
  Alex        [Added funds from]  [Credit Card x-1234]            [100.00]                            c           a
  Sys_        [Revenue from]      [Credit Card Deposit]           [3.00]                              d           a
  </code></pre>
  
  <hr>
  
  <p>the design</p>
  
  <pre><code>[Transaction]
  Id
  AccountId 
  TransactionTypeId
  TransactionName
  Amount
  FeeTransactionId
  RefTransactionId
  
  [Account]
  Id
  Name
  
  [TransactionType]
  Id
  Name
  </code></pre>
  
  <p><strong>Is there a way to improve on this design?</strong></p>
  
  <p><strong>Note:</strong> currency and date is missing. :)</p>