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,
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
Step: 1
Get Instant Access with AI-Powered 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