4. Normalization Given a relational R with a function dependency: F-X-Y Answer the following questions: a. (2pt) If X is a candidate key and Y is non-prime attribute, select the right

answer: A. R is not in 2NF B. R is in 2NF, but not 3NF C. R is in 3NF, but not BCNF D. R is in BCNF b. (2pt) If X is a subset of candidate key and Y is prime attribute, select the right answer: A. R is not in 2NF B. R is in 2NF, but not 3NF C. R is in 3NF, but not BCNF D. R is in BCNF c. (2pt) If X is a subset of Candidate Key and Y is non-prime attribute, select the right answer A. R is not in 2NF B. R is in 2NF, but not 3NF C. R is in 3NF, but not BCNF D. R is in BCNF d. (2pt) If X is non-prime attribute and Y is non-prime attribute, select the right answer: A. R is not in 2NF B. R is in 2NF, but not 3NF C. R is in 3NF, but not BCNF D. R is in BCNF e. Given a relation R (A, B, C, D, E, F) in 1 NF and its functional dependency set: F-{A CF, E-D, CDB)