in Databases
895 views
3 votes
3 votes
Consider a schema R(A, B, C, D) and functional dependencies {AB → C, C → D, D→ A}. Then the decomposition of R into

R1 (CD), R2 (AC) and R3 (BC) is in
a. 1NF but not 2NF
b. 2NF but not 3NF
c. 3NF but not BCNF
d. BCNF
in Databases
895 views

2 Answers

2 votes
2 votes
Every relation with 2 attributes is in BCNF.

Thus, option D

1 comment

is every binary relation also in further higher normal forms like in  4nf  ,5nf
0
0
0 votes
0 votes
After decomposition , Each relation has two attributes.
So it is in BCNF, but Dependency is not preserved.