Question

 Which of the following statements best describes the main reasons for normalizing relational database?

I. To achieve physical data independence. 

II. To remove data anomalies (insertion, update, deletion, anomalies). 

III.  To save space on Disk. 

1. (I) and (II) only 
2. (II) and (III) only 
3. (I) and (III) only 
4. (I) (II) and (III)  

Answer 1

Correct Answer - Option 2 : (II) and (III) only 

Concept:

Normalization is the process by which we can decompose or divide any relation into more than one relation to remove anomalies in a relational database.

Explanation:

Normalization is a step by step process and each step in this is known as normal form. It is a reversible process.

Properties of normalization:

1) Remove different anomalies

2) Decomposition must be lossless

3) To save space on disk

4) Reduce data redundancy

5) Preserve necessary dependency

Various normal forms are 1Nf, 2NF, 3NF, BCNF, 4NF and 5NF.