Given the following is a relation with no known repeating gr…
Given the following is a relation with no known repeating groups: PROJECT-TEAMS(pCode, pName, pStart, pEnd, empID, eFName, eLName, jobTitle, empClass, consultRate, projPosition, projHour, projStart, projEnd, projRate) Dependencies: pCode –> pName, pStart, pEnd empID –> eFName, eLName, jobTitle, empClass, consultRate pCode, empID –> projPosition, projHour, projStart, projEnd, projRate jobTitle, empClass –> consultRate NOTE: Primary keys must be solid underline. Since dashed underline cannot be drawn — foreign keys must be clearly designated with (FK) next to attribute. Copy-paste below part into your answer and fill in your answer following each question A) Provide 1NF solutions below using relational notation. B) Provide 2NF solution below using relational notation. C) Provide 3NF solution below using relational notation.