Question: Functional Dependencies and Normalization ( 2 0 Points ) Consider the following relation R ( A , B , C , G , H ,

Functional Dependencies and Normalization (20 Points)
Consider the following relation R(A,B,C,G,H,I) and functional dependencies F that hold over R.
F ={A -> B
A -> C
C,G -> H
C,G -> I
B -> H}
Question 1.7(4 Points). Determine all candidate keys of R.
Question 1.8(6 Points). Compute the canonical cover of F.
Question 1.9(4 Points). Determine in which normal forms relation R is? Provide justification for your answer.
Question 1.10(6 Points). Apply the 3NF decomposition algorithm to relation R.

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 Finance Questions!