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.
OOps! You are currently offline.