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$?