1. Consider the following relation that involves student data: GRADE (ClassName, Section, Term, Grade, Student ID, 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: Student ID -> Student Name (ClassName, Section, Term) -> ProfessorName ProfessorName -> Department, Professor Email What normal form is the relation in? Normalize it up to 3NF. 2. Given the EMPLOYEES relation below: Empno 25 Ename Clay Thaisz Good Baid Brown Lcode NJ5101 NJ5101 FL6321 NY2091 NY2092 17 57 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 3NF