Question: 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,

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} -> {1,J}}. (a) Proof{A}->{E,J} holds by using inference rules. (10 marks) (b) Whether {A,B,C) is a super key? Whether {A,B,C} is a candidate key? Why? (10 marks) (c) Whether {A,F} is a super key? Whether {A,F} is a candidate key? Why? (10 marks) (d) Decompose Rinto 2NF. (10 marks) (e) Decompose Rinto BCNF. (10 marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
