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


Answer: D

Business

You might also like to view...

Which of the following can be thought of as the answer to the fundamental questions of theoretical reason?

A. The scientific method B. The contingency approach C. The normative model D. The practical approach

Business

The use of differential pricing over time or customer segments to maximize profits from a limited set of supply chain assets is

A) supply chain coordination. B) forecasting. C) aggregate planning. D) revenue management.

Business

Funds that are obtained from routine business transactions are known as _____.?

A. ?spontaneously generated funds B. ?additional funds needed C. ?cash flows from financing activities D. ?internally financed funds E. ?financial feedback funds

Business

The process of determining if plans are being accomplished and making necessary modifications is known as:

a. planning b. directing c. controlling d. organizing e. staffing

Business