Relation \(R\) has eight attributes \(ABCDEFGH\). Fields of \(R\) contain only…

GATE · 2013 · CS · Computer Science & IT

 Relation RR has eight attributes ABCDEFGHABCDEFGH. Fields of RR contain only atomic values.

F=CH→G,A→BC,B→CFH,E→A,F→EGF={CH→G, A→BC, B→CFH, E→A, F→EG} is a set of functional dependencies (FDs) so that F+F^+ is exactly the set of FDs that hold for RR.

The relation R is

  1. A.

    in 1NF, but not in 2NF.

  2. B.

    in 2NF, but not in 3NF.

  3. C.

    in 3NF, but not in BCNF.

  4. D.

    in BCNF.

Attempted by 295 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…