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

question 63

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) remove the determinant from the original relation
• E) None of the above

---

Definitions:

Purchase Money Security Interest

A legal claim or lien on collateral that secures payment of the debt used to buy the collateral, often applied in context with the sale of personal property.

Good Faith

The sincere intention to be fair, open, and honest, regardless of the outcome of the interaction.

Ordinary Course

Pertains to regular business activities and operations conducted by an entity under normal circumstances.

Security Interest

A financial mechanism that gives a lender priority over the borrower's assets or property in the case of default.