Normalization

Question 1

What is Normalization?

Answer 1

Systematic process of organizing the columns (attributes) and tables (relations) of a relational database to minimize data redundancy and improve data integrity

Question 2

What is the 1NF?

Answer 2

-No repeating groups/list in one cell
-Splitting multivalued cells

Question 3

What is the 2NF?

Answer 3

Is applied if the PK is composite.

-Non key attributes must depend on the entire composite key
-Fix by moving partially dependent attributes to a new table.