Register

UGC NET CSE | December 2014 | Part 3 | Question: 12

• recategorized by
5,249 views
6 votes
6 votes

Which of the following is false ? 

  1. Every binary relation is never be in $BCNF$. 
  2. Every $BCNF$ relation is in $3NF$. 
  3. $1 NF, 2 NF, 3 NF$ and $BCNF$ are based on functional dependencies. 
  4. Multivalued Dependency $(MVD)$ is a special case of Join Dependency $(JD)$
• recategorized by
User Avatar

2 Answers

Best answer
11 votes
11 votes

Every binary relation(a relation with only 2 attributes) is always in BCNF.

because If both attributes form the primary key, the relation is in BCNF. If one of the attributes is a primary key, the other must be determined by it and thus the relation is in BCNF.

Hence,Option(A)Every binary relation is never be in BCNF.

• edited by
User Avatar
1 votes
1 votes
Option B will be absolutely right.

Bcz every relation in BCNF will must be in 3NF ,2NF,1NF
User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

4 votes
4 votes
2 answers
1
makhdoom ghaya asked Jul 25, 2016
2,702 views
UGC NET CSE | December 2014 | Part 3 | Question: 10
Let $R = ABCDE$ is a relational scheme with functional dependency set $F = \left\{A \rightarrow B, B \rightarrow C, AC \rightarrow D\right\}$. The attribute closures of $A$ and $E$ are $ABCD, \phi$ $ABCD, E$ $\Phi, \phi$ $ABC, E$
Let $R = ABCDE$ is a relational scheme with functional dependency set $F = \left\{A \rightarrow B, B \rightarrow C, AC \rightarrow D\right\}$. The attribute closures of $...
User Avatar
2 votes
2 votes
2 answers
2
makhdoom ghaya asked Jul 28, 2016
3,317 views
UGC NET CSE | December 2014 | Part 3 | Question: 38
How to express that some person keeps animals as pets?
How to express that some person keeps animals as pets?
User Avatar
2 votes
2 votes
1 answer
3
makhdoom ghaya asked Jul 24, 2016
3,174 views
UGC NET CSE | December 2014 | Part 3 | Question: 09
_________ rules used to limit the volume of log information that has to be handled and processed in the event of system failure involving the loss of volatile information. Write-ahead log Check-pointing Log buffer Thomas
_________ rules used to limit the volume of log information that has to be handled and processed in the event of system failure involving the loss of volatile information...
User Avatar
Link Copied!