Consider the schema and functional dependency set of Empdept given below:

Empdept (emp# ,Dept#, Manager#, Dept_Name , Dept_Loc)

Emp#Dept#  manager# manager#  Dept #

Normalisation:

1st normal form: the relion is already in 1nf as each cell is single valued.

2nd Normal form: A relation is in second normal form if it is 1NF and every non key attribute is fully dependent on each candidate key of the relation. Thus R is also in 2NF.

3rd Normal form: A relation is in second normal form if it is 2NF and every non key attribute is non-transitively dependent on each candidate key of the relation. This above relation is in 3NF as every non key attribute is non-transitively dependent on each candidate key of the relation.

Here primary key is emp# and candidate key is (emp# ,Dept#, Manager#)

BCNF Normal form: A relation is in second normal form if it is 3NF and if X->A in R and A is not in X, then X is a candidate key. The above relations satisfy this condition.

The above relation is not in BCNF as in Fd manager#  Dept # , dept# is dependent on manager# but manager#is not in candidate key.