For designing a normal RDBMS, which of the following normal forms is considered adequate?

Asked In: BPSC TRE 3.0

Options

  • A. 4NF
  • B. 3NF
  • C. 2NF
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. 3NF

Detailed Explanation

  • Third Normal Form (3NF): Is generally considered adequate for designing a conventional relational database.
  • It reduces data redundancy and prevents common insertion, deletion and update anomalies.
  • Higher normal forms such as BCNF and 4NF may be required for more complex dependencies.