2NF to 3NF

• Identify FD’s in the relation.
• If transitive dependencies exist on the primary key remove them by placing them in a new relation along with copy of their determinant.

EMP_DEPT(Enum, Ename, Sal, Dnum, Dname, Mgr)

Enum–>{Ename, Sal, Dnum}, Dnum–>{Dname, Mgr}

second FD is transitive through Dnum

Decompose EMP_DEPT into

EMP(Enum, Ename, Sal, Dnum) and DEPT(Dnum, Dname, Mgr)

Advertisement