Normalization Forms

Normalization is classified into following normal forms

First Normal Form(1NF):-

If a relation(table) has single valued attribute(column) and attribute name should be unique then the relation is in First Normal Form(1NF).

Column names should not same and Column value must be single valued

Table in 1 NF

Second Normal Form(2NF):-

If a relation is in First Normal Form and every non-primary key attribute is fully dependent on the primary key. Then the relation is in Second Normal Form(2NF).

Table in 2 NF ( all columns non-pk fully dependent on PK column [EMPNO] )

Third Normal Form(3NF):-

If a relation is in First and Second Normal Form and no non-primary key attribute is transitively dependent on the primary key. Then the relation is in Third Normal Form(3NF).

Consider A →B, B →C then A → C (transitive dependent )

The 3NF considered as adequate for normal relational database design because most of the 3NF tables are free of insertion, update, and deletion. Moreover, 3NF always ensures functional dependency preserving and lossless.

If you are familiar with 3NF. you can design a proper relation database.

There are other normal forms such as Boyce Codd Normal Form (BCNF), Fourth Normal Form(4NF) and Fifth Normal Form(5NF)

Next, We’re going to discuss about “Different types of Keys in DBMS” [ https://medium.com/@pk0411/different-types-of-keys-in-dbms-c6f082d4866d ]