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

---

Definitions:

Child Sexual Abuse

Involves an adult or older adolescent engaging in sexual activities with a child.

Disclose

To make known or reveal information that was previously private or secret.

Underestimates

Occurs when the value, amount, importance, or size of something is judged to be lower than it actually is.

Sexually Abused

Refers to being subjected to unwanted or forced sexual activity by another individual.