UGC-NET Computer Science Previous Year Question Papers

UGC-NET NOVEMBER 2017 QUESTIONS WITH EXPLANATION 

CBSE-NET NOVEMBER 2017 QUESTIONS WITH EXPLANATION 

NTA-NET NOVEMBER 2017 QUESTIONS WITH EXPLANATION 

Q: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 atribute except D.
Similarly for other keys we can find closure, but D can’t be derived from any key and it must be added to all keys to be derived from. That’s why this relation is in 1NF, since there is partial dependency so, this relation is not in 2NF.
So, option (A) is correct.