Assume the following set of functional dependencies hold for therelation R(U,V,X,Y,Z):
UV ? X
YZ ? X
V ? Y
(a) List all the candidate keys.
(b) Is it in BCNF? Explain why or why not. If it is not,normalize it into a set of relations to be in BCNF. Show your workwhile indicating which dependency you are applying in eachdecomposition.
(c) Is it in 3NF? Explain why or why not. If it is not,normalize it into a set of relations to be in 3NF. Show your workwhile indicating how you obtained each decomposition. Note that theset of functional dependencies given in the problem is a
PayPal Gateway not configured
PayPal Gateway not configured