closed by
552 views
1 votes
1 votes
closed as a duplicate of: GATE CSE 2002 | Question: 2.24
Relation R is decomposed using a set of functional dependency F, and relation S is decomposed using another set of functional dependencies G. One decomposition is definitely BCNF, the other is definitely 3NF, but is not known to make a guaranteed identification. Which of the following tests should be used for the decomposition? (Assume that closure of F and G are available)  

A. Dependency preservation

B. BCNF definition

C. Both (A) and (B)

D. 3NF definition

I think D should be most appropriate answer but answer key has given it B.
closed by

Related questions

2 votes
2 votes
2 answers
3
gatecrack asked Dec 10, 2018
615 views
Is minimal set of functional dependency for a functional dependency set is always unique???
0 votes
0 votes
1 answer
4
Raghav Khajuria asked Oct 5, 2018
905 views
Difference between composite and compound key??