Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value
INV_NUM 211347 211347 211347 211348 211349
PROD_NUM AA-E3422QW QD-300932X RU-995748G AA-E3422QW GH-778345P
SALE_DATE 15-Jan-2006 15-Jan-2006 15-Jan-2006 15-Jan-2006 16-Jan-2006
PROD_LABEL Rotary sander 0.25-in. drill bit Band saw Rotary sander Power drill
VEND_CODE 211 211 309 211 157
VEND_NAME 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

I am suppose to take this table and put it into 1NF, 2NF, and 3NF. I get how to get it into the forms but I am confused on the partial dependency part. I know PROD_LABEL and PROD_PRICE have a partial dependency relationship with PROD_NUM. Where i get confused though is should INV_NUM be a primary key as well and do all the other attribute depend on it?

P.S. I know VEND_CODE and VEND_NAME have a transitive dependency relationship.

5 Years
Discussion Span
Last Post by dsmith12

here is the graph the way it suppose to look its an attached image.

Attachments Screen_shot_2012-02-19_at_5.11_.58_PM_.png 41.05 KB
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.