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

Discussion

Dependency preservation is not guaranteed in

  • A.BCNF
  • B.3NF
  • C.PJNF
  • D.DKNF

Answer: A

Correct answer: BCNF

Every relation can be decomposed into 3NF while keeping all its functional dependencies, but a decomposition into BCNF may not be able to preserve them all. That is the one guarantee BCNF gives up in exchange for removing every remaining redundancy.

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

Post your comment

Please log in or register to post a comment.