Question & Answer: t1. Given R {C , S , J , D , P , Q , V} and set of functional = dependencies FD1: JP -C, FD2: SD -P, FD3: -Sh (Number each candidate key for full credit and show your a) Find key(s) of R. work for cedi…..

t1. Given R {C , S , J , D , P , Q , V} and set of functional = dependencies FD1: JP -C, FD2: SD -P, FD3: -Sh (Number each candidate key for full credit and show your a) Find key(s) of R. work for cedit) b) Decompose R to get R’ in 2NF, 3NF and BCNF. (Use the FD labels given above to identify FDs. Each relation should be shown in the form R# (W, X , Y, Z) . Each relation should show the FDs that hold for that relation. Describe your reasoning clearly) 2NF relations are: