The following table shows a partial list of grades earned by students in Computer Science and Information Systems classes:

GradeReport

StudentID StudentName CampusAddress Major CourseID SectionNbr InstructorID InstructorOffice Grade

$168300458$ Brent Williams $208$ Hillcrest IS BIS $37012-1051123$ DA $230$ A

$168300458$ Brent Williams $208$ Hillcrest IS BIS $37512-3453245$ DA $233$ B

$856420192$ Charlie Miller $1412$ Maple IS BIS $37012-7432786$ DA $235$ B$+$

$543291073$ Susan Baker $112$ Claremont CS BIS $37512-3453245$ DA $233$ C

$543291073$ Susan Baker $112$ Claremont CS CS $12112-2571765$ PTC $205$ B

$543291073$ Susan Baker $112$ Claremont CS CS $23012-5111987$ PTC $310$ A

Field Descriptions:

StudentID $$ ID number of the student

StudentName $$ student$$s name

CampusAddress $$ student$$s local address

Major $$ student$$s major $($students are allowed one major$)$

CourseID $$ ID number of the course

SectionNbr $$ number of the section $($a section number is generated for a specific course, on a specific day$/$time$,$ with a specific instructor; a course can have many sections but a section is for only one course$)$

InstructorID $$ ID number of the instructor who taught the section

InstructorOffice $$ building code and room number of the instructor$$s office

Grade $$ grade received by the student in the given section

$1.$ Use arrows to show the functional dependencies in the table.

$2.$ Convert the table to $3$NF$.$