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:

Verified
Correct Answer:
Verified
Q40: The _ process enables you to identify
Q41: Second normal form can be defined as
Q42: If you convert a collection of tables
Q43: Which of the following is a characteristic
Q44: A(n) _ key is a candidate key
Q45: To correct anomalies in a database, tables
Q46: If the primary key of a table
Q47: A table is in fourth normal form
Q48: Converting to third normal form always avoids
Q49: A column B is _ on another