If the decomposition is unable to represent certain important

if-the-decomposition-is-unable-to-represent-certain-important

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.