Normalize to BCNF using the 4 step straight-to-BCNF process. Show work. List final set of relations normalized to BCNF. Include schemas for all normalized relations. Indicate primary, foreign, and surrogate keys in final schemas.

1. 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 PTitle P Manager PBudget PDept PDuration ENum EName ECity EZip EDeptNO EDeptName HRate Payroll Martin 100K Accounting 12 i2 P1 E13 A Smith Liberty 64068 D4 | E30 L Jones!Liberty 64068_ D3 R&D IT Martin 100K Accounting 18.5 P1 Payroll Martin 100K Accounting P2 Budget Baker 780K Finance P2 Budget Baker 780K Finance 16 E13 A Smith Liberty 64068D4 R&D 18 P2 Budget Baker 780K Finance P3 HiringLewis 100K HR P3Hiring Lewis 100K P4 Millennium Lewis 780K Finance P5 Millennium Martin 200K E31 P Jouet Liberty 64069 D4 E11 R Ali Liberty 64069 D4 R&D E9 S Gilbert Buckner 64076 DS Management 25.5 16 24 24 12 E9 S Gilbert Buckner 64076 D5 Management E31 P Jouet Liberty 64069 D4 E10 KRoss Buckner 64076 D8 23.25 17 17 HR Sales T-HRT-12-TE27TASmith|Buckner 64076 D- Operation 16.5 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)