Part 4: Normalization (20 points) For this part, consider the following table and functional dependencies id name GPA major school 17 Alice 3.5 CS Engineering 32 Bob 3.5 CS Engineering 43 Christine 3.0 Aerospace Engineering 67 David 3.8 English LSA 78 Eve 4.0 Math LSA 90 Alice 3.8 Astronomy LSA F = {id name, GPA, major, school; GPA major; school major; name, major id} 1. List the candidate keys for this relation using ONLY the functional dependencies (4 points) 2. Is the relation 3NF? Justify your answer (6 points) 3. Is the relation BCNF? Justify your answer (6 points) 4. Which of the functional dependencies are violated in the snapshot of the table provided? (4 points)