0
3.3kviews
consider a dependency diagram of relation R and normalize it upto third normal form.

enter image description here

1 Answer
0
64views

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.

Convert up to bcnf form


Please log in to add an answer.

Continue reading...

The best way to discover useful content is by searching it.

Search