Homework #$4$: Normalization

Consider the following relation that involves student data:

GRADE $($ClassName$,$ Section, Term, Grade, StudentID, StudentName, ProfessorName, Department, ProfessorEmail$)$

Assume that only one professor teaches a class section, and professors teach in only one department. Suppose the following dependencies exist:

StudentID $->$ StudentName

$($ClassName$,$ Section, Term$)->$ ProfessorName

ProfessorName $->$ Department, ProfessorEmail

What normal form is the relation in$?$ Normalize it up to $3NF.$

Given the EMPLOYEES relation below:

$\backslash$table$[[$Emp$\_$no$,$Ename,Lcode,Lstatus$],[25,$Clay,NJ$5101,1],[23,$Thaisz,NJ$5101,1],[38,$Good,FL$6321,4],[17,$Baid,NY$2091,3],[57,$Brown,NY$2092,3]]$

The relation schema for the above relation is EMPLOYEES $($Emp no$,$ Ename, Lcode, Lstatus$),$ where

Emp no: employee number

Ename: employee name

Lcode: location code

Lstatus: location status, each location has a status code

What normal form is the relation in$?$ What are the dependencies? Normalize it up to $3$NF$.$