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

Question

Quizplus · Accepted Answer

Normalization involves: 1NF (Remove repeating groups, identify primary key), 2NF (Remove partial dependencies), and 3NF (Remove transitive dependencies).

Which Order Is Correct for the Analyst to Normalize a Data