DBMS: Normalization up to 3NF for Table(E_ID, E_Name, E_Post, E_Sex, E_Salary, E_Add)

1NF

First of all, let's check if the above relation is in 1NF. Since all the values in the table(relation) are atomic, we can say that the above relation is already in 1NF.

2NF

To check if the relation is in 2NF, let's check if there is any partial dependency. Here, E_ID is the Primary Key. Thus the following dependencies occur:

There aren't any partial dependencies here. Thus we can say that the above relation is already in 2NF.

3NF

Let's check if there are any transitive dependency in the above relation. The E_Salary  can be determined from E_Post. Thus, the following transitive dependency occur:

Thus, let's break down the relation into R1 and R2.

R1

R2

The transitive dependency is removed and hence the tables R1 and R2 are in 3NF.