UGC-NET | UGC-NET CS 2017 Nov - III | Question 10
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 __________ . (A) in 1NF but not in 2NF (B) in 2NF but not in 3NF (C) in 3NF but not in BCNF (D) in BCNF Answer: (A) Explanation: If we find closure of A: A+ → All attribute