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

Question

Quizplus · Accepted Answer

To achieve first normal form, each table must have a primary key and contain no repeating groups. By making the primary key a combination of OrderNum and ItemNum, you ensure that each row is unique and eliminate repeating groups.

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