Question: Functional Dependencies and Normalization ( 2 0 Points ) Consider the following relation R ( A , B , C , G , H ,
Functional Dependencies and Normalization Points
Consider the following relation RABCGHI and functional dependencies F that hold over R
F A B
A C
CG H
CG I
B H
Question Points Determine all candidate keys of R
Question Points Compute the canonical cover of F
Question Points Determine in which normal forms relation R is Provide justification for your answer.
Question Points Apply the NF decomposition algorithm to relation R
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
