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)