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

PYQ UGC NET 2017

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 488 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…