2,166 views
6 votes
6 votes
Every table with two single-valued attributes is in 1NF, 2NF, 3NF and BCNF.    ????

plz  define clearly??

is it true for all the table having more than two attribute??

#refrence gate2014

4 Answers

Best answer
3 votes
3 votes
It will be in bcnf because bcnf says that if we have a functional dependency as A->B then A must be the Super key. So if we have only 2 attributes then definitely one will be key. So 2 possible set of functional dependency are there wither only one should be there { A->B} or this set can be there { A->b, B->A}. Now whatever the case is it will be in BCNF.
selected by
2 votes
2 votes
It is true for any dependency in case of 2 attributes but in case of more than 2, it depends upon the FDs.
2 votes
2 votes
I discussed this question with my teacher.

It's false for more than two attributes.

only two attributes which are single valued : TRUE
two single valued attributes : False
2 votes
2 votes
For a table with two single valued attributes, it is always true.

For the table with more than two single valued attributes, it depends on given functional dependencies. So we can say it's not always true for this case.

Related questions

0 votes
0 votes
1 answer
1
Devil16 asked Sep 17, 2023
255 views
can we consider , proper subset of candidate key union proper subset of another candidate keyas a proper subset of candidate key.
2 votes
2 votes
3 answers
2
Sunnidhya Roy asked Dec 13, 2022
1,966 views
A Relation R is in 3NF and have only 1 Candidate Key(may or may not be composite), then R is in BCNF. True or False??
1 votes
1 votes
0 answers
3
JAINchiNMay asked Dec 1, 2022
402 views
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attributeTrue or false