1. After examining the table carefully identify the functional dependencies

2. Identify the candidate keys

3. Put the previous relation (table) in a normalized Boyce-Codd Normal Form (BCNF)

4. If you have multiple values for the department phone number what will be the best solution to convert the data into relations.

5. Secure the database by creating a third relation (table) for data users identifying the fields needed (you can assume the level of user access as needed)

First ress Hiring Date |Phone # 811998 1995 811998 6/1997 1/2001 ID Name Last Name email ExtensionDepartment ID John Smith Brian Miller James Miller John Jackson Robert Davis West 0001 0002 0003 0004 0005 Accountin Human resource 5775 Assistant Palm gt 5367 Buckrd 5432 5568 corner st 5642 hyahco.com min badams@gmail.com Production Sales Production milleryahoo.com ckson sam@gmail.com Person st Davisyahco.com Analyst Bridge 0006 Paul Thom 5744 Marketin 5/2003 11/199 st