retagged by
595 views
0 votes
0 votes

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?

  1. A and B contain prime and non-prime attributes respectively and R is in 2NF as highest normal form
  1. A and B contain prime and non-prime attributes respectively and R is in 3NF as highest normal form
  1. A and B contain non-prime and prime attributes respectively and R is in 3NF as highest normal form.
  1. 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$?

 

retagged by

1 Answer

0 votes
0 votes
just hv to think tht in option C,

if RHS is prime attributes so it will be 3NF (in definition of 3NF)

while if we check other options then there is no surity that it’s given normal form is r8 or not .

Related questions

1 votes
1 votes
1 answer
1
ashunimbz asked Mar 30, 2019
430 views
Do we need to find closure of functional dependencies of original relation to check whether the decomposed tables are in 2NF .I know that we have to do the above process ...
0 votes
0 votes
2 answers
2
SKMAKM asked Aug 30, 2022
494 views
I am getting ans 6 and given ans is 8
2 votes
2 votes
2 answers
3
gatecrack asked Dec 10, 2018
581 views
Is minimal set of functional dependency for a functional dependency set is always unique???
0 votes
0 votes
1 answer
4
Raghav Khajuria asked Oct 5, 2018
882 views
Difference between composite and compound key??