Skip to content
Related Articles
Get the best out of our app
GeeksforGeeks App
Open App

Related Articles

UGC-NET | UGC-NET CS 2017 Nov – III | Question 10

Improve Article
Save Article
Like Article
Improve Article
Save Article
Like Article

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

Quiz of this Question

My Personal Notes arrow_drop_up
Last Updated : 01 Jun, 2021
Like Article
Save Article
Similar Reads