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?
|
R is in 4NF
|
|
|
R is not in 1NF
|
|
|
R is in 2Nf and not in 3NF
|
|
|
R is in 2NF and 3NF
|
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.
Subscribe
Login
0 Comments