Ask
Login
0
1.8kviews
consider a dependency diagram of relation R and normalize it upto third normal form.
written 8.0 years ago by gravatar for teamques10 teamques10 ★ 68k modified 2.9 years ago by gravatar for pedsangini276 pedsangini276 • 4.8k

enter image description here

Mumbai University > Information Technology > Sem 3 > Database Management System

Marks: 10M

Year: Dec 2013
database management systems
ADD COMMENT EDIT
1 Answer
0
70views
written 8.0 years ago by gravatar for teamques10 teamques10 ★ 68k

Step 1: The relation R is already in 1NF, since all its values are atomic.

Step 2: Converting into 2NF form. A relation schema R is in second normal form (2NF) if every non-prime attribute A in R is fully functionally dependent on the primary key

enter image description here

Step 3: Converting into 3NF. A relation schema R is in third normal form (3NF) if it is in 2NF and no non-prime attribute A in R is transitively dependent on the primary key

enter image description here

This is the final solution in 3NF.
ADD COMMENT EDIT
Please log in to add an answer.