SQL Normalization Please explain the question as specific as possible!

2. Given the following universal table ProjNo ProiName EmpNo EmpName JobClass P15 P15 P15 P22 P22 HourlyRate Hours 97.50 110.00 Evergreen E101 John G. Evergreen E201 Anne K. Evergreen E307 Travis B. Clerical Support 35.75 Lone Star E201 Anne K. Lone Star E333 Josh H. Elec.Engineer DB Designer 35 DB Designer Clerical Support 35.75 31 3 4 24 110.00 and the following functional dependencies (ProjNo, EmpNo) >(ProjName, EmpName, JobClass, HourlyRate, Hours) ProjNo -> ProjName EmpNo > (EmpName, JobClass, HourlyRate) JobClass HourlyRate decomposeormalize the above table to obtain tables in the Boyce-Codd normal form (BCNF). 15 pts.] Note: You do not have to show the step-by-step normalization process; write only normalized tables. . As the answer, write a relational model description that consists of table names, attribute names, primary key designations, and foreign key references. For instance, faculty (fac no, name, dept) faculty.fac no primary key offering (offer_no, fac_no, semester, year) offering.offer no primary key offering.fac-no references faculty.fac_no