what is normalization and its advantage

1 The process of separating data into distinct, unique sets is called normalization. This is implemented to improve the performance of the RDBMS, such as reduces redundancy of data and data inconsistency.
   
2 Normalization is the process of removing redundant data from your tables in order to improve storage efficiency, data integrity and scalability.
   
3

Database normalization is a series of steps followed to obtain a database design that allows for consistent storage and efficient access of data in a relational database. These steps reduce data redundancy and the risk of data becoming inconsistent.

   
4

Normalization is the process used to reduce the unnecessary repetition of data i.e., redundant data. It is performed on the data, which is redundant and makes the data in a normalized format. It is of step-by-step process Ist Normal, Form IInd Normal, form IIIrd Normal, form IVth Normal form or Boyce odd Normal form By performing this we will get the data in the Normalized formatted from DBMS to RDBMS.

   

No comments:

Post a Comment