Relational Database Management System (RDBMS) Question:
Download Job Interview Questions and Answers PDF
What do you understand by dependency preservation?
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.
((?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 Question | Next Question |
What are the different types of JOIN operations? | How can you find the minimal key of relational schema? |