260 views
0 votes
0 votes
I have a small doubt regarding, determining the highest normal form category, for 2NF as per the rule we know, that, for the given candidate key, no proper subset of candidate key should determine non prime key.

Consider the example here, for Relation R(A,B,C,D,E,F). FD’s is {AB → CD , CD → EF, BC → DEF, D → B and CE → F}

so from FD we know that: AB is an candidate key, but my question is BC → DEF is violating 2NF principle as B is part of candidate key, so why above Relation is consider as in 2NF.

Thankyou very much in advance for clearing my doubt. #DBMS #Gate

1 Answer

Related questions

1 votes
1 votes
0 answers
1
0 votes
0 votes
2 answers
2
ramakrushna asked Dec 22, 2021
446 views
Consider the following schedule S:S: R3(A), W2(A), R1(A), W3(A), W1(A);The possible number of view serializable schedules of the schedule S (other than S) are _____Can so...
0 votes
0 votes
1 answer
3