GATE | CS | 2013 | Databases | Normal Forms | Question 55

Last Updated :
Discuss
Comments

For the relation R(ABCDEFGH) with FD's= {CH->G, A->BC, B->CHF, E->A, F->EG such that F+ is exactly the set of FDs that hold for R.} Consider the FDs given in above question. The relation R is

in 1NF, but not in 2NF.

in 2NF, but not in 3NF.

in 3NF, but not in BCNF.

in BCNF

Share your thoughts in the comments