The figure below shows the functional dependencies in the Invoice relation. The primary key for the relation is the combination of Inv Num and Prod Numm.

  

Transcribed Image Text:

INVOICE Iny Num Sale Date 211347 15-Jan-2006 211347 15-Jan-2006 211347 15-Jan-2006 211348 15-Jan-2006 211349 16-Jan-2006 Prod Num AA-E3422QW QD-300932X RU-995748G AA-E3422QW Prod Label Rotary-Sander 0.25-in drill bit Band saw Rotary-Sander GH-778345P Power drill A Prod Price Ven Code Vend Name $49.95 211 $3.45 211 $39.99 309 $49.95 211 $87.75 157 B InvNum Sale Date Prod Num Prod Label Prod_Price Ven Code Ven_Name Quant Sold Neverfail, Inc. Neverfail, Inc. C BeGood, Inc. Neverfail, Inc. Tough Go, Inc. Quant Sold 1 8 1 2 1 INVOICE Iny Num Sale Date 211347 15-Jan-2006 211347 15-Jan-2006 211347 15-Jan-2006 211348 15-Jan-2006 211349 16-Jan-2006 Prod Num AA-E3422QW QD-300932X RU-995748G AA-E3422QW Prod Label Rotary-Sander 0.25-in drill bit Band saw Rotary-Sander GH-778345P Power drill A Prod Price Ven Code Vend Name $49.95 211 $3.45 211 $39.99 309 $49.95 211 $87.75 157 B InvNum Sale Date Prod Num Prod Label Prod_Price Ven Code Ven_Name Quant Sold Neverfail, Inc. Neverfail, Inc. C BeGood, Inc. Neverfail, Inc. Tough Go, Inc. Quant Sold 1 8 1 2 1

Answer rating: 100% (QA)

Function dependency A Inv Num sale date is this partial or transitive ANSWER Since a partial depende... View the full answer