Normalization

Show all the steps as you perform normalization for each problem up to 3NF. State your final relation to schemas in 3NF.

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