In the Normalization Process,if You Find a Candidate Key That

question 4

Multiple Choice

In the normalization process,if you find a candidate key that is not a primary key then you should:

• A) place the columns of the functional dependency in a new relation.
• B) make the determinant of the functional dependency the primary key of the new relation.
• C) leave a copy of the determinant as a foreign key in the original relation.
• D) All of the above
• E) None of the above

---

Definitions:

Nominal rate

The stated or face interest rate on a loan or investment, not adjusted for inflation or the frequency of compounding.

Compounded annually

A way of calculating interest where the interest is added to the principal at the end of each year, leading to an increase in the amount on which the following year's interest is calculated.

RRSP fund

A Registered Retirement Savings Plan (RRSP) fund is a retirement savings plan sponsored by the Canadian government, allowing citizens to save for retirement on a tax-sheltered basis.

Nominal rate

An interest rate or return quoted on an investment or loan, not adjusted for inflation or other factors.