What does the BCNF decomposition algorithm do? – McqOptions

MCQOPTIONS

1.	What does the BCNF decomposition algorithm do?
A.	States a method to decompose a relation satisfying BCNF
B.	States a method for joining two relations satisfying BCNF
C.	States a method to decompose a relational schema such that there are no multiple occurrences
D.	None of the mentioned
Answer» B. States a method for joining two relations satisfying BCNF

Discussion

No Comment Found

Related MCQs

Which of the following normal forms does not exist?
State true or false: If a relational schema is in _______ NF and A is a subset of R and B is also a subset of R then it is that A is a superkey is a trivial multi values dependency.
The _______ is a set of all functional and multi values dependencies implied by a set of functional dependencies
STATE_TRUE_OR_FALSE:_IF_A_RELATIONAL_SCHEMA_IS_IN_________NF_AND_A_IS_A_SUBSET_OF_R_AND_B_IS_ALSO_A_SUBSET_OF_R_THEN_IT_IS_THAT_A_IS_A_SUPERKEY_IS_A_TRIVIAL_MULTI_VALUES_DEPENDENCY.?$
Which of the following normal forms does not exist?$
The _______ is a set of all functional and multi values dependencies implied by a set of functional dependencie?
Functional dependencies are sometimes referred to as ________
Multi valued dependencies are also called as __________
State true or false: Most current database systems do not support constraints on materialized view
State true or false: SQL specifies a way of mentioning functional dependencies