Which Order Is Correct for the Analyst to Normalize a Data

question 67

Multiple Choice

Which order is correct for the analyst to normalize a data structure?
I. Remove all repeating groups and identify the primary key.
II. Remove any transitive dependencies.
III. All partial dependencies are removed and placed in another relation.

• A) III - II - I
• B) I - II - III
• C) III - I - II
• D) II - I - III
• E) I - III - II

---

Definitions:

Extrinsic Motivation

Motivation that arises from external rewards or consequences rather than from the enjoyment of the task itself.

Peak Experience

A moment of intense joy, creativity, or satisfaction, often leading to a feeling of transcendence.

Self-Determination Theory

A psychological theory focused on motivation, proposing that people have innate psychological needs that are the basis for self-motivation and personality integration.

Innate Tendency

Natural instincts or inclinations present at birth and not acquired through learning.