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 Databases databases decomposition database-normalization + – sanyam53 asked Jan 11, 2017 sanyam53 882 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
2 votes 2 votes Every relation with 2 attributes is in BCNF. Thus, option D Sushant Gokhale answered Jan 14, 2017 Sushant Gokhale comment Share Follow See 1 comment See all 1 1 comment reply Sanjay Sharma commented Apr 26, 2017 reply Follow Share is every binary relation also in further higher normal forms like in 4nf ,5nf 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes After decomposition , Each relation has two attributes. So it is in BCNF, but Dependency is not preserved. Arnab Bhadra answered May 24, 2017 Arnab Bhadra comment Share Follow See all 0 reply Please log in or register to add a comment.