GATE | CS | 2002 | Databases | Normal Forms | Question 49

Last Updated :
Discuss
Comments

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 closures of F and G are available).

Dependency-preservation

Lossless-join

BCNF definition

3NF definition

This question is part of this quiz :

Database Design(Normal Forms),GATE-CS-2002
Tags:
DBMS Quiz
GATE
DBMS
GATE CS
Share your thoughts in the comments
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy