Which normal form removes transitive dependency
A relation Student(roll_no, name, dept_id, dept_name) has:
roll_no → dept_iddept_id → dept_name
and therefore roll_no → dept_name transitively.
Which normal form does this relation violate?
A relation Student(roll_no, name, dept_id, dept_name) has:
roll_no → dept_iddept_id → dept_nameand therefore roll_no → dept_name transitively.
Which normal form does this relation violate?