2NF Normal Form

  • To be in second normal form,
    • A relation must be in first normal form.
    • No non-prime attribute should be partially dependent on Candidate Key(Part of a candidate key and not as a whole).

R( A, B, C, D)

FD = { AB → CD, B → C }

Prime Attributes & Candidate Kets: AB

Non Prime Attributes : CD

So the 2NF of Relation R will be

R1(ABD) and R2(BC)

Reference :

Example3 – Part of a candidate key is to be considered for partial dependency

Leave a Comment