medium10 pts · first answer countsdata-modellingnormalisation

Department name in employees

employees(emp_id, name, dept_id, dept_name) has emp_id as the key. dept_name depends on dept_id. What is the 3NF fix?

A.Make (emp_id, dept_id) the composite primary keyB.Add a UNIQUE constraint on the dept_name columnC.Move dept_name to a departments table keyed by dept_idD.Copy dept_name into every table that uses dept_id

Discussion 0

Join free to post in the discussion.

Department name in employees

Discussion 0

Related questions