Homework #4: Normalization 1. Consider the following relation that involves student data: GRADE (ClassName, Section, Term, Grade, StudentId, StudentName, ProfessorName, Department, Professor Email) 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) -> Professor Name ProfessorName -> Department, Professor Email What normal form is the relation in? Normalize it up to 3NF. 2. Given the EMPLOYEES relation below: Emp_no 25 23 Ename Clay Thaisz Good Baid Brown Lcode NJ5101 NJ5101 FL6322 NY2091 NY 2092 Lstatus 1 1 4 3 3 17 57 The relation schema for the above relation is EMPLOYEES (Emp_no, Ename, Lcode, Latatus), where Emp_no: employee number Ename: employee name Lcode: location code Lstatus: location status, cach location has a status code What normal form is the relation in? What are the dependencies? Normalize it up to 3NF. Submission Instructions 1) Type up your solutions for both problems making sure that you answer all questions for each problem. Also, make sure that you show all of the steps as you perform normalization for each problem up to 3NF. Clearly state your final relation schemas in 3NF. Submit the homework through the assignment link on Blackboard found in Module 06. Good Luck