Solved

With the Table Orders (OrderNum, OrderDate, (ItemNum, NumOrdered) ) Where

Question 50

Multiple Choice

With the table Orders (OrderNum, OrderDate, (ItemNum, NumOrdered) ) where OrderNum is the primary key, how would you convert the table to first normal form?


A) by creating a second table with just the columns ItemNum and NumOrdered
B) by changing the primary key to OrderDate
C) by making ItemNum a foreign key
D) by making the primary key a combination of OrderNum and ItemNum

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions