GATE | CS | 2013 | Databases | Normal Forms | Question 55 (original) (raw)

geeksforgeeks

Last Updated :

Discuss

Comments

For the relation R(ABCDEFGH) with FD's= {CH->G, A->BC, B->CHF, E->A, F->EG such that F+ is exactly the set of FDs that hold for R.} Consider the FDs given in above question. The relation R is

in 1NF, but not in 2NF.

in 2NF, but not in 3NF.

in 3NF, but not in BCNF.

in BCNF

This question is part of this quiz :

GATE CS 2013,Database Design(Normal Forms),DBMS GATE CS PYQ QUIZ,

Normalization & Normal Forms GATE CS PYQ Quiz

Tags:

GATE

DBMS Quiz

DBMS

GATE CS

Share your thoughts in the comments

author

GeeksforGeeks