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:

Surplus

At a given price, the amount by which quantity supplied exceeds quantity demanded; a surplus usually forces the price down.

Supply Curve

A graph showing the relationship between the price of a good and the quantity of the good that producers are willing to supply.

Lobster Farms

Aquaculture facilities dedicated to the breeding, raising, and harvesting of lobsters for commercial use and consumption.

Algae

A diverse group of photosynthetic organisms that are not necessarily closely related, and that live in a variety of water environments.