249 views
0 votes
0 votes
if R has only one candidate key, it's highest form is in:

a. 2NF

b.3NF

c.BCNF

d.None of these

1 Answer

Best answer
2 votes
2 votes
Eventhough it has only one candidate key , the relation may contain a transitive dependency so the highest normal form will be 2NF

Eg:

R(ABCD)

A->BCD

B->C
selected by

Related questions

0 votes
0 votes
1 answer
1
Mrityudoot asked Jan 12
144 views
Isn’t F$^{+}$ minimal cover? If C $\rightarrow$ A is already there, then why does augmented CD $\rightarrow$ A needs to be?
0 votes
0 votes
1 answer
2
0 votes
0 votes
1 answer
3