The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is

Related MCQs

• Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is
• Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
• Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
• Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
• Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
• Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is
• There are two functional dependencies with the same set of attributes on the left side of the arrow: A->BC A->B This can be combined as
• A relation is in this form if it is in BCNF and has no multivalued dependencies:
• Consider a relation R(A,B,C,D,E) with the following functional dependencies: ABC -> DE and D -> AB The number of superkeys of R is:
• The normal form which satisfies multivalued dependencies and which is in BCNF is