Question: 3 . 3 NF Consider a relation schema R with attributes ABCDEF with functional dependencies S: S = { AB - > BCDE, C -
NF Consider a relation schema R with attributes ABCDEF with functional dependencies S:
S AB BCDE, C D CDF AD DE C CD E
a Compute a canonical cover for S In your final answer, put the FDs into alphabetical order.
b Using the canonical cover from part a employ the NF synthesis algorithm to obtain a losslessand dependencypreserving decomposition of relation R into a collection of relations that are in NF
c State which of your decomposited relations are in BCNF
d List all candidate minimal keys for 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
