Question

In databases, de-normalization is used for
(1) Database backup
(2) deleting tables in normal form
(3) eliminating redundancy
(4) performance tuning

Answer 1

Answer:

Explanation:

Normalization is one of the basic concepts of relational data modelling. In the relational database model, good database design is characterized by minimal redundancy. The reason for this is that redundant data leads to semantic anomalies, which, in turn, make automatic data processing and database maintenance difficult. Normalization is a strategy to eliminate redundancies in relational databases. We'll show you how to implement database normal forms.