GATE CSE 2013 | Question: 55

Question

Relation $R$ has eight attributes $\text{ABCDEFGH}$. Fields of $R$ contain only atomic values. $F = \text{{CH $\rightarrow$ G, A $\rightarrow$ BC, B $\rightarrow$ CFH, E $\rightarrow$ A, F $\rightarrow$ EG}}$ is a set of functional dependencies $(FDs)$ so that $F^+$ is exactly the set of $FDs$ that hold for $R$.

The relation $R$ is

• A. in $\text{1NF}$, but not in $\text{2NF}$.
• B. in $\text{2NF}$, but not in $\text{3NF}$.
• C. in $\text{3NF}$, but not in $\text{BCNF}$.
• D. in $\text{BCNF}$.

Comments

Of all the 4 candidate keys suppose one key only violates 2nf, is the entire relation still not a 2nf i.e. other 3 candidate key follow 2nf and 1 candidate key violates.

Answer 1

Partial dependency exists when A Non key attributes is depending on a part of Key attribute.