For designing a normal RDBMS, which of the following normal forms is…

2023

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

  1. A.

    4NF

  2. B.

    2NF

  3. C.

    More than one of the above

  4. D.

    3NF

  5. E.

    None of the above

Attempted by 593 students.

Show answer & explanation

Correct answer: D

For designing a normal RDBMS, the third normal form (3NF) is considered adequate because it eliminates transitive dependencies while maintaining data integrity and minimizing redundancy. In 3NF, all non-key attributes must depend only on the primary key, not on other non-key attributes. This ensures that the database is free from update anomalies and supports efficient data retrieval. While higher normal forms like 4NF or BCNF offer additional benefits, 3NF provides a practical balance between normalization and performance for most real-world applications. Therefore, 3NF is widely accepted as the standard for normal RDBMS design.

Explore the full course: Up Lt Grade Assistant Teacher 2025