Normalization allows us to design database tables efficently.it reduces data redundancy and avoid data anomalies
Explanation:
Normalization on database can go till 3rd NormalForm.BCNF is always not possible to apply on all tables .so BCNF and Higher Normal forms which is dependent on BCNF is always not possible to apply on all database designs. In general we will go till 3rd normal form.1st normal form illustrates that there should not be any repeating data in a record it should be atomic.2nd normal form illustrates that it should be in 1st normal form and if any composite key exist then all remaining values should dependent on that composite key. 3rd normal form illustrates that if should be in 2nd normal form and all keys should dependent directly on primary key.
