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

$16830045$

Williams

$208$ Brooks

IS

IS $350$

Database Mgt

Codd

B $104$

A

IS $465$

Sys$.$ Analysis

Parsons

B $317$

B

$54329107$

Baker

$104$ Philips

Acctg

IS $350$

Database Mgt

Codd

B $104$

C

Acct $201$

Fund Acctg

Milier

H $310$

B

Mkgt $300$

Intro Mktg

Bennett

B$212$

A

Assume 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 $3$NF$.$