Normalization in DBMS: 1NF, 2NF, 3NF and BCNF

normalization in dbms

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 …

Read more

Difference Between SQL and MySQL

SQL and MySQL

SQL and MySQL are languages used to manage databases. A database is a collection of data, organized and stored in a form that is easily accessible. SQL and MySQL are languages that allow users to maintain and manipulate databases. To better understand the difference between SQL and MySQL let us first look at what a …

Read more