Question

We say that a decomposition having the property F’+ = F+ is a __________ decomposition.

(a) Dependency losing

(b) Dependency preserving

(c) Lossless

(d) None of the mentioned

I got this question at a job interview.

I'd like to ask this question from Functional-Dependency Theory in division Relational Database Design of RDBMS

Answer 1

Correct answer is (b) Dependency preserving

To explain I would say: We say that a decomposition having the property F’+ = F+ is a dependency preserving decomposition.