If the decomposition is unable to represent certain important facts about the relation, then such a decomposition is called as?
A. Lossless decomposition
B. Lossy decomposition
C. Insecure decomposition
D. Secure decomposition
I got this question in final exam.
Origin of the question is Features of Good Relational Design in portion Relational Database Design of RDBMS
Correct answer is B. Lossy decomposition
Explanation: If the decomposition is unable to represent certain important facts about the relation, then such a decomposition is called as lossy decomposition. Lossy decompositions should be avoided as they result in the loss of data.