GATE | CS | 2002 | Databases | Normal Forms | Question 49 (original) (raw)

• DSA
• Practice Problems
• C
• C++
• Java
• Python
• JavaScript
• Data Science
• Machine Learning
• Courses
• Linux
• DevOps

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).

Share your thoughts in the comments

GeeksforGeeks