Question: Database System Consider the relation R = { A , B , C , D , E , F , G , H , I,

Database System
Consider the relation R ={A, B, C, D, E, F, G, H, I, J} and the set of functional
dependencies F ={{A, D}->{C},{A}->{B, E},{D}->{F},{F}->{G, H},{B}->{I, J}}.
1) Prove that {A}->{B, J} holds by using inference rules.
2) Is {A, B, D} a superkey? Is {A, D, E} a candidate key? Why?
3) Is {C, D} a superkey? Is {C, D} a candidate key? Why?
4) Decompose R into 2NF.
5) Decompose R into BCNF.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!