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

A database of research articles in a journal uses the following schema. (VOLUME, NUMBER, STARTPGE, ENDPAGE, TITLE, YEAR, PRICE) The primary key is (VOLUME, NUM...
#128 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
Given the following two statements: S1: Every table with two single-valued attributes is in 1NF, 2NF, 3NF and BCNF. S2: AB → C, D → E, E → C is...
#1201 MCQ

Related Topics

No tags found

Unique Visitor Count

Total Unique Visitors

Loading......

Question Options

Contributed by: