(Solved): need help!! Make a ERD diagram. thank you. Table 4-4 Grade Report Relation Table 4-4 shows a relati ...

Table 4-4 Grade Report Relation Table 4-4 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. b. In what normal form is this relation? c. Decompose GRADE REPORT into a set of 3 NF relations. d. Draw a relational schema for your \( 3 \mathrm{NF} \) relations and show the referential integrity constraints. e. Draw your answer to part \( \mathrm{d} \) using Microsoft Visio (or any other tool specified by your instructor).