Functional-Dependency Theory

Question 1
Marks : +2 | -2
Pass Ratio : 100%
If A→B, A→ C then which of the following is true?
A→BC
A→B
A→C
All of the mentioned
Explanation:
Applying the union rule to the given question, we get, A→BC is true. The other two options are specified in the question itself.
Question 2
Marks : +2 | -2
Pass Ratio : 100%
State true or false: Functional dependencies are transitive
True
False
Explanation:
All functional dependencies are transitive. This is the transitivity rule of Armstrong’s axioms.
Question 3
Marks : +2 | -2
Pass Ratio : 100%
A _________ Fc for F is a set of dependencies such that F logically implies all dependencies in Fc, and Fc logically implies all dependencies in F.
Canonical cover
Complete cover
Canonical dependency
Canonical clause
Explanation:
A Canonical cover Fc for F is a set of dependencies such that F logically implies all dependencies in Fc, and Fc logically implies all dependencies in F. In Fc, no functional dependency should contain an extraneous attribute and each left side of functional dependency should be unique.
Question 4
Marks : +2 | -2
Pass Ratio : 100%
State true or false: Armstrong’s axioms allow us to generate all F+ for any given F
True
False
Explanation:
Armstrong’s axioms allow us to generate all F+ for any given F and hence are called complete.
Question 5
Marks : +2 | -2
Pass Ratio : 100%
We say that a decomposition having the property F’+ = F+ is a __________ decomposition.
Dependency losing
Dependency preserving
Lossless
None of the mentioned
Explanation:
We say that a decomposition having the property F’+ = F+ is a dependency preserving decomposition.
Question 6
Marks : +2 | -2
Pass Ratio : 100%
Armstrong axioms are called sound because?
They are expensive
They cannot generate correct functional dependencies
They allow us to generate the complete closure
They cannot generate incorrect functional dependencies
Explanation:
Armstrong’s axioms are called as sound axioms because they do not generate incorrect functional dependencies.
Question 7
Marks : +2 | -2
Pass Ratio : 100%
A functional dependency f on R is _______ by a set of functional dependencies F on r if every instance of r(R) that satisfies f also satisfies F.
Logically Defined
Logically Derived
Logically implied
None of the mentioned
Explanation:
Given a set F of functional dependencies on a schema, we can prove that certain other functional dependencies also hold on that schema. We say such FDs are logically implied by F. A functional dependency f on R is logically implied by a set of functional dependencies F on r if every instance of r(R) that satisfies F also satisfies f.
Question 8
Marks : +2 | -2
Pass Ratio : 100%
If a functional dependency is reflexive, B is a subset of A and A is the set of attributes, then
B→A holds
A→B holds
AB→C holds
None of the mentioned
Explanation:
If a functional dependency is reflexive, B is a subset of A and A is the set of attributes, then A→B holds. This is called the reflexivity rule of Armstrong’s axioms.
Question 9
Marks : +2 | -2
Pass Ratio : 100%
If F is a set of functional dependencies, then the closure of F is denoted by?
F*
Fo
F+
F
Explanation:
If F is a set of functional dependencies, then the closure of F is denoted by F+. It is the set of all functional dependencies logically implied by F.
Question 10
Marks : +2 | -2
Pass Ratio : 100%
If B is an attribute and A→B, Then B is said to be ________ by a.
Logically implied
Functionally implied
Logically determined
Functionally determined
Explanation:
If B is an attribute and A→B, Then B is said to be functionally determined by a.