Assignment 2 The figure below shows a table called GRADE REPORT for a university. StudentID Student_ Name Campus_ Address Major CourseID Course_ Title Instructor_ Name Instructor_ Office Grade 1683004

Assignment 2The figure below shows a table called GRADE REPORT for a university.StudentIDStudent_NameCampus_AddressMajorCourseIDCourse_TitleInstructor_NameInstructor_OfficeGrade16830045Williams208 BrooksISIS 350Database MgtCoddB 104AIS 465Sys. AnalysisParsonsB 317B54329107Baker104 PhilipsAcctgIS 350Database MgtCoddB 104CAcct 201Fund AcctgMilierH 310BMkgt 300Intro MktgBennettB212AAssume that students can take multiple courses and has only one major; also assume that one course is taught by one professor.1) Describe deletion, update, and insertion problems for this table.2) In what normal form is this table?3) State the functional dependencies in this table.4) Then decompose this table into 3NF.