Difficulty: Easy
Correct Answer: normal forms.
Explanation:
Introduction / Context:
Normalization organizes relational schemas to reduce redundancy and eliminate update, insert, and delete anomalies. The outcomes are categorized into named stages.
Given Data / Assumptions:
Concept / Approach:
Each stage of normalization corresponds to a normal form. These forms impose increasingly strict rules based on functional and other dependencies to mitigate anomalies.
Step-by-Step Solution:
Verification / Alternative check:
Textbook definitions explicitly refer to 1NF, 2NF, 3NF, BCNF, 4NF, and 5NF as normal forms addressing anomalies.
Why Other Options Are Wrong:
Common Pitfalls:
Confusing the tools (dependencies, constraints) with the results (normal forms).
Final Answer:
normal forms.
Discussion & Comments