Normalization in DBMS: 1NF, 2NF, 3NF and BCNF
Normalization in DBMS is a database design approach that avoids undesired characteristics such as Insertion, Update, and Deletion Anomalies by reducing data redundancy. Normalization rules break bigger tables into smaller tables and use relationships to connect them. The goal of SQL normalization is to reduce duplicate (repetitive) data and ensure logical data storage. Data that …