edited by
4,570 views
2 votes
2 votes

Consider a relation $R (A, B, C, D, E, F, G, H)$ where each attribute is atomic, and following functional dependencies exist.

$ CH \rightarrow G$

$A \rightarrow BC$

$B \rightarrow CFH$

$E \rightarrow A$

$F \rightarrow EG$

The relation $R$ is ________

  1. In $1NF$ but not in $2NF$
  2. In $2NF$ but not in $3NF$
  3. In $3NF$ but not in $BCNF$
  4. In $BCNF$
edited by

1 Answer

2 votes
2 votes
Firstly find the candidate  keys for given relation R. These are :AD, BD, ED, FD

Now after finding candidate keys, check the relation  for BCNF, 3NF and 2NF

For BCNF, every determinent must be super key. But this is not followed by any FD, so relation is not in BCNF.

For 3NF, if there is X-> Y dependency then Y must be prime attribute, which is satisfied by given FDs (like CH->G, G is not prime) , so relation is not in 3NF.

For 2NF, there must not be any partial dependency, but A->BC is partial dependency, so relation is not in 2NF.

According to given question,  all values are atomic so relation is in 1NF.

Correct option is A.
Answer:

Related questions

5 votes
5 votes
18 answers
2
Arjun asked Nov 5, 2017
6,032 views
If every non-key attribute is functionally dependent on the primary key, then the relation is in ________First normal formSecond normal formThird normal formFourth normal...