Open In App

GATE | GATE CS 2013 | Question 55

Like Article
Like
Save
Share
Report

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

(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:

The table is not in 2nd Normal Form as the non-prime attributes are dependent on subsets of candidate keys. The candidate keys are AD, BD, ED and FD. In all of the following FDs, the non-prime attributes are dependent on a partial candidate key. A -> BC B -> CFH F -> EG


Quiz of this Question
Please comment below if you find anything wrong in the above post


Last Updated : 28 Jun, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads