For designing a normal RDBMS which of the following normal form is considered…

2026

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

  1. A.

    2NF

  2. B.

    5NF

  3. C.

    4NF

  4. D.

    3NF

Attempted by 300 students.

Show answer & explanation

Correct answer: D

Standard database design theory typically considers Third Normal Form (3NF) as the adequate target for most relational database management systems. While higher forms like 4NF and 5NF exist, they are reserved for specific complex scenarios rather than general design adequacy. Second Normal Form (2NF) is often insufficient to eliminate transitive dependencies effectively.

Explore the full course: Up Lt Grade Assistant Teacher 2025