Aspire Faculty ID #17003 · Topic: AMU MCA 2022 · Just now
AMU MCA 2022

Consider a relation $R(A,B,C,D)$ with set of functional dependencies $AB \rightarrow CD$ and $D \rightarrow A$. Let $R_1(A,D)$ and $R_2(B,C,D)$ are two decompositions over $R$. Which of the following statement is TRUE?

Solution

The decomposition is lossless (common attribute $D$ determines $A$), but not dependency preserving (FD $AB \rightarrow CD$ is lost).

Previous 10 Questions — AMU MCA 2022

Nearest first

Next 10 Questions — AMU MCA 2022

Ascending by ID
Ask Your Question or Put Your Review.

loading...