1NF anomalies

• 1NF databases have some problems:

• Most notable:

  • repetition of data
  • to change a department name all tuples of the relation need to be updated since the department name can exist in multiple rows.