Compare the Difference Between Similar Terms

Difference Between

Home /Archives for Normalization

Difference Between Normalization and Denormalization

Posted by

Normalization vs Denormalization Relational databases are made up of relations (related tables). Tables are made up of columns. If the tables are two large (i.e. too many columns in one table), then database anomalies can occur. If the tables are two small (i.e. database is made up of many smaller tables), it would be inefficient […]

Difference Between 3NF and BCNF

Posted by

3NF vs BCNF Normalization is a process that is carried out to minimize the redundancies that are present in data in relational databases. This process will mainly divide large tables in to smaller tables with fewer redundancies. These smaller tables will be related to each other through well defined relationships. In a well normalized database, […]

Difference Between 1NF and 2NF and 3NF

Posted by

1NF vs 2NF vs 3NF Normalization is a process that is carried out to minimize the redundancies that are present in data in relational databases. This process will mainly divide large tables in to smaller tables with fewer redundancies. These smaller tables will be related to each other through well defined relationships. In a well […]