What are the difference between types of normal forms in DBMS

Question

Accepted Answer

Different normal forms in DBMS help in organizing data efficiently and reducing redundancy.

First Normal Form (1NF) - Eliminates repeating groups and ensures each attribute contains only atomic values.
Second Normal Form (2NF) - Meets 1NF requirements and all non-key attributes are fully functional dependent on the primary key.
Third Normal Form (3NF) - Meets 2NF requirements and eliminates transitive dependencies between non-key attributes.
Boyce-Codd Normal Form (BCNF) - A stronger version of 3NF where every determinant is a candidate key.
Fourth Normal Form (4NF) - Reduces multi-valued dependencies.
Fifth Normal Form (5NF) - Addresses cases where a table has multiple overlapping candidate keys.

Top Confidential Company Salesforce Developer interview questions & answers