Third Normal Form

According to second normal form table should be in Second Normal Form and we should have to remove Transitive Functional Dependency.

In the above Emp-Info table non-key column DName dependent part on the other non-key column that is DeptNo. It means there existed Transitive functional dependency.

To make the table into third normal form we have to divide the table into multiple tables.

Proj-Info:

ProjNo:p1
Pname:pn1
Bud:--

Emp-Info:

EmpNo:11
Ename:------
sal:------


Dept-Info:

DeptNo:10
DName:----
Loc:------

Third Normal Form