1. Engineering
  2. Computer Science
  3. are the following relations in bcnf 3nf if r is...

Question: are the following relations in bcnf 3nf if r is...

Question details
  1. Are the following relations in BCNF? 3NF? (if R is not in BCNF, decompose it to BCNF; if R is not in 3NF, decompose it to 3NF)
    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
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution