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 1 NF and you are provided with the dependency information. Which of the following statements are correctPRODSUPPLIES (SupNum, SupName, ItemNum, ItemName, UnitPrice, QtyInStock, Discountlty, Discounts)SupNum --> SupNameItemNum -> ItemName, QtyInStockSupNum, ItemNum --> UnitPrice, Discountlty, Discount$ The relation is in 2NF, but not 3NF The relation contains partial dependencies The relation is in 1 NF, but not 2NF The relation may be in 3NF 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!