Correct option is C
Normal Forms (NF) are a set of rules in database design that reduce data redundancy and dependency by organizing data into related tables.
Important Key Points:
1. Normalization improves data integrity and eliminates duplicate data.
2. Common forms include
1NF, 2NF, 3NF, and
BCNF (Boyce-Codd Normal Form).
3. Normalization ensures efficient data management and retrieval.
Knowledge Booster:
·
1NF: Eliminates repeating groups within a table.
·
2NF: Ensures no partial dependency of any column on the primary key.
·
3NF: Removes transitive dependencies.
·
BCNF: Ensures every determinant is a candidate key.