Question 3

Given a relational R with a function dependency: F = X →Y

Answer the following questions:

1. If X is non-prime attribute 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

2. 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

3. 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

4. If X is Candidate Key attribute 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