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

TPSC Computer/IT Posts · 2024 · Senior Computer Assistant 2024 · from our data (question pool)

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

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…