2NF Anomalies

• Assume that Emp-Dpt → Emp-Hrly-Rate

  • We cannot Set the Emp-Hrly Rate until an employee is added with that Dpt
  • We cannot delete the last employee of a department without losing the department's hourly rate.
  • If the department hourly rate changes the entire table must be edited and all employees working in that department need to be updated.