The relation Order ( OrderID , ProductID , Quantity, ProductName) has the following dependencies: OrderID, ProductID → Quantity ProductID → ProductName Note : the underlined columns are PKs. Which of the following statements is correct?

Question

The relation  Order ( OrderID ,  ProductID , Quantity, ProductName)  has the following dependencies: OrderID, ProductID → Quantity ProductID → ProductName Note : the underlined columns are PKs. Which of the following statements is correct?

Accepted Answer

The relation is in 1NF but not in 2NF.

Answer

There is a transitive dependency that needs to be removed.

Answer

The relation is in 2NF but not in 3NF.

Answer

There are no partial dependencies.

Crowdly

The relation Order ( OrderID , ProductID , Quantity, ProductName) has the fol...

Want instant access to all verified answers on eclass.yorku.ca?