Computer Sciene of Udayana State University

April 26, 2009

2NF to 3NF

Filed under: Computer Science — ignaga @ 2:07 AM
  • 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)


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at

%d bloggers like this: