title: Try to find Partial and transitive dependencies
body: <pre><code>Cust_id| Name |Ord_no|Ord_Date     |PROD-ID|Descr |Qty_ord|
  C001   | Pink | O81  |    15-Apr   |P005   |Chisel|6      |
  C001   | Pink | O81  |    15-Apr   |P004   |Jane  |14     |
  C0075  | Red  | O99  |    16-Apr   |P015   |Saw   |3      |
  C009   | Black| O56  |    16-Apr   |P033   |Punch |24     |
  C009   | Black| O56  |    16-Apr   |P004   |Jane  |9      |
  C001   | Pink | O88  |    17-Apr   |P015   |Saw   |10     |    
  </code></pre>
  
  <p>From this table example I am trying to understand both this dependencies. According to me partial dependencies have a primary composite key and transitive don't have.</p>
  
  <p>I think Primary key are <strong>Ord_no and Prod_id</strong>.Not sure about Cust_id</p>
  
  <p>The only non key column which depends on the whole key is Quantity. All the rest are partial dependencies.Not sure about Transitive dependency exist or not in this table</p>
  
  <p>Partial Dependency in the table are :
  •   Cust_id and Name 
  •   Prod_id and Decr </p>
  
  <p>Also the Transitive Dependency in the table are as follow :
  •   Ord no_ and Ord_date can be ?</p>
  
  <p><a href="https://i.stack.imgur.com/IudfG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IudfG.png" alt="Diagram ,sorry cant put this in the post."></a></p>
  
  <p>Update 1-I try to figure out but not sure about my answer.
   I just want clarification like <strong>order no is unique, and determines the customer</strong> so how can two different <strong>order_no 81 &amp; 88</strong> can have same customer id <strong>C001</strong>.
  Therefore I think no transitive dependency.</p>