QUESTION Draw the dependency diagram and identify all dependencies, including all partial and transitive dependencies. You can assume that the table does not contain repeating groups and that any invoice number may reference more than one product. Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value AA-E3422QWQD-300932X 211348 211349 AA-E3422QW GH-778345P INV NUM 211347 211347 PROD NUM 211347 RU-995748G SALE DATE 15-Jan-2018 15-Jan-2018 15-Jan-2018 15-Jan-2018 16-Jan-2018 PROD LABEL Rotary sander 0.25-in. drill bit Band saw Rotary sander Power drill VEND CODE VEND NAME 211 211 309 211 157 NeverFail, Inc. NeverFail, Inc. BeGood, Inc. NeverFail, Inc. ToughGo, Inc. QUANT SOLD 1 8 1 2 1 PROD PRICE $49.95 $3.45 $39.99 $49.95 $87.75 INV_NUM Invoice Number PROD_NUM Product Number SALE DATE=Sales Date PROD LABEL-Product Label VEND_CODE=Vendor Code VEND NAME Vendor Name QUANT SOLD Quantity Sold PROD PRICE Product Price Hint: You went shopping. You purchased two shirts, then they generated an invoice for you. Can you know the date of sale, by checking your invoice number or product number? You wanted to learn the number of products you purchased. So, you check your invoice number and check the related product number, and you learn the number of products you purchased for that product. Because an invoice can include more than one different product. By checking the only invoice number, you cannot find the number of products sold. You need to specify the product number. Do you need to know who the vendor is? If you know the product, can you identify the supplier? Think about our sales database, the logic is the similar