Consider the relation R (A, I, C, T, E) and the FD set: TE -> C I-> E AC-> T CT

Question

Consider the relation R (A, I, C, T, E) and the FD set: TE -> C I-> E AC-> T CT -> A (a) Computer all the keys of this relation. Justify your answer. (b) Identify prime attribute(s) and non-prime attribute(s). (c) Is relation R in 1NF, 2NF, 3NF, or BCNF? Justify your answer. (d) Consider the decomposition of AICTE to ITE, ACT 1. Is it lossless? Justify your answer. 2. Is it dependency preserving? Justify your answer.

Explanation / Answer

b) R relation is in 1NF : =>>>Reason ::All attributes are simple and single R relationis not in 2NF : =>>>Reason :: partial functional dependency

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---