Home » MCQs » DBMS MCQs » DBMS Types of Dependency MCQs

What is true about Join Dependency?

3. What is true about Join Dependency?

1. An extension of Multivalued Dependencies is Join Decomposition.
2. It is possible to call the join of R1 and R2 over C a join dependency (JD) if they are equal to relation R.
3. Alternatively, R1 and R2 can be written as lossless decompositions of R.
4. All of the above

Answer: D) All of the above

Explanation:

In case of Join Dependency -

1. An extension of Multivalued Dependencies is Join Decomposition.
2. It is possible to call the join of R1 and R2 over C a join dependency (JD) if they are equal to relation R.
3. Alternatively, R1 and R2 can be written as lossless decompositions of R.