Add to Chrome
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
A tableEMP(Emp_ID, Dept_ID, Dept_Name) has FD Dept_ID → Dept_Name.
A table
EMP(Emp_ID, Dept_ID, Dept_Name) has FD Dept_ID → Dept_Name.
Which is the best way to
normalize this?
EMP(Emp_ID) and DEPT (Dept_ID, Dept_Name)
EMP(Emp_ID, Dept_ID) and DEPT(Dept_ID, Dept_Name)
EMP(Emp_ID, Dept_ID) and DEPT(Dept_Name)
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!