ANSWER IT ASAP PLEASE

Answer the following questions based on the functional dependencies for a relation as provided below:

Unit (UnitCode, UnitName, CourseCode, CourseName, Fees)

Functional Dependencies:

UnitCode -> UnitName, CourseCode, Fees

CourseCode -> CourseName

Questions:

a. Does this relation contain a transitive dependency? If so what is it? (3 marks)

b. Create new relations to remove transitive dependency. Make sure to include primary and foreign keys for all relations. (3 marks)