Follow Us :

Nov2017 cs Q10

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

  • Option : 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
Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *