Question

1. What is desired when decomposing relation?

a. Dependencies are preserved and there is no loss in information

b. New dependencies are created to replace the old ones

c. The data with anomalies is removed and dependencies may be preserved

d. all dependencies are removed and data anomalies are preserved.

Answer 1

The correct option is A.

Decomposing relation is a phenomenon in which we are breaking the single relation into two or more relations.

It has the properties of the Dependency Preserving in which at least one decomposed table must satisfy every dependency, So due this properties option B and D becomes wrong.

Also, option C is not true because the dependencies may be preserved is mentioned which is not following the properties of the decomposition of relation.

Lastly we have only option A left in which dependencies are preserved and no loss in information  is mentioned so it is the best and correct option among all the four options.