Which normal form is considered as adequate for usual database design?
2013
Which normal form is considered as adequate for usual database design?
- A.
2NF
- B.
3NF.
- C.
4NF
- D.
5NF
Attempted by 101 students.
Show answer & explanation
Correct answer: B
For usual database design, Third Normal Form (3NF) is considered adequate. It eliminates transitive dependencies while avoiding the complexity of higher normal forms like 4NF or 5NF, which are only needed for rare cases. This balance ensures data integrity without unnecessary performance overhead.
A video solution is available for this question — log in and enroll to watch it.