What Is a Potential Problem, If Any, If You Design

question 35

Multiple Choice

What is a potential problem, if any, if you design a database in which the last name of a consultant functionally determines the consultant's address?

• A) There is no problem with this design.
• B) There could be two consultants living at the same address.
• C) There could be more than one consultant with the same last name.
• D) The address will automatically functionally determine the consultant's last name.

---

Definitions:

Rate of Return

The gain or loss on an investment over a specific period, expressed as a percentage of the investment's initial cost.

Interest Rate

The fee, shown as a percentage of the principal, that a lender requires from a borrower for the utilization of assets.

Purchase

The act of acquiring goods or services in exchange for money, constituting a financial transaction.

Compounded Annually

Refers to the process of earning interest on both the initial principal and the accumulated interest from previous periods on a yearly basis.