Which Type of Table Is an Excellent Candidate for Improvement

question 42

Multiple Choice

Which type of table is an excellent candidate for improvement to second normal form?

• A)table with duplicate records
• B)lookup table
• C)table with a multifield primary key field
• D)table with an AutoNumber primary key field

---

Definitions:

Futures Contract

A contractual agreement regulated by law, specifying the sale or purchase of an item at a fixed price, to be executed at a later date.

Spot Price

The immediate market value at which certain assets, like commodities, currencies, or securities, are available for purchase or sale with instant delivery.

Liquidate

The process of converting assets into cash or equivalent by selling them, often used in the context of closing a business or paying off debts.

Profits

The financial gain obtained when the amount earned from a business activity exceeds the expenses, costs, and taxes involved in sustaining the activity.