. 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.

d. Draw a relational schema for your 3NF relations and show the foreign key connections between relations. [Based on the listed relations above, you only need to add foreign key connections between relations]

Help with D please! Thanks in advance