Question

What is normalization in database design?

• A. Process of organizing data to eliminate redundancy
• B. Process of indexing tables for faster queries
• C. Process of encrypting database records
• D. Process of backing up database files

Hint:

Normalization reduces redundancy but may increase query complexity; balance with denormalization if needed.

Answer 1

The Correct Option is A

Normalization is the process of structuring a relational database to:
- Eliminate data redundancy.
- Ensure data integrity.
- Organize data into tables following normal forms (e.g., 1NF, 2NF, 3NF).
Option (1) is correct.
Option (2) refers to indexing.
Option (3) refers to security.
Option (4) refers to backup, none of which are normalization.