Skip to content

Which normal form removes transitive dependency

A relation Student(roll_no, name, dept_id, dept_name) has:

  • roll_no → dept_id
  • dept_id → dept_name

and therefore roll_no → dept_name transitively.

Which normal form does this relation violate?