1) You are given the following schema state and are told that each student has only one Head Advisor ID, but can have many Advisor IDs. a. Reflect the above constraint using functional dependencies. b. Normalize the table to 3NF. Explain every step in your normalization procedure: 60 over each normal form and evaluate if the relation abides to it or not. Explicitly not the violations you identify and how you handle them, as well as the result of handling each violation. Student Student Advisor Advisor Head Advisor Id Name ID Name ID 13 13 14 14 14 Ruth 26 Luke 14