please a,b 1.23 in detail

Simple Technology, a Kansas based company, is working on a project to design and implement a database for tracking employees, their personal information, and information about projects. Some of the attributes that they want to store in the database is given as a tabular format belo 1. PCode PTitle PManager PBudget PDept PDuration ENum EName ECity EZip EDeptNo EDeptName HRate Payroll Martin 100K Accountin P1 P1 Payrol Martin 100K Accounting 1 P1 Payroll Matin 100KAccounting 12 P2 Budget P2 Budget P2 Budget E13 A Smith Liberty 64068 E30 L Jones Liberty 64068D3 D4 R&D IT R&D R&D R&D 18.5 21 21 E31 P Jouet Liberty 64069 D4 Baker 780K Fnance Baker 780K Finance Baker780K Finance Lewis Lewis E11 | R Ali Liberty/64069/ D4 E13 A Smith Liberty 64068 D4 E9 S Gilbert Buckner 64076D5 Management2 E9 S Gilbert Buckner 64076 D5 E31 P Jouet Liberty 64069 D4 E10 K Ross Buckner64076 D8Sales P3 P3 P4 MillenniumLewi P5 Millennium Martin 200K Hirin Hiring 100K 100K 780K Finance HR HR 24 24 12 anagement 23.25 17 17 R&D 12 E27 A Smith Buckner 64076 D9 Operation HR a) Write all functional dependencies for the above relation. (40 points) b) Using step-by-step process, normalize the above relation to BCNF. Make sure you go through all normalization steps from INF to BCNF. Show your work. Your work must include the following: Indicate all anomalies lead to the violation of each normalization conditions List schemas for the final set of relations that are normalized to BCNF. Make sure to indicate all the primary, foreign, and surrogate keys (if used) in the final schemas. i. ii. ii. Indicate referential integrity constraint for the final set of schemas nd nroiect to design and