Question: For a relation PRODSUPPLIES below, it is known to be in 1 NF and you are provided with the dependency information. Which of the following
For a relation PRODSUPPLIES below, it is known to be in NF and you are provided with the dependency information. Which of the following statements are correctPRODSUPPLIES SupNum SupName, ItemNum, ItemName, UnitPrice, QtyInStock, Discountlty, DiscountsSupNum SupNameItemNum ItemName, QtyInStockSupNum, ItemNum UnitPrice, Discountlty, Discount$ The relation is in NF but not NF The relation contains partial dependencies The relation is in NF but not NF The relation may be in NF but cannot be certain The relation contains transitive dependencies
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
