A Table Is in Second Normal Form When It Is

question 28

Multiple Choice

A table is in second normal form when it is in first normal form and _____.

• A)each nonkey column is dependent on the entire primary key field
• B)it contains candidate keys
• C)it allows no data modification anomalies
• D)it contains at least one foreign key field

---

Definitions:

Compounded Annually

A method of calculating interest where the interest rate is applied once per year, adding to the principal sum for the next period.

Equal Annual Payments

Regular payments of the same amount made over a specified period of time.

First Payment

The initial amount paid at the start of a payment plan or schedule, such as for a loan or lease.

Compounded Monthly

Compounded monthly refers to the process of calculating interest on the principal and previously earned interest on a monthly basis.