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?
- A.
4NF
- B.
2NF
- C.
More than one of the above
- D.
3NF
- 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.