Consider the following table which is used to store records of students and courses. student_stane Major Course ID Course_Name Instructor Instructor ID ID Instructor Location Grade cisel, 101, 102, 101, L02. 103 LO3 4114123 John Smith James, Andrew Peter COPOI, COPO2, COP03 CISE A, A, B cise2, cise 3 business, 104,104 Alan, Alan 104, 104 3124234 Roger Hicks Business B001, BUO2 business 2 a) Normalize the table to the 1st Normal Form, show the resulting table(s) with their data, and explain your answer. b) Explain the criteria for 2nd Normal Form informally and normalize the table you obtained from the previous part to meet them. Then explain which anomalies can occur with your answer. c) Explain the criteria for 3rd Normal Form informally and normalize the table you obtained for the previous question to meet them. d) Explain if the tables you obtained for the previous question is in BCNF and, if not, normalize it to BCNF. Consider the following table which is used to store records of students and courses. student_stane Major Course ID Course_Name Instructor Instructor ID ID Instructor Location Grade cisel, 101, 102, 101, L02. 103 LO3 4114123 John Smith James, Andrew Peter COPOI, COPO2, COP03 CISE A, A, B cise2, cise 3 business, 104,104 Alan, Alan 104, 104 3124234 Roger Hicks Business B001, BUO2 business 2 a) Normalize the table to the 1st Normal Form, show the resulting table(s) with their data, and explain your answer. b) Explain the criteria for 2nd Normal Form informally and normalize the table you obtained from the previous part to meet them. Then explain which anomalies can occur with your answer. c) Explain the criteria for 3rd Normal Form informally and normalize the table you obtained for the previous question to meet them. d) Explain if the tables you obtained for the previous question is in BCNF and, if not, normalize it to BCNF