Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the relation R = {A, B, C, D, E, F, G, H, I,J} and the set of functional dependencies F = { {A, B}
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) 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 R into 2NF. (10 marks)
(e) Decompose R into BCNF. (10 marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started