Which of the following statements best describes the main reasons for normalizing relational database?
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.
Show answerHide answer
Correct answer: (D) II and III only
Explanation
Normalization removes redundancy, which prevents insert, update and delete anomalies and saves storage space. It does not provide physical data independence, which comes from the three-level architecture.