Register

NIELIT 2017 DEC Scientist B - Section B: 24

• retagged by
1,780 views
3 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.

2 Answers

0 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.
Voting & Accepting an answer helps improve the community
Answer:
← Previous · NIELIT 2017 DEC Scie...Next → · NIELIT 2017 DEC Scie...
← Previous in category · NIELIT 2017 DEC Scie...Next in category → · NIELIT 2017 DEC Scie...
Position:
Show:

Related questions

6 6 votes
6 6 answers
5.1k
5.1k views
admin asked Mar 30, 2020
5,051 views
NIELIT 2017 DEC Scientist B - Section B: 55
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...
4 4 votes
6 6 answers
5.0k
5.0k views
admin asked Mar 30, 2020
4,978 views
NIELIT 2017 DEC Scientist B - Section B: 1
Which one of the following statements are not correct?$S1$: $3$NF decomposition is always lossless join and dependency preserving.$S2$: $3$NF decomposition is always loss...
0 0 votes
4 4 answers
6.6k
6.6k views
admin asked Mar 30, 2020
6,570 views
NIELIT 2017 DEC Scientist B - Section B: 25
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...
2 2 votes
3 3 answers
3.7k
3.7k views
admin asked Mar 30, 2020
3,684 views
NIELIT 2017 DEC Scientist B - Section B: 18
In conservative two phase locking protocol, a transactionShould release all the locks only at the beginning of transactionShould release exclusive locks only after the co...