3NF (continued)
One solution:
- Emp (enum, ename, sal, mgr)
- Dept (dnum, dname, mgr)
- Removes the redundancy
- A problem remains:
This is an example of a lossy-join decomposition, which is avoidable in 3NF.
Use Emp1 (enum, ename, sal, dnum) instead of Emp.