Consider a relation R with more than two attributes. Let A and B are sets of attributes from R and A$\cap$B = $\phi$. Functional dependency A → B holds on R. Which one of the following can be a correct possible situation for R?

- A and B contain prime and non-prime attributes respectively and R is in 2NF as highest normal form

- A and B contain prime and non-prime attributes respectively and R is in 3NF as highest normal form

- A and B contain non-prime and prime attributes respectively and R is in 3NF as highest normal form.

- A and B contain prime attributes and R is in BCNF as highest normal form.

The question in from made easy test series.

The answer is option C.

**Doubt 1**: In the question it is given that functional dependency A → B holds on R, so do we need to assume that all the functional dependencies holding on R are of type A → B such that A$\cap$B = $\phi$?