Register

2NF bt not in 3NF

2,505 views
1 1 vote

In option C:  we can write  DB->AC    as   DB->A  and DB->C .  

And clearly DB->C is a partial dependency. how is it in 2NF??

please explain Option D also,how is that the answer?

1 Answer

Voting & Accepting an answer helps improve the community
← Previous · OSPF routersNext → · Fermat's theorem
← Previous in category · Conflict equivalentNext in category → · Conflict Serializabl...
Position:
Show:

Related questions

0 0 votes
1 1 answer
282
282 views
Prashant 4 asked Nov 15, 2025
282 views
19 If table R has only one candidate key, then wh of the following is always true? (a) R is in 2NF, but is not in 3NF (b) R is in 3NF, it is also in BCNF (c) R is in 2NF, but may not be in 3NF (d) None of these
1 1 vote
2 answers 2 answers
1.9k
1.9k views
Meenakshi Sharma asked Dec 17, 2016
1,919 views
Find out the set of F.D for which R (ABCD) is in 2NF but not in 3NF
Find out the set of F.D for which R (ABCD) is in 2NF but not in 3NF
10 10 votes
1 answers 1 answer
6.4k
6.4k views
Na462 asked May 29, 2018
6,419 views
3NF But Not in BCNF Normal Form
Which of the following statement false of relation $R$ is in $3NF$ but not $BCNF$?Relation $R$ must consist atleast two over-lapped candidate keys.Relation $R$ must consi...
14 14 votes
6 answers 6 answers
21.3k
21.3k views
Shefali asked Sep 17, 2015
21,258 views
3NF But Not in BCNF Normal Form
Consider the following statements.If relation R is in 3NF and every key is simple, then R is in BCNFIf relation R is in 3NF and R has only one key, then R is in BCNFBoth ...