Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 277
|
Relation R is decomposed using a set of functional dependencies, F, and relation S Is decomposed using another set of functional dependencies, G. One decomposition is definitely BCNF, the other is definitely 3NF, but it is not known which is which.
To make a guaranteed identification, which one of the following tests should be used on the decompositions? (Assume that the closure of F and G are available).
|
Lossless-join
|
|
|
BCNF definition
|
|
|
3NF definition
|
|
|
Dependency-Preservation
|
Question 277 Explanation:
Since one decomposition is in 3NF so it will not satisfy the BCNF conditions.Hence BCNF tests should be used on the decompositions.
Correct Answer: B
Question 277 Explanation:
Since one decomposition is in 3NF so it will not satisfy the BCNF conditions.Hence BCNF tests should be used on the decompositions.