Computer Sciences > Gate 2020 > Normalization
Consider a relational table R that is in 3NF, but not in BCNF. Which one of the following statements is TRUE ?
A
R has a nontrivial functional dependency X→A, where X is not a superkey and A is a prime attribute.
B
R has a nontrivial functional dependency X→A, where X is not a superkey and A is a non-prime attribute and X is not a proper subset of any key.
C
R has a nontrivial functional dependency X→A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.
D
A cell in R holds a set instead of an atomic value.

Correct : a

Similar Questions

Consider the relation R(P, Q, S, T, X, Y, Z, W) with the following functional dependencies.PQ -> X, P -> YX, Q -> Y, Y -> ZWConsider the decomposition of the re...
#1033 MCQ
Consider the relation R(P, Q, S, T, X, Y, Z, W) with the following functional dependencies.PQ -> X, P -> YX, Q -> Y, Y -> ZWConsider the decomposition of the re...
#1033 MCQ
Consider the relation R(P, Q, S, T, X, Y, Z, W) with the following functional dependencies.PQ -> X, P -> YX, Q -> Y, Y -> ZWConsider the decomposition of the re...
#1033 MCQ

Related Topics

No tags found

Unique Visitor Count

Total Unique Visitors

Loading......
Question Options

Contributed by: