What do you understand by dependency preservation?
Submitted by: AdministratorGiven 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.
Submitted by: Administrator
((?R1(F)) U … U (?Rn(F)))+ = F+
if decomposition is not dependency preserving, then some dependency is lost in the decomposition.
Submitted by: Administrator
Read Online RDBMS Job Interview Questions And Answers
Top RDBMS Questions
☺ | What is VDL (View Definition Language)? |
☺ | Difference between controlled and uncontrolled redundancy? |
☺ | What is RDBMS KERNEL? |
☺ | What is SDL (Storage Definition Language)? |
☺ | What is 5NF? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Sybase Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |