2. Consider the following relation E(C, S, T, R, G) with thefollowing conditions

Question

    2.       Consider the following relation E(C, S, T, R, G) with thefollowing conditions: CàT, STàR, TRàC,SCàG
a)       Assume we are givendecomposition, TRS, CTR, SCG. Is the decomposition in BCNF?Justify your answer.

    2.       Consider the following relation E(C, S, T, R, G) with thefollowing conditions: CàT, STàR, TRàC,SCàG
a)       Assume we are givendecomposition, TRS, CTR, SCG. Is the decomposition in BCNF?Justify your answer.

Explanation / Answer

Here the functional dependency C->T also violates BCNF. so the decomposition should also contain the relation CT.. but the given decomposition is TRS, CTR, SCG...this decompositiondoes not account for the the FD C->T which is violatingBCNF. SO the given decomposition id not a BCNF

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.