In database design, which of the following describes a table in Third Normal Form (3NF)?

Correct option is C

Normalization is the process of organizing a database to minimize redundancy and improve data integrity.
· A table is in Third Normal Form (3NF) if:
1. It is in Second Normal Form (2NF).
2. It has no transitive dependencies (i.e., no non-prime attribute depends on another non-prime attribute).
For example, if a table has attributes A, B, and C:
· If A → B (functional dependency) and B → C, then A → C is a transitive dependency.
· To achieve 3NF, we split the table to remove this dependency.
Important Key Points:
1. First Normal Form (1NF): Ensures each column contains atomic values, and no repeating groups exist.
2. Second Normal Form (2NF): Removes partial dependencies (dependencies on part of a composite primary key).
3. Third Normal Form (3NF): Eliminates transitive dependencies, ensuring no attribute depends indirectly on the primary key.
Knowledge Booster:
· Partial Dependency: A non-prime attribute is dependent on part of a composite primary key.
· Transitive Dependency: A non-prime attribute is dependent on another non-prime attribute.
· Boyce-Codd Normal Form (BCNF): A stricter form of 3NF where every determinant is a candidate key.