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

Discussion

Which normal form is considered adequate for normal relational database design?

  • A.2NF
  • B.5NF
  • C.4NF
  • D.3NF

Answer: D

Correct answer: 3NF

Third normal form removes both partial and transitive dependencies and can always be reached without losing any functional dependency, which is why it is the normal form ordinarily aimed at. BCNF is stronger but may not be dependency preserving, and 4NF and 5NF address problems that arise less often.

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

Post your comment

Please log in or register to post a comment.