in second normal form but not in third normal form

in third normal form but not in BCNF

in BCNF

in none of the above

BCNF is stricter than 3 NF

Lossless, dependency -preserving decomposition into 3 NF is always possible

Loss less, dependency - preserving decomposition into BCNF is always possible

Any relation with two attributes is BCNF

AE, BE

AE, BE, DE

AEH, BEH, BCH

AEH, BEH, DEH

{CF}+ = {ACDEFG}

{BG}± = {ABCDG}

{AE }+ = {ACDEFG}

{AC = {ACDFG}

Any relation with two attributes is in BCNF

A relation in which every key has only one attributes is in 2NF

A prime attribute can be transitively dependent on a key in 3 NF relation

A prime attribute can be transitively dependent on a key in a BCNF relation