Normalization in a database is done to:

Correct answer: Minimize data redundancy. Normalization organises tables to reduce repeated (redundant) data.

Background: It splits large tables into smaller related ones.

• Delete data: Normalization does not delete data.
• Increase data: Normalization does not increase the amount of data.
• Copy data: Normalization does not copy data.

Did you know? Common forms are 1NF, 2NF, and 3NF.

Memory trick: Normalize = less repetition.