R(A, B, with productions {A –>B, B –> A, AB –> C }
A. 1, 2 and 3 are in 3NF and 4 is in BCNF
B. 1 and 2 are in BCNF and 3 and 4 are in 3NF
C. All are in 3NF
D. All are in BCNF
Answer:A
R(A, B, with productions {A –>B, B –> A, AB –> C }
A. 1, 2 and 3 are in 3NF and 4 is in BCNF B. 1 and 2 are in BCNF and 3 and 4 are in 3NF C. All are in 3NF D. All are 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. 4. Which one is based on multi-valued dependency: