Consider the relation R = {A, B, C, D, E, F, G, H, I,J} and the...

Transcribed Image Text:

Consider the relation R = {A, B, C, D, E, F, G, H, I,J} and the set of functional dependencies F = {{A, B}{C}, {A} {D, E}, {B} {F}, {F}{G, H}, {D} {I, J} }. (a) Prove {A}{E, I} holds by using inference rules. (10 marks) (b) Whether {A, B, F} is a super key? Whether (A,B,F} is a candidate key? Why? (10 marks) (c) Whether {A, D} is a super key? Whether {A, D} is a candidate key? Why? (10 marks) (d) Decompose R into 2NF. (10 marks) Consider the relation R = {A, B, C, D, E, F, G, H, I,J} and the set of functional dependencies F = {{A, B}{C}, {A} {D, E}, {B} {F}, {F}{G, H}, {D} {I, J} }. (a) Prove {A}{E, I} holds by using inference rules. (10 marks) (b) Whether {A, B, F} is a super key? Whether (A,B,F} is a candidate key? Why? (10 marks) (c) Whether {A, D} is a super key? Whether {A, D} is a candidate key? Why? (10 marks) (d) Decompose R into 2NF. (10 marks)

Answer rating: 100% (QA)

a To prove A E I using inference rules we can use the following steps 1 Given A D E and D I we can i... View the full answer