Normalization Forms

Question 1

First Normal Form (1NF)

Answer 1

First Normal Form (1NF): All attributes in a relation must be atomic (indivisible), and each column must have a unique name. No repeating groups or arrays are allowed.

Question 2

Second Normal Form (2NF)

Answer 2

Second Normal Form (2NF): Must be in 1NF, and all non-prime attributes are fully functionally dependent on the entire primary key. Remove partial dependencies.

Question 3

Third Normal Form (3NF)

Answer 3

Third Normal Form (3NF): Must be in 2NF, and no transitive dependencies are allowed. Remove attributes that depend on other non-prime attributes.