what is normalization in dbms

There are presently five ordinary structures that are characterized in DBMS. These are 1NF, 2NF, 3NF, 4NF and 5NF (where NF represents Normal Form). For the most part, an information base should basically follow initial three ordinary structures. The 4NF and 5NF are infrequently followed because of execution reasons and over enhancement.  1NF, 2NF, 3NF were proposed by E.F. Codd. However, later on, a more grounded meaning of 3NF is known as BCNF was proposed by Boyce and EF Codd thus the name BCNF (Boyce Codd Normal Form).You can feel free to find out pretty much every one of the ordinary structures exhaustively individually in the articles that follow. The table is in 1 NF in light of the fact that each trait has nuclear qualities. In any case, it's anything but in 2NF in light of the fact that non prime property teacher_age is reliant upon teacher_id alone which is a legitimate what is normalization in dbms subset of up-and-comer key. This abuses the standard for 2NF as the stan