Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is…

Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist.

CH → G

A → BC

B → CFH

E → A

F → EG

The relation R is __________ .

  1. A.

    in 1NF but not in 2NF

  2. B.

    in 2NF but not in 3NF

  3. C.

    in 3NF but not in BCNF

  4. D.

    in BCNF

Attempted by 26 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…