Question 2 The following Table shows a relation called GRADE REPORT for a university. Grade Report Instructor Instructor StudentID StudentName CampusAddress Major CourseID CourseTitle Name Location Grade 168300458 Williams 208 Brooks IS IS 350 Database Mgt Codd B 104 A 168300458 Williams 208 Brooks IS IS 465 Systems Analysis Parsons B 317 543291073 Baker 104 Phillips Acctg IS 350 Database Mgt Codd B 104 n 543291073 Baker 104 Phillips Acctg Acct 201 Fund Acctg Miller H 310 543291073 Baker 104 Phillips Acctg Mkgt 300 Intro Mktg Bennett B 212 A 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? (INF, 2NF or 3NF) c) Decompose GRADE REPORT into a set of 3NF relations. d) Draw a relational schema for your 3NF relations and show the referential integrity constraints