The following table shows a relation called GRADE REPORT for a university.

Your assignment is as follows:

a. Draw a relational schema and diagram the functional dependencies in the relation.

[your results should be like this. You dont need to indicate the transitive dependency, partial dependency, and functional dependency. But you need to draw out all dependencies.]

b. In what normal form is this relation? In your answer you should explain why it is in X normal form and why not in other normal forms.

c. Decompose GRADE REPORT into a set of 3NF relations. In your answer, please just list all decomposed relations, you dont need to add any connections or dependencies in these relations.

I need help with B&C thank you!