Database-Management-System

Question 438

In relational database, if a relation R is in BCNF, then which of the following is true about relation R?

A	R is in 4NF
B	R is not in 1NF
C	R is in 2Nf and not in 3NF
D	R is in 2NF and 3NF

Database-Management-SystemNormalizationUGC NET June-2019 CS Paper-2

Question 438 Explanation:

If a relation R is in BCNF then R will be in 1NF, 2NF and 3NF. Since the requirement of a BCNF relation is that the left hand side of each functional dependency should be a super key because of this, neither there will be a partial dependency in relation R nor there will be transitive dependency.

Correct Answer: D

Question 438 Explanation:

If a relation R is in BCNF then R will be in 1NF, 2NF and 3NF. Since the requirement of a BCNF relation is that the left hand side of each functional dependency should be a super key because of this, neither there will be a partial dependency in relation R nor there will be transitive dependency.