Question: 3 . ( 4 0 points ) Consider a relation schema R 3 ( A , B , C , D , E ) that
points Consider a relation schema RA B C D E that satisfies the set of functional
dependencies FA BC AC BD
points Calculate AC and AE
points Is AB C in F Justify your answer.
points Find the canonical cover Fc of F
points Is R in NF Explain the reason to your answer. If R is not in NF give a
losslessjoin, dependency preserving NF decomposition of 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
