Machine-translated by Google. Questions are authored in English.
Top

Discussion

What are the desirable properties of a decomposition

  • A.Partition constraint.
  • B.Dependency preservation.

  • C.Redundancy.
  • D.Security.

Answer: B

Correct answer: Dependency preservation.

A decomposition should be lossless - the original relation must be recoverable by joining the pieces - and dependency preserving, so that every functional dependency can still be enforced on a single one of the resulting relations. Redundancy is what decomposition removes, not a property it should have.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.