Redirected
retagged by
1,100 views
3 votes
3 votes

Which of the following is TRUE?

  1. Every relation in $3$NF is also in BCNF
  2. A relation R is in $3$NF if every non-prime attribute of R is fully functionally dependent on every key of R
  3. Every relation in BCNF is also in $3$NF
  4. No relation can be in both BCNF and $3$NF.
retagged by

2 Answers

0 votes
0 votes
Option C is correct as every relation in BCNF is also in $3$NF as there would be zero redundancy and no partial and transitive dependencies would be present in such a relation.
Answer:

Related questions

3 votes
3 votes
4 answers
1
admin asked Mar 30, 2020
3,780 views
Consider the relational schema $\text{R(A B C D)}$ with following functional dependency set $F=\{A\rightarrow BC,C\rightarrow D\};$ The relation $\text{R}$ is in $2$NFBCN...
0 votes
0 votes
4 answers
3
admin asked Mar 30, 2020
4,903 views
Consider the relational schema $R(A B C D)$ with following $FD$ set $F=\{A \to CE, B \to D, AE \to D\}$. Identify the highest normal form satisfied by the relation $R$.$2...