Relational Database Management System (RDBMS) Question:
Download Questions PDF

What is join dependency and inclusion dependency?

Answer:

Join Dependency:
A Join dependency is 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.

Download RDBMS Interview Questions And Answers PDF

Previous QuestionNext Question
What is durability in DBMS?What is meant by query optimization?