EssayproSolutions

(Solved) : Following Relations Bcnf 3nf R Bcnf Decompose Bcnf R 3nf Decompose 3nf R X Y Z T V Xy Z Y Q34344972 . . .

5. 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)
   1. R(X,Y, Z,T,V): XY->Z, Y->T, Z->V
   2. R(X,Y,Z,T): X->Y, Y->Z, Z->T
   3. R(A,B,C): AB->C, B->A, C->B
   4. R(ABCD): BD->C, AB->D, AC->B, BD->A
   5. R(ABCD): AD->C, CD->B, BD->C
   6. R(ABCD): A->C, B->A, A->D, AD->C
   7. R(ABCD): A->D, C->A, D->B, AC->B
   8. R(XYZT): XYT->Z, ZT->X, XZ->Y, XZ->T
   9. R(XYZT): XY->Z, XYT->Z, XYZ->T, XZ->T
   10. R(XYZT): YT->Z, XY->T, XZ->Y, YT->X
   11. R(XYZT): YZ->X, XT->Z, ZT->Y, YT->Z

Expert Answer

Answer to Following Relations Bcnf 3nf R Bcnf Decompose Bcnf R 3nf Decompose 3nf R X Y Z T V Xy Z Y Q34344972 . . .