Relational Database Management System (RDBMS) Question:

Download Job Interview Questions and Answers PDF

What do you understand by dependency preservation?

RDBMS Interview Question
RDBMS Interview Question

Answer:

Given a relation R and a set of FDs F, dependency preservation states that the closure of the union of the projection of F on each decomposed relation Ri is equal to the closure of F. i.e.,
((?R1(F)) U … U (?Rn(F)))+ = F+
if decomposition is not dependency preserving, then some dependency is lost in the decomposition.

Download RDBMS Interview Questions And Answers PDF

Previous QuestionNext Question
What are the different types of JOIN operations?How can you find the minimal key of relational schema?