edited by
496 views
1 votes
1 votes
Find the highest normal form.

AB - - > CE

E - - >AB

C-->D

Doubt

AB, E are the candidate key.

The answer given is 2NF

In 2NF, there should be no partial dependency which is

PRIME ATTRIBUTE - - >NON PRIME ATTRIBUTE

But it is there in AB-->CE, I think CE is non prime attribute.

Or bcoz of E we consider them as prime attribute.
edited by

1 Answer

0 votes
0 votes
Here, AB is the candidate key so, prime members are A and B.

The key itself should not be considered as a prime attribute as per the definition of the prime attribute.

Here, C-->D is Non-prime --> Non-prime which is a transitive dependency. So the highest normal form will be 2NF.

Related questions

0 votes
0 votes
1 answer
2