Simple Technology, a Kansas based company, is working on a project to design and implement a database for tracking employees, their personal information such as their address and salaries, and projects. Some of the attributes that they want to store in the database is given as a tabular format below. PCode PTile PManager PBudget PDept PDuration ENum EName ECity EZip EDeptNo E.DeptName BIRate P1 Pavroll Martin 100K Accounting 12 RAD 22 IT R&D R&D R&D E13 A Smith Liberty 64068 D E30 L Jones Liberty 64068 D E31P Jouet Liberty 64069 D E11 RAli Liberty 64069 D4 E13 A Smith Liberty 64068D4 E9 S Gilbert Buckner 64076 DS Management 25.5 E9 S Gilbert Buckner 64076 DS Management 23.25 E31 P Jouet Liberty 64069D4 E10 K Ross Buckner 64076 D8 E27 |A Smith Buckner 64076 D9 Operation 165 P1 PayrollMartin 100K Accounting 12 Pi Payroll Martin 100K Accounting 12 18.5 2 1 P2 Budget Baker 780K Finance P2 Budget 16 16 16 24 24 Baker 780K Finance 780KFinance Budget Baker P3 Hiring P3 Hiring Lewis 100K Lewis 100K HR HR R&D Sales 17 17 P4 Millennium Lewis 780K Finance P5 Millennium Martin 200K HR 12 Using straight-to-BCNF process normalize the above relation to BCNF. Make sure you follow the four step process. Show your work. List final set of relations that are normalized to BCNF Include schemas for each of the final set of relations. Indicate all the primary, foreign, and surrogate keys in the final schemas. (40 points)