Define normalization

Question 1

Define normalization in databases

Answer 1

Normalization is a schema design process that minimize data duplication and enforces data integrity.

Question 2

Define the process of refactoring data into levels/forms

Answer 2

1. Separate each entity into its own table.
2. Separate each discrete attribute into its own column.
3. Uniquely identify each entity (row) using a primary key.
4. Use foreign key columns to link related entities.