1 votes 1 votes please explain the question Databases rdbms database-normalization + – ajay_rajpurohit asked Oct 4, 2021 ajay_rajpurohit 385 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes (C) is correct. R1(ABC) with dependency {AB → C, C → A} and R2(CDA) with dependency {C → A, C → D} Therefore, R1 is not BCNF decomposition because of C → A dependency. Aashay kaurav answered Oct 6, 2021 Aashay kaurav comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes Option C will be the answer. if we decompose into CD, CA and ABC to make it into BCNF then will get lossy decomposition due to the common attributes AC is not the key. Varun Raj Akula answered Mar 11, 2022 Varun Raj Akula comment Share Follow See all 0 reply Please log in or register to add a comment.