db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Normal form

emp_dept repeats dept_name on every employee row, so renaming a department means many updates. Move department facts to their own table.

task

emp_dept repeats dept_name on every employee row. Split it into dept(dept_id, dept_name) and emp(emp_id, emp_name, dept_id) with keys and drop emp_dept.

hints