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 for data users identifying the different level of access for each user (you can assume the level of user access as needed)

Department Hiring Department 2100 2300 2520 2002 2890 2100 First Last Employee ID Name 0001 0002 0003 0004 0005 0006 John Brian James John Robert Paul Name Smith Miller Miller email jsmith@yahoo.com badams@gmail.com miller@vahoo.com ackson sam@gmail.com 5568 DavisQyahoo.com Extension Department ID 5775 5367 5432 Date | Phone # 8/1998 5700 4/1995 5300 8/1998 5400 6/1997 5500 1/2001 5600 5/20035700 407-366 407-366 407-366- 407-366 407-366- 407-366- Accounting Human resource Sales Marketin Production Jackson Davis 5642 Thompson thompsonp@yahoo.co 5744 Accountin