📝 Question
#1237
Consider the relation given below and ind the maximum normal form applicable to them i. R(A, B) WITH productions { A --> B } ii. R(A, B) WITH productions { B --> A } iii. R(A, B) WITH productions {A —> B, B --> A } iv. R(A, B, C) WITH productions {A -->B, B --> A, AB --> C }
✓
Correct Answer
A. i, ii and iii are in 3NF and iv is in BCNF
💡
Explanation
One of the more desirable normal forms that we can obtain is Boyce–Codd normal form (BCNF). It eliminates all redundancy that can be discovered based on functional dependencies.
⌨️ Press
A
B
C
D
to select