Ace Page# 12, Q# 29

Question

Consider the following set of functional dependencies on the relation (ABC), $\{ A \rightarrow B, \: \: AB \rightarrow C, \:\: A \rightarrow BC, \:\: B \rightarrow C\}$.

Find the canonical cover for the above FD set

• A. $\{A \rightarrow BC, B \rightarrow C \}$
• B. $\{A \rightarrow BC, AB \rightarrow C \}$
• C. $\{A \rightarrow BC, A \rightarrow B \}$
• D. $\{A \rightarrow B, B \rightarrow C \}$

Answer 1

Hope this helps