Technical Discussion :: DBMS
Home > Technical Interview Q&A > DBMS > Discussion
58 / 143
What is join dependency and inclusion dependency?
Answer:
Join Dependency:
A Join dependency is a generalization of multivalued dependency. A JD {R1, R2... Rn} is said to hold over a relation R if R1, R2, R3, ..., Rn is a lossless-join decomposition of R . There is no set of sound and complete inference rules for JD.
Inclusion Dependency:
An Inclusion Dependency is a statement of the form that some columns of a relation are contained in other columns. A foreign key constraint is an example of inclusion dependency.
Asked In ::
Anuradha M
23 Feb, 2019 5:07 AM
Join Dependency:
A Join dependency is a generalization of multivalued dependency. A JD {R1, R2... Rn} is said to hold over a relation R if R1, R2, R3, ..., Rn is a lossless-join decomposition of R . There is no set of sound and complete inference rules for JD.
Inclusion Dependency:
An Inclusion Dependency is a statement of the form that some columns of a relation are contained in other columns. A foreign key constraint is an example of inclusion dependency.
A Join dependency is a generalization of multivalued dependency. A JD {R1, R2... Rn} is said to hold over a relation R if R1, R2, R3, ..., Rn is a lossless-join decomposition of R . There is no set of sound and complete inference rules for JD.
Inclusion Dependency:
An Inclusion Dependency is a statement of the form that some columns of a relation are contained in other columns. A foreign key constraint is an example of inclusion dependency.