1NF to 2NF

• Identify the primary key for the 1NF relation.
• Identify the functional dependencies in the relation.
• If partial dependencies exist on the primary key remove them by placing them in a new relation along with a copy of their determinant. (The part of the primary key they depend on)

• Step1:Write Each Key Component on a Separate Line. 

  • Write each key component on separate line, then write original (composite) key on last line.
  • Each component will become key on last line

• Step2:Assign Corresponding Dependent Attributes

  • Determine those attributes that are dependent on other attributes
  • At this point most anomalies have been eliminated