Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Steps
Order
1Step 1
2Step 2
3Step 3
4Step 4
5Step 5
DA0-002 Data Analysis Practice Question
Drag and drop the steps to normalize a database table from 1NF to 3NF in the correct order.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Step 1: Achieve 1NF by removing repeating groups and ensuring atomic values. Step 2: Achieve 2NF by removing partial dependencies. Step 3: Achieve 3NF by removing transitive dependencies.
Normalization proceeds from 1NF to 2NF to 3NF, then table creation and foreign keys.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Step 1: Achieve 1NF by removing repeating groups and ensuring atomic values. Step 2: Achieve 2NF by removing partial dependencies. Step 3: Achieve 3NF by removing transitive dependencies.
Why this is correct
This is the correct order because normalization proceeds sequentially from first normal form (1NF) to second normal form (2NF) to third normal form (3NF). Each step builds on the previous one: first address atomicity and repeating groups, then partial dependencies, then transitive dependencies.
- ✗
Step 1: Achieve 3NF by removing transitive dependencies. Step 2: Achieve 2NF by removing partial dependencies. Step 3: Achieve 1NF by removing repeating groups.
Why it's wrong here
This is incorrect because normalization must start from the lowest normal form. Removing transitive dependencies (3NF) before ensuring atomicity and removing partial dependencies is logically impossible and fails the prerequisite conditions.
- ✗
Step 1: Achieve 2NF by removing partial dependencies. Step 2: Achieve 1NF by removing repeating groups. Step 3: Achieve 3NF by removing transitive dependencies.
Why it's wrong here
This is incorrect because second normal form (2NF) requires the table to already be in first normal form (1NF). Removing partial dependencies before achieving 1NF violates the normalization hierarchy.
- ✗
Step 1: Achieve 1NF by removing repeating groups. Step 2: Achieve 3NF by removing transitive dependencies. Step 3: Achieve 2NF by removing partial dependencies.
Why it's wrong here
This is incorrect because third normal form (3NF) requires the table to already be in second normal form (2NF). Removing transitive dependencies before addressing partial dependencies skips a necessary step and may lead to incorrect decomposition.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DA0-002 question from scratch — 986 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DA0-002 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DA0-002 exam.