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 :

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