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}{C},{A}{D,E},{B}{F},{F}{G,H},{D}{1,J}}. 1) Proof {A}{D,J} holds by using inference rules. (10 marks) 2) Whether {A,B,D} is
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}}. 1) Proof {A}{D,J} holds by using inference rules. (10 marks) 2) Whether {A,B,D} is a super key? Whether {A,B,E} is a candidate key? Why? (10 marks) 3) Whether {B,C} is a super key? Whether {B,C} is a candidate key? Why? (10 marks) 4) Decompose R into 2NF. (10 marks) 5) 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