Question

Define Extraneous attributes and Canonical Cover. Given the following set of functional
dependencies, find the canonical cover of it with proper steps:
F= {XP -> YZ, Y -> Z, XP -> Y, XY -> Z}.

Answer 1

Answer:

Explanation:

1. Use the union rule to replace any dependencies in  

      \alpha_{1} \rightarrow \beta_{1} and \alpha_{1} \rightarrow \beta_{2} with \alpha_{1} \rightarrow \beta_{1}\beta_{2}.

   2. Find a functional dependency \alpha \rightarrow \beta with an  

      extraneous attribute either in \alpha or in \beta.

   3. If an extraneous attribute is found, delete it from \alpha \rightarrow \beta.

      until F does not change

plz mark as brainlist