1. After examining the table carefully identify the functional dependences
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) ***PLEASE ANSWER ALL 5 QUESTIONS, MAKING TABLES WOULD HELP TREMENDOUSLY AS WELL***

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