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:

Margin Rate

Typically refers to the interest rate charged by brokers for borrowing funds to invest in securities.

Sales Outlook

A forecast or projection of future sales performance based on current market trends, data analysis, and sales history.

Interest Rate

The percentage at which interest is charged or paid on borrowed or saved money.

Expected Profit Rate

The forecasted return on an investment over a specified period, taking into account both potential gains and losses.