Question

Given the functional dependencies A -> B and B -> C, it can be deduced that:

Group of answer choices

D. B is redundant.

A. C is functionally dependent on A.

B. A and C are independent.

C. A ->C replaces both functional dependencies without loss of information.

Answer 1

Q-> Given the functional dependencies A -> B and B -> C, it can be deduced that:

Options:

A. C is functionally dependent on A.

True, because of transitivity, A -> C can be determined which states C is functionally dependent on A

.

B. A and C are independent.

False, A -> C is a transitive functional dependency.

.

C. A ->C replaces both functional dependencies without loss of information.

False, B is not in resultant functional dependency, which means loss of information.

.

D. B is redundant.

False, it could be redundant but not necessarily.