Second Normal Form

According to second normal form table should be in First Normal form and we should have to remove Partial Functional Dependency.

In the above table DeptNo non-key column dependent part of the Primary Key column that is EmpNo.It means there existed Partial functional dependency.

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

Proj-Info:

ProjNo:p1
Pname:Pn1
Bud:----

Emp-Info:

EmpNo:11
EName:----
Sal:-------
DeptNo:-----
DeptName:-----
Loc:-----

Second Normal Form