Consider the following relation E(C, S, T, R, G)with the following conditions: C
ID: 3610622 • Letter: C
Question
Consider the following relation E(C, S, T, R, G)with the following conditions: CàT, STàR,TRàC, SCàG Assume we are givena decomposition, TRS, CTR, SCG. Is the decomposition in 3NF?Justify your answer. Consider the following relation E(C, S, T, R, G)with the following conditions: CàT, STàR,TRàC, SCàG Assume we are givena decomposition, TRS, CTR, SCG. Is the decomposition in 3NF?Justify your answer. Assume we are givena decomposition, TRS, CTR, SCG. Is the decomposition in 3NF?Justify your answer.Explanation / Answer
Xis superkey of A , or
Ais a member of at least one key of R