Convert the following table into the previous relation in a normalized Boyce-Codd Normal Form (BCNF)

 

Employee First Last ID Name Name 0001 0002 0003 0004 0005 0006 0007 John Smith Brian Miller James Miller John Jackson Robert Davis email Sandy Davis jsmith@yahoo.com badams@gmail.com miller@yahoo.com jackson_sam@gmail.com Davis@yahoo.com Paul Thompson thompsonp@yahoo.com SDavis@yahoo.com Title Accountant 1300 Admin Assistant Inventory Manager Sales Person Manager Address Market Analyst West st 5775 1552 Palm dr. 5367 2713 Buck rd 5432 433 tree dr 713 corner st 205 Bridge dr Manager 713 Corner st Extension Department ID 5568 5642 5744 5702 Accounting Human resource Production Sales Production Marketing Department Hiring Date Accounting 2100 2300 2520 2102 2520 2101 2100 8/1998 4/1995 8/1998 5400 6/1997 1/2001 5/2003 Department Phone # 407-366- 5700 407-366- 5300 407-366- 11/1999 407-366- 5500 407-366- 5400 407-366- 5600 407-366- 5700