4,123 views
0 votes
0 votes
Which of the following statements best describes the main reasons for normalizingrrelational database ?

a)To achieve physical data independence

b) To remove data anamolies(insertion , update , deletion , anomalies)

c)To save space on disk

1) a,b,c

2)a and b

3) a and c

4)b and c

1 Answer

Best answer
1 votes
1 votes

I think it should be Option 4.

Database normalization, or simply normalization, is the process of organizing the columns(attributes) and tables (relations) of a relational databse to reduce data redundancy and improve data integrity.

Benefits Of Database Normalization : 

  • Data redundancy is reduced, which simplifies data structures and conserves disk space.
     
  • To free the collection of relations from undesirable insertion, update and deletion dependencies(Anomalies)
     
  • To reduce the need for restructuring the collection of relations, as new types of data are introduced, and thus increase the life span of application programs;
selected by
Answer:

No related questions found