0 votes 0 votes Decompose following relations into 2NF, 3NF, BCNF and state what are relations failed to decompose into BCNF and dependency preserving decomposition. 1)R(ABCDE) {AB→C, DE→C, B→D} 2)R(ABCDE) {AB→C, C→D, D→B, D→E} 3)R(ABCDE) {A→BC, CD→E, B→D, E→A} talha hashim asked Oct 7, 2018 talha hashim 566 views answer comment Share Follow See all 7 Comments See all 7 7 Comments reply Show 4 previous comments Manas Mishra commented Oct 9, 2018 reply Follow Share @Basant how can table in Q1 be decomposed into R1(DEC) ???? 0 votes 0 votes Manas Mishra commented Oct 9, 2018 reply Follow Share I think the table in Q1 will be decomposed into R1(ABC) , R2(BD) , R3(ABE) @srestha mam correct me if wrong 0 votes 0 votes Manas Mishra commented Oct 9, 2018 reply Follow Share in Q3 BCNF satisfied bt fd is not preserved 0 votes 0 votes Please log in or register to add a comment.