- Are the following relations in BCNF? 3NF? (if R is notin BCNF, decompose it to BCNF; if R is not in 3NF, decompose it to3NF)
- R(X,Y, Z,T,V): XY->Z, Y->T, Z->V
- R(X,Y,Z,T): X->Y, Y->Z, Z->T
- R(A,B,C): AB->C, B->A, C->B
- R(ABCD): BD->C, AB->D, AC->B, BD->A
- R(ABCD): AD->C, CD->B, BD->C
- R(ABCD): A->C, B->A, A->D, AD->C
- R(ABCD): A->D, C->A, D->B, AC->B
- R(XYZT): XYT->Z, ZT->X, XZ->Y, XZ->T
- R(XYZT): XY->Z, XYT->Z, XYZ->T, XZ->T
- R(XYZT): YT->Z, XY->T, XZ->Y, YT->X
- R(XYZT): YZ->X, XT->Z, ZT->Y, YT->Z
Expert Answer
An answer will be send to you shortly. . . . .