GATE|GATE-CS-2013 |Question10

 

GATE|GATE-CS-2013 |Question9

Relation R has eight attributes ABCDEFGH. Field of R contain only atomic values.

F={CH->G,A->BC,B->CFH,E->A,F->EG} is a set of functional dependencies(FD) so that F+ is exactly the set of FD that hold for R

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)

A->BC

B->CFH

F->EG

all are partial dependencies.Hence it is in 1NF but not in 2 NF.