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 }
a) i, ii and iii are in 3NF and iv is in BCNF
b) i and ii are in BCNF and iii and iv are in 3NF
c) All are in 3NF
d) All are in BCNF

Answer: d
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.