What is join dependency and inclusion dependency?



What is join dependency and inclusion dependency?..

Answer / Janender Kumar

Join Dependency refers to a situation in a relational database where two tables have a functional dependency between their joined attributes. Inclusion Dependency occurs when all of the non-key attributes of one table can be derived from another table through a combination of its key values.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Architecture Interview Questions

What do you mean by Correlated subquery?

1 Answers  


How one call ddl statement using stored procedures in oracle?

1 Answers  


What is the meaning of 3 tier?

1 Answers  


What is 1 NF (Normal Form)?

1 Answers  


How can we call stored procedures inside store procedures?

1 Answers  


What is a Relation Schema and a Relation?

1 Answers  


What is n tier architecture with example?

1 Answers  


What is Domain-Key Normal Form?

1 Answers  


Explain the microsoft sql server delete command? : sql server architect

1 Answers  


What is parallel database architecture?

1 Answers  


What is a Phantom Deadlock?

1 Answers  


Does storing of data in stored procedures increase the access time? Explain?

1 Answers  


Categories