Question: 6 . Consider the following relation R and its set of functional dependencies: R = ( A , B , C , D , E
Consider the following relation R and its set of functional dependencies:
R A B C D E
FDs A BC CD E B D E A
a What are the different candidate keys in this relation?
Marks
b Is this relation in BCNF If yes how, if not then make it compliant with the BCNF
Marks
c Is this relation in NF If yes how, if not then make it compliant with the NF
Mark
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
